Crystal Reports 2016 How to provide summed data in columns

[Former Member]

I'd like to create a sales report that shows demand over the coming week and month.

I'd like the user to enter a date (ie such as today-Monday) and the following columns (ie Tuesday, Wednesday... and the following next 3 weeks) in the report would sum the number of item requests (by part/product for example, as per the expected delivery date of the order).

sales-forecast.png

[former_member292966]

Hi Alan,

What you want is a crosstab report. This is similar to a pivot table in Excel where the columns and rows are summarized in tabular format.

You do need to be careful that you have all the days in your database. Crystal will only report on days that have data. If there is a day that is missing, it won't appear in the report because Crystal only reports on existing data. It won't make assumptions for missing dates. There are ways around this and several articles on how to make this work.

The formatting you will have to play with because a single crosstab won't be able to get you the Next 5 days and the next 3 weeks.

Good luck,

Brian