radio button in Reporting Services 2000

Hi all,
I am using SQL Reporting Services 2000. In a report I need to have
radio buttons to give the input into query for a report. Does anybody
have idea about how to use the radio buttons into reports.
Thanx
~kHey SSRS doesn't have an option of placing radio buttons. check ut in the
toolbar of SSRS.
Amarnath
"kuls" wrote:
> Hi all,
> I am using SQL Reporting Services 2000. In a report I need to have
> radio buttons to give the input into query for a report. Does anybody
> have idea about how to use the radio buttons into reports.
> Thanx
> ~k
>

radio button data binding-how?

hi,

i have a DB that contains some tables.so i have a radio button group of tow radio button to display a field.

now how can i bind this radio button group to this field for updating and insert a new record?

for more explain i brought a little of code below:

in .aspx page i have:

<asp:RadioButton ID="admin" runat="server" Checked="True" GroupName="membertype" Text="admin" OnCheckedChanged="admin_CheckedChanged" /><br /> <asp:RadioButton ID="member" runat="server" GroupName="membertype" Text="member" />

-----------------------

<asp:ControlParameter ControlID="membertype" Name="isadmin" Type="string" PropertyName="text" />

-----------------------

UpdateCommand="UPDATE UserManagement SET UserName = @.UserName, Password = @.Password, FullName = @.FullName, Description = @.Description, UserID = @.UserID ,isadmin=@.isadmin,usercitycode=@.location WHERE (UserID = @.Original_UserID)"

note that the type of the "isadmin" field is "nvarchar(50)"

thanks,

M.H.H

Have you considered using a RadioButtonList control instead? With this, you can bind the SelectedValue property to your Parameter.

|||

thanks for your reply,

no i dont use radiobuttonlist because it doesnt have any groupname property.

so i want to join two radio buttons.

i dont know how can i do this because im starter.

thanks,

M.H.H

Radio button - not reqire to select!

I am currently using a web form to insert data into SQL DB.
The radio button for Gender is not a require field.
currently if I use this command is in VB
' cmd.Parameters.Add(New SQLParameter("@.Gender", rblGender.SelectedItem.text)) >
it work fine if the user select one of the radio button, if the user don't select any button then it will give an error.
so I thought I can try the if else statement to see if it work, unfortunately it didn't either and error out on rblGender.SelectedItem.text
ex.
If rblGender.SelectedItem.text <> "" then
cmd.Parameters.Add(New SQLParameter("@.Gender", rblGender.SelectedItem.text))
Else
cmd.Parameters.Add(New SQLParameter("@.Gender", ""))
End IF
Any help would be appreciated.
hydro

You could do something like this:
If rblGender.SelectedIndex <> -1 then
cmd.Parameters.Add(New SQLParameter("@.Gender", rblGender.SelectedItem.text))
Else
cmd.Parameters.Add(New SQLParameter("@.Gender", DbNull.Value))
End IF
|||

That work!! Thanks!!

hydro

sql

Radio button

Hi,

I have one report,in my report i need to display parameters like this:

one radio button :Age and another radio button is Age Ranges

For the Age,I have to dispaly like two text boxes named 'From' and 'To'

For the Age Ranges,I have to display one drop down list contains values :20s,30s ..

In Reporting Services,Putting the Radio button is not possible,i think,If possible how to achive this.

Other workaround is i think Multivalued parameter which displays the Age and Age ranges

When we click on Age we need to display 2 textboxes

When we select Age Ranges we have to display Drop down list

If we select both :both 2 text boxes and drop down list.

Putting multi valued parameters for this requirement is not good and this is not the multi valued parameter concept.Please clarify me whether iam correct or not.

Thanks in advance

Your requirements go beyound the standard parameter prompts. Consider implementing a custom application to handle the parameters and use the ReportViewer controls to render reports.|||

Hi,

How to implement the custuom application,Please provide me the links.

Thanks in advance

|||http://www.devx.com/dotnet/Article/30424/0|||

Hi,

The article describing about the WinForms Report Viewer control. not the creation of custom application.

Thanks

|||By custom applications I meant WinForms or web-based applications you write. You can use the ReportViewers controls to render reports in custom .NET-based applications.

Radio Button

I have a radio button that i checked depending on a staement. The
problem is that if i want to uncheck it ,it doesnt allow. Is it
possible to uncheck it. heres the code i used for the radio button:
<input type="radio" name="MediaName" value="Others" <% If tel1=tel2
Then %> Checked<% End If %>>Hi
How does it relate to SQL Server?
"amatuer" <njoosub@.gmail.com> wrote in message
news:1152610467.056597.326740@.35g2000cwc.googlegroups.com...
>I have a radio button that i checked depending on a staement. The
> problem is that if i want to uncheck it ,it doesnt allow. Is it
> possible to uncheck it. heres the code i used for the radio button:
> <input type="radio" name="MediaName" value="Others" <% If tel1=tel2
> Then %> Checked<% End If %>>
>|||it doesnt,i put it on the wrong group by mistake
Uri Dimant wrote:[vbcol=seagreen]
> Hi
> How does it relate to SQL Server?
>
> "amatuer" <njoosub@.gmail.com> wrote in message
> news:1152610467.056597.326740@.35g2000cwc.googlegroups.com...

Radio Button

I have a radio button that i checked depending on a staement. The
problem is that if i want to uncheck it ,it doesnt allow. Is it
possible to uncheck it. heres the code i used for the radio button:
<input type="radio" name="MediaName" value="Others" <% If tel1=tel2
Then %> Checked<% End If %>>Hi
How does it relate to SQL Server?
"amatuer" <njoosub@.gmail.com> wrote in message
news:1152610467.056597.326740@.35g2000cwc.googlegroups.com...
>I have a radio button that i checked depending on a staement. The
> problem is that if i want to uncheck it ,it doesnt allow. Is it
> possible to uncheck it. heres the code i used for the radio button:
> <input type="radio" name="MediaName" value="Others" <% If tel1=tel2
> Then %> Checked<% End If %>>
>|||it doesnt,i put it on the wrong group by mistake
Uri Dimant wrote:
> Hi
> How does it relate to SQL Server?
>
> "amatuer" <njoosub@.gmail.com> wrote in message
> news:1152610467.056597.326740@.35g2000cwc.googlegroups.com...
> >I have a radio button that i checked depending on a staement. The
> > problem is that if i want to uncheck it ,it doesnt allow. Is it
> > possible to uncheck it. heres the code i used for the radio button:
> > <input type="radio" name="MediaName" value="Others" <% If tel1=tel2
> > Then %> Checked<% End If %>>
> >