February 14, 2011 at 4:02 pm
I was hoping to use a shared dataset, that would be accessed by one or more subreports from the same main report.
I have a main report which contains data that spans a datetime range, starttime, endtime.
Inside this main report I have two sub reports, that show's some different summarised data for the same time range.
I want one of the sub reports to show data for the first half of the time range, and the other subreport to show data from the second half of the timerange.
I created a shared dataset which uses a stored procedure to retrieve the subset data. I set both my subreports to use this shared dataset, in the hope that one call would be made to the database, then each subreport would filter the data it needed. This of course wasn't what happened. When i run the report each subreport makes its own call to populate the shared dataset. The reason I only want one call for this dataset, is because in my stored procedure a sequence is being generated for each row.
Because there are two separate calls, my sequence values look like 1,2,3,4 for the first subreport, and 1,2,3,4,5 for the second subreport. When they should really be - 1,2,3,4,5,6,7,8,9 - spread over the two subreports.
Is there a way to achieve what I'm trying to do with subreports and shared datasets?????
July 27, 2011 at 1:47 pm
Hey what did you do to get what you need?
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply