Create a weekly trend from dates of year 2011 to 2013

[Former Member]

Hi, I need an advice about this. I need to show a graphical representation of how many requests/records has been logged in the system thru crystal report.

The Parameter should be dates from year 2011 to 2013

I need to show how many requests per day in a week from 2011 to  2013.

[Former Member]

Thanks

[abhilash_kumar]

Hi Mark,

This is going to be a long shot as you've not provided info on how your data is structured etc however at a high level, this is what you'd need to do:

1) Create a Static prompt Date Range prompt

2) Create a record selection formula that restricts the data in the report to the date range you've chosen

3) Insert a Chart (perhaps a Line Chart?) with the Date field chosen under 'On Change Of' and the 'Request' field chosen under 'Show Values'.

The Date field needs to be set to 'Print for each week'.

-Abhilash