Skip to Content
avatar image
Former Member

Create a weekly trend from dates of year 2011 to 2013

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Sep 11, 2014 at 06:04 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 25, 2014 at 05:11 AM

    Thanks

    Add comment
    10|10000 characters needed characters exceeded