March 21, 2014 at 1:14 am
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.
March 21, 2014 at 2:07 am
What is the source for your report? A database or a cube?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 21, 2014 at 8:39 am
Sorry, MS SQL Server database
March 21, 2014 at 8:44 am
How exactly did you implement the multi-select for the companyID parameter?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply