Skip to Content
0

Crystal Reports 2016 How to provide summed data in columns

Nov 07, 2016 at 10:37 PM

26

avatar image

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

sales-forecast.png (35.7 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Brian Dong Nov 08, 2016 at 07:45 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded