Skip to Content
0

Crystal Reports - Cross tab with additional non sumarized fields?

Apr 25 at 01:56 PM

13

avatar image

Hi guys, I've created a crystal report with a cross tab. This cross tab currently contains the following fields

Item Data, and Item Sales (the sales is summarized monthly showing 6 months of data.

So my top tabs are "Total" April, March, Feb etc....."
I want to add 3 additional fields to the cross tab before total.
On Hand / Commited / On Order
These 3 fields are not to be sumarized and only required to display one piece of information which will be extracted directly from the SAP B1 OITW Table.

Any help is appreciated.

Kind Regards
Andy

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Dell Stinnett-Christy Apr 25 at 02:02 PM
0

You basically have to summarize them. However, if there's only one value per group for each, you can use maximum() or minimum() to correctly show the value in the cross-tab.

-Dell

Share
10 |10000 characters needed characters left characters exceeded