Deaconskye
Technical User
Hi,
Im new to Crystal reports, Im trying to build a more granular chart, in Crystal, off a report that I currently generate and then export to excel.
I have data that runs from the start of this year through today as I refresh the report data every morning to include what we did yesterday.
so the fields I use specifically are the Date and the Quantity fields. Simple straightforward but it tells the entire story.
In excel I can show a table that is monthly, weekly and daily, In crystal the charts aren't exactly pivot charts.
I've managed to generate a chart showing the monthly data and a chart showing the weekly data too, what I'd like to do is have a chart generate showing the last 2 weeks worth of data, From Monday to Friday and have that update at the start of next week. Does that make sense?
Im new to Crystal reports, Im trying to build a more granular chart, in Crystal, off a report that I currently generate and then export to excel.
I have data that runs from the start of this year through today as I refresh the report data every morning to include what we did yesterday.
so the fields I use specifically are the Date and the Quantity fields. Simple straightforward but it tells the entire story.
In excel I can show a table that is monthly, weekly and daily, In crystal the charts aren't exactly pivot charts.
I've managed to generate a chart showing the monthly data and a chart showing the weekly data too, what I'd like to do is have a chart generate showing the last 2 weeks worth of data, From Monday to Friday and have that update at the start of next week. Does that make sense?