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.
| Author |
Topic |
|
jonathans
Starting Member
40 Posts |
 Posted - 2005-05-31 : 10:06:37
|
| Hey guys,I am trying to write a report that executes a fixed Dataset based on incomming parameters into the report. Then, once the report is populated, the user clicks on a column row and that will populate a 2nd dataset based on the calling rows ID.The problem I am having is executing the 2nd Dataset, and then also executing with a parameter passed from the column row.Any idea's on how to do this?I can't really do a rollup, because of the nature of the data.WARNING: Running on cold coffee! |
|
|
But_Why
Starting Member
4 Posts |
Posted - 2005-06-01 : 23:38:22
|
| I'm doing this. The way i've done it is to create a new report for the sub information. Then create a parameter for that report, which is passed from your main report. In your main report, have the parameter that is passed, make it a column in the main report query. hmm thats kinda hard to describe. Let me know if you're still working on this and this description isn't good enough |
 |
|
|
jonathans
Starting Member
40 Posts |
Posted - 2005-06-03 : 08:12:10
|
| The reports are basicly circular links, until the last level. At this last level our client wants to be able to click on a total for a line and have the summary details for that total display popup in a "window".I actualy gave up on this, and ended up creating another linked report level, though this looks messy, but it works.WARNING: Running on cold coffee! |
|
|
|
|
|
|
Multiple Datasets