May 24, 2006 at 4:41 pm
Hello all,
I have a report that is driven by a stored procedure. Report contents are exported to a .pdf file and delivered to a mailing house. This report has a drill through subreport that is driven by the same procedure. The subreport summarizes the data contained in the main report. When the subreport is fired the stored procedure is executed again. This is undeliverable for two reasons. 1) Execution time. 2) Due to the dynamic nature of the data it could produce differing results. Does anyone know how to re-use the data set produced by the first execution of the procedure?
Thanks
May 25, 2006 at 6:29 am
If you're using the same dataset, is there a reason why you're using a subreport? I'd suggest eliminating the subreport and then using toggles to hide/display this section.
May 25, 2006 at 5:52 pm
I Agree with David. Sub reports re-execute the SQL query, no avoiding it. Thats what makes them a little undesirable unless you have good reason to use one.
You may be able to reproduce the output desired with different grouping of the original query, or you can add another matrix or table object to the report body. point the datasource of your new (lets say table) object at your proc and lay it out how you like.
Hope that helps.
Martin
May 25, 2006 at 5:56 pm
My dilema, at least as I see it, is that the parent report has the page footer spoken for. I could add a second table to the body, but then how would I hide the footer?
Mike
May 25, 2006 at 6:23 pm
Not that sure what you mean by spoken for.. but...
You can simply hide the whole page footer by turning it off in the report properties. Or if you have something in the page footer that you need on every page, then you could go into your first table properties and set a "Page Break After" to ON?
Remember you have table and group headers and footers for each object so you might be able to use them too..
Martin
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply