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 2005 Forums  Analysis Server and Reporting Services (2005)  Querying the Results of the Main Report

Author  Topic  Chad_C Starting Member 7 Posts Posted - 2010-03-10 : 08:57:29 I've tried every Google search term I can think of, and looked at various books on the subject on O'Reilly's Safari site, but I cannot accurately describe what I would like to accomplish (if it is even possible). The end goal is to design a parameterized report for Dynamics CRM 4. I have a main report that returns information about projects and their current status in its dataset. I have a subreport that needs to provide totals from this main report. I have a query for each that works properly, but what I would really like to do is query the main report from the subreport. I would like to run the query I have in the subreport AGAINST the data returned from the main report. Do I need to add parameters to the main report and then pass that information to the subreport? If so, how do I construct the query to run against the dataset returned by the main report as opposed to going back to the database? I will be happy to provide clarification if necessary. Thanks in advance for any pointers, books on the subject, etc.