Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

how to add radio buttons in ssrs reports Expand / Collapse
Author
Message
Posted Tuesday, April 16, 2013 6:46 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, September 12, 2014 2:11 AM
Points: 211, Visits: 4,540
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.
Post #1442714
Posted Tuesday, April 16, 2013 7:57 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, August 11, 2014 8:38 AM
Points: 359, Visits: 191
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).
Post #1442748
Posted Tuesday, April 16, 2013 8:40 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, September 12, 2014 2:11 AM
Points: 211, Visits: 4,540
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.
Post #1442780
Posted Tuesday, April 16, 2013 9:09 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, August 11, 2014 8:38 AM
Points: 359, Visits: 191
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.
Post #1442795
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse