Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

paameter did not work in report Expand / Collapse
Author
Message
Posted Friday, May 30, 2014 11:16 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Sunday, June 8, 2014 6:49 PM
Points: 27, Visits: 82
Hi all i added a parameter in my SSRS project but it didn't work and the value selected in combobox are repeated not distinct how can i solve the problem this is a snap shot

  Post Attachments 
error.png (9 views, 28.05 KB)
Post #1576214
Posted Monday, June 2, 2014 1:53 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 3:11 PM
Points: 2,134, Visits: 12,270
Not much to go on here, but there are two parts to filtering a dataset if you are using report-level parameters that you define yourself (as opposed to inheriting them from the dataset your report is based on).

First, you define the report-level parameters. (Right-click on the Parameters folder and create one.) Then you have to add a filter to your dataset. Right-click the Dataset, select Properties, Select Filters, then ADD. Then you can link your report-level parameter to the dataset-level parameter. Then you should be all set.
Post #1576751
Posted Monday, June 2, 2014 2:09 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 2:09 AM
Points: 15,501, Visits: 13,163
prepaess (5/30/2014)
Hi all i added a parameter in my SSRS project but it didn't work and the value selected in combobox are repeated not distinct how can i solve the problem this is a snap shot


How did you configure the parameter? Where does it get its values from?




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1576763
Posted Wednesday, July 2, 2014 12:28 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, April 20, 2016 12:27 AM
Points: 117, Visits: 193
Right click on the parameter you just created and go to parameter properties.
Select Available Values.
click on Get Values from a Query.
Select the Dataset which you created to get Distinct values, Value and Lebel fields.
Post #1588291
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse