cancel
Showing results for 
Search instead for 
Did you mean: 

Not having to refresh the data in the main report but only in the subreport

Former Member
0 Kudos
61

Hi SAP,

I have a report that uses a stored procedure in the main report and uses regular database tables in the subreport. The data returned from the stored procedure reports information from the month-end database (a cutoff point from the previous month's numbers) while the subreport reports information from the live database. This report gets run everyday to show the changes in numbers from the live database. Obviously the numbers from the month-end database remainds static until the next month's cutoff database is created.

My problem is that everyday when I run the report, the data needs to refresh from both the stored procedure in the main report and the live database tables in the subreport. How can I leave the data returned from the stored procedure static or as is without refreshing the stored procedure returned data and just have the subreport data refresh itself? The stored procedure really puts a strain on the database and I would like to cut-out the time to process the report as well. Does anyone have any ideas?

Zack

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Zack,

Try the following under Report options.

1. Clear the check box of "Verify Stored Procedures on First Refresh" in the Main report.

2. Select the check box of "Verify on First Refresh" in the sub report.

Hope this helps.

Former Member
0 Kudos

Mohamed,

Thanks for your reply to my question. Unfortunately, those were my settings already. When I hit refresh, it refreshes the main report along with the subreport. How can I just refresh the subreport? Any ideas?

Thanks,

Z