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

Select all parameter does not jump to another ssrs report Expand / Collapse
Author
Message
Posted Friday, March 21, 2014 1:14 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 30, 2014 4:43 PM
Points: 8, Visits: 138
Hello,

I am using SSRS 2005 I have three parameters 1st is "Month" 2nd is "Year" and the 3rd is "CompanyID". CompanyID has 5 different companies: NNA, NTB, NGB, NBA, NSS when I run the report the report comes out fine by company or when I press the Select All. Within the detail field I can click to different report (jump to report) it works fine providing I select one company I get the correct amount, but when I Select All companies I am only getting one company, which is not giving me the total amount from all companies. The detail report has the same three parameters. I just not getting the CompanyID parameters correct when I click on Select All. Can someone tell me what can I do to get the detail report having all the CompanyID and I want to print out all the companies on the report. I just getting one company when I click on the Select All. I would really appreciate someone helping me here. Thank you in advance.
Post #1553334
Posted Friday, March 21, 2014 2:07 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:05 AM
Points: 13,724, Visits: 10,680
What is the source for your report? A database or a cube?



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 #1553343
Posted Friday, March 21, 2014 8:39 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 30, 2014 4:43 PM
Points: 8, Visits: 138
Sorry, MS SQL Server database
Post #1553513
Posted Friday, March 21, 2014 8:44 AM This worked for the OP Answer marked as solution


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:05 AM
Points: 13,724, Visits: 10,680
How exactly did you implement the multi-select for the companyID parameter?



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 #1553516
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse