I see this question on the forums all the time and thought it was worth a repost here. Just this week, at least two people on the MSDN forum for Reporting Services have asked how to add radio buttons or check boxes to a report.
Can this be done?
No, …I mean Yes, …well, sort of.
Many new report designers who have an application development background tend to treat Reporting Services as an app development tool at it's not. Although you can embed code into a report, you cannot add controls in the same way that you would in a web form or windows form project. Report "controls" are known as "report items" and are generally for displaying data, not gathering input. The report parameters don't give you explicit control over the way users are prompted for input values and typically display values in a drop-down list. If you really need to create a custom interface to prompt for parameter values, you can create a custom web form and then use the ReportViewer control or generate a URL string to launch the report, but this is an exception to the standard reporting experience. You can do a lot of creative things with SSRS but the design approach is much different that application development. For newcomers I recommend that you pick up a good book on Reporting Services and learn the how the product was designed to function, rather than spending a lot of extra effort customizing it.
When I’m asked if it’s possible to do something in Reporting Services, I try to frame the need I one of three categories:
Here’s a way to add checkboxes to a report that can be used for interactive selection. The same technique could be used to add radio buttons. These techniques fit into category 3 in the above list.
Using checkboxes to select/deselect items & choose parameters