Display last 4 weeks in a chart

[minu]

Hi All,

I have a weekly report. It is grouped by end date of every week ie, Friday. Now the content of the report goes on increasing as the weeks get added to it. There is a chart also. In this chart I want to display only the last 4 weeks from every time the report is generated. Currently all the weeks are shown. How do filter only the last 4 weeks in the chart in crystal.

Please see the attached report sample. Any help would greatly be appreciated.

Thanks
Minu

 

[Kempes]

I have a solution but not sure if there is an easier way.

Basically, if you add a subreport based on this data, you can choose your last 4 weeks in the selection criteria for this report, which can then be placed in your report header.

 

[minu]

Thanks for the solution.
But I found another way out also. I did not create any subreport, but added the condition in the stored procedure itself to pull out only the last 4 weeks of data to the report.

Thanks again!!