SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


how to add radio buttons in ssrs reports


how to add radio buttons in ssrs reports

Author
Message
asranantha
asranantha
SSC-Addicted
SSC-Addicted (402 reputation)SSC-Addicted (402 reputation)SSC-Addicted (402 reputation)SSC-Addicted (402 reputation)SSC-Addicted (402 reputation)SSC-Addicted (402 reputation)SSC-Addicted (402 reputation)SSC-Addicted (402 reputation)

Group: General Forum Members
Points: 402 Visits: 4717
Hi friends i have small doubt in ssrs plese tell me how to solve

how to add radio buttions parameters in ssrs.that means
supose i nedd 2 parameters that are top2 salary radion button and top10 salary radio button
when ever we preview report in ssrs that time show that two radio button parameter and
what ever we select that radio button details will be show.
is it possible to add radio buttons in ssrs level.
plese tell me how we do in this sistuvation.
TaylorMade
TaylorMade
Mr or Mrs. 500
Mr or Mrs. 500 (512 reputation)Mr or Mrs. 500 (512 reputation)Mr or Mrs. 500 (512 reputation)Mr or Mrs. 500 (512 reputation)Mr or Mrs. 500 (512 reputation)Mr or Mrs. 500 (512 reputation)Mr or Mrs. 500 (512 reputation)Mr or Mrs. 500 (512 reputation)

Group: General Forum Members
Points: 512 Visits: 212
The only way to add radio buttons in SSRS is to have a parameter that is of data type "Boolean". Obviously you would then only be able to have 2 values of either "True" or "False" (or possibly 0 & 1) for that parameter. Then you could show top 2 or top 10 data based on the value this parameter in the "Visiblity" property. Alternatively, you could attempt to modify the sql with the parm, but simply having 2 data sections that you toggle would be much easier and more flexible IMHO (you would also need 2 datasets).
asranantha
asranantha
SSC-Addicted
SSC-Addicted (402 reputation)SSC-Addicted (402 reputation)SSC-Addicted (402 reputation)SSC-Addicted (402 reputation)SSC-Addicted (402 reputation)SSC-Addicted (402 reputation)SSC-Addicted (402 reputation)SSC-Addicted (402 reputation)

Group: General Forum Members
Points: 402 Visits: 4717
i developed report with 2data sets
1st dataset i write query like select top 2 sal,* from tablename
2nd dataset i write query like select top 10 sal,* from tablename
after that i create one parameter and get the values staticaly
like avilable values
label value
top2sal 1
top10sal 2
then
in design i takne 2 chart one chart for tot2 sal details and 2nd chart for top10 sal details i taken require fields
in chart.and
each chart i wrote expresion like
=iif(Parameters!topsalarylist.Value(0)=1,false,true)
and same way second chart write expresion =iif(Parameters!topsalarylist.Value(0)=2,false,true)
then i preview that reports that preview time i want radio buttons.
but whenever i process may way that time only check boxs came.but i wany radio button. when i take bollne values in this process.where i change in report while get radio buttons.plese give some information to solve this issuse.
TaylorMade
TaylorMade
Mr or Mrs. 500
Mr or Mrs. 500 (512 reputation)Mr or Mrs. 500 (512 reputation)Mr or Mrs. 500 (512 reputation)Mr or Mrs. 500 (512 reputation)Mr or Mrs. 500 (512 reputation)Mr or Mrs. 500 (512 reputation)Mr or Mrs. 500 (512 reputation)Mr or Mrs. 500 (512 reputation)

Group: General Forum Members
Points: 512 Visits: 212
It appears that when you add a label to any of the available values, even if it is a Boolean, it defaults to a dropdown list. If you create a boolean without labels. this will keep the radio buttons, then you could make the "Prompt" something like "Select True for Top 2, False for Top 10". Not the prettiest, but will work.


As an alternate solution, you could create a report without a parameter, and make a drilldown report. The base report would be for your Top 2, and the drilldown the Top 10. The drilldown toggle crosshair would act like your radiobutton, just some food for thought.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search