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

Check box to be used as SSRS report parameter Expand / Collapse
Author
Message
Posted Monday, December 9, 2013 3:17 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, November 5, 2014 4:54 AM
Points: 611, Visits: 1,149
Hi,
I want to have a checkbox to be used as SSRS report parameter. Is there any way to implement that? Can I try using a combo with two values or using custom code?
Post #1520980
Posted Monday, December 16, 2013 3:21 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, July 25, 2014 10:05 AM
Points: 122, Visits: 292
http://stackoverflow.com/questions/259390/how-do-i-best-display-checkboxes-in-sql-server-reporting-services

______________________________________________________________________

Ankit
MCITP Database developer SQL 2008,MCTS Database Administration SQL 2008
"Remembering that you are going to die is the best way I know to avoid the trap of thinking you have something to lose.
You are already naked. There is no reason not to follow your heart.”
Post #1523138
Posted Monday, December 16, 2013 8:22 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:02 AM
Points: 7,013, Visits: 7,180
To see checkboxes in a parameter you have to set 'Allow multiple values'.
This will show a drop down list with checkboxes.
You cannot prevent the user selecting multiple values or the all option.
You can reference each occurance of the parameter.



Far away is close at hand in the images of elsewhere.

Anon.

Post #1523261
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse