Trending Line Chart

[Former Member]

OK, I got a new one but hopefully its not new to some of you. Customer wants a line chart that completes a 9 week trend based on partial week data. If they have data through the first 5 weeks, they want to extend the trend through 9 weeks based on the 5 weeks of data. Quote the client: Excel can do it, Crystal should be able to do it too. Except I don't know how to configure a chart to make it happen. Any advice would be appreciated.

Fuskie

Who also invites everyone to join his growing Crystal Reports group on LinkedIn...

[Former Member]

Crystal Reports is a database reporting tool, thus Crystal's charting engine plots data FROM the database.

Excel is not; one can manually add values to Excel then plot those values on a chart in Excel.

So if they only have 5 weeks worth of data being pulled in to CR they'll get a chart for 5 weeks.

Suggestion: Report off the excel spreadsheet and pull that data in along with the Excel chart.

[Former Member]

Excel is not an option.

Fuskie

Who was hoping there would be some alternate solution involving statistics-based estimates...