Hello,
I need to generate a report, which should display 4 reports. Two tables and some charts. I have all these reports (I mean the .RDL files) individually. I can render the reports separately. But, now the need is to combine these reports in the one RDL file. Is this possible? If yes, how?
Also, I tried to create a stored procedure, which would call all these 4 SP inturn and provide 4 result sets. I thought of have an RDL by calling only this SP which would give 4 result sets. But infortunately, it gave only the first SP's result set. So, I have to combine the 4 RDL files into one to show on the Reporting Console. Can anyone please help me in this? Help would be grately appreciated.
Thanks a lot. Let me know if the question is not clear.
Mannu.
Well let's see.
You would need to create 4 datasets, one for each of the original reports. You can do this on the data tab by clicking the dataset drop down and Add new dataset.
Then, copy and paste each of the individual layouts into this "super" report.
On each of the tables and charts, go to the properties for the table or chart and select the appropriate dataset as the "dataset name" that you created.
|||Yes GregSQL gives you right approach for the problem but there is a catch.
If you create 4 datasets using same SP that will still give you the first resultset. To overcome this issue I believe you have to pass an extra parameter say ReportType with datatype as Char. Give a condition in SP to return the Dataset you want to return for that perticular ReportType.
IN StoredProcedure:
IF @.ReportType = 'A'
BEGIN
YOUR DATASET
END
IF @.ReportType = 'B'
BEGIN
YOUR DATASET
END
Comming to report , click on each Dataset and go to Parameters section and give the ReportType value for each dataresult.'A' for First Dataset, 'B' for Second Datset.
I think this will complete the whole scenario...
Hope this helps
