Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 SSRS Parmaters

Author  Topic 

rookie_sql
Constraint Violating Yak Guru

443 Posts

Posted - 2010-07-22 : 07:43:34
Hi i've a report with a link through to another detailed report when i select on a company column below.
If i select A it brings me to the detailed report for A, i have this part working. But what i can't get working is the week_no bit. If i view week no 10 from a drop down list and select A and as the company i want to just get the details for week 10 but i keep getting all weeks

Company Week No
A 10
B 20

-- Detailed report for A
Company Week No
a1 10
a2 10
a3 10


-- Detailed report for B
Company Week No
b1 10
b2 10
b3 10

iqmcl
Starting Member

8 Posts

Posted - 2010-07-22 : 09:30:43
can you also pass the week number as a parameter to the sub report, then filter it that way?
Go to Top of Page
   

- Advertisement -