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

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 (8 views, 28.05 KB)
Post #1576214
Posted Monday, June 2, 2014 1:53 PM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Yesterday @ 10:49 PM
Points: 774, Visits: 4,994
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


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 12:06 AM
Points: 13,735, Visits: 10,706
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 LessThanDot.

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

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Yesterday @ 11:31 PM
Points: 72, Visits: 181
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