Subreport dependant on main report - (resolved)

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

Development Tools

Reporting Services Development

Subreport dependant on main report - (resolved)

Author

Topic

But_Why
Starting Member

4 Posts

Posted - 2005-05-24 : 17:40:46

Hi,
I'm not sure if this is possible, but i've almost got it working and would like any tips on finishing it.
I've got a report, which breaks down further via subreports.
for example,
the main report is called Colours
the sub report is called Shades.
Colours has the following in it.
Red
Blue
Green

Shades has
light red
dark red
light blue
dark blue
light green

So for each report record, i've got
Red
light red
Red
dark red
Blue
light blue

etc...
Now i want to make it so the user can select what colour they want to see. I do this via a parameter. But now the reports don't work, cos i'm passing the colour from the Colours report to the Shades subreport as a parameter. It saids i can't have a forward dependancy which is what is happening in this case.
Can anyone suggest a better way?
If more explanation is required, please let me know.
Cheers
But_Why

But_Why
Starting Member

4 Posts

Posted - 2005-05-24 : 17:43:18

Ahh, nevermind, got it.
Thanks all

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources