how to add radio buttons in ssrs reports

Question

how to add radio buttons in ssrs reports

asranantha

SSCarpal Tunnel

Points: 4246
More actions
April 16, 2013 at 6:46 am

#271071

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.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

TaylorMade SSC Eights! Points: 967 More actions · Answer 1

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 SSCarpal Tunnel Points: 4246 More actions · Answer 2

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 SSC Eights! Points: 967 More actions · Answer 3

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.