Skip to Content
Former Member
Feb 25, 2009 at 01:14 PM

Sub Report in page header. Stored procedure call issue



I have a report with a sub report in the page header section. The sub report shows same information(project info) in each page. But it will call the procedure(spProjectInfo) for each page. ie if the report has 10 pages then will call the procedure 10 times( 10 call to 'spProjectInfo') which is not required since all page header shows the same information. How we can avoid his. Main report procedure is different.

We created the sub report because we need to show the same information in many reports.

Thanks in advance...