SSRS DATASET FROM STORED PROCEDURE
Have a stored procedure that massages alot of data. It returns two sets of records. I would like to use the first set for the details of the main report and the second set as a subreport for those main report details. I could separate it into 2 sprocs, but would rather not since there's a lot hits to the server, why run it twice? When I refresh the dataset it only sees the first set of results. Anyway to make this work as is or should I just separate it?
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Excellent! I would love to see your solution. I believe my email is in my profile, if you don't mind sharing.
SSRS
SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.
10K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER
Also, thanks for the tip about Lookup function...never used it but now I will.