SSRS 2005 Subreport Launching Question

Question

SSRS 2005 Subreport Launching Question

Jim Howell

Ten Centuries

Points: 1010
More actions
October 9, 2008 at 7:39 am

#213859

I have a main report that requires two integer parameters; programID and modelID. Each program can contain many models, but a model can exist in only one program. Each model also contains many submodels. The main report displays data in a table and that data is grouped by submodel. I would like the subreport to display the detail data for the first submodel record when the main report is initially rendered and then redisplay data based on the users double-clicking the submodel cell in the main report table. Can this be done? 🙂
I've futzed aound doing Google searches and trying things that seem close, but as yet, to no avail.
Many thanks in advance!
Best --Jim

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Boyan Penev SSC-Addicted Points: 490 More actions · Answer 1

You can't achieve that in SSRS unless you separate the two reports and have a drill-through report (your subreport), which shows details about the item that the report user has clicked on.

But, you can use PerformancePoint, which offers the described functionality. There you can pass values between dashboard reports which can be dynamically refreshed.

Boyan Penev

Niraj-627298 Hall of Fame Points: 3641 More actions · Answer 2

Hi Jim,

I think it can be acheived by calling the sub reports parameters from the main report...If the main report and sub reports depends on a common parameter (S), then I guess it can be acheived.

Thanks,

Niraj

Boyan Penev SSC-Addicted Points: 490 More actions · Answer 3

The closest you can probably go with SSRS is described here:

http://digitalcamel.blogspot.com/2008/02/database-dependent-duo-delivers.html

Boyan Penev

Jim Howell Ten Centuries Points: 1010 More actions · Answer 4

Hey guys--

Thanks for the links and aadvice. I was able to find a way to do this, but it seems like a fairly large 'kludge' that we'll have to live with for a while. I ended up creating two identicle reports with the hyperlinks pointed to one another. A user can click on a field in the main report that launches the second report with all parameters filled, thus brining up the subreport with the proper child records. The second report links back to the first so the users can click another parent record, etc, etc.

It would be a nifty enhancement to SSRS to be able to do something like this with one report instead of two! In general, I've become a fan of SSRS. The next couple of iterations of the product should be a lot of fun.

Best --Jim

Boyan Penev SSC-Addicted Points: 490 More actions · Answer 5

Welcome! Yes, it still lacks a bit of functionality but most things users ask for can be implemented in one way or another.

Boyan Penev