Skip to Content

Crystal Reports - Cross tab with additional non sumarized fields?

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 25 at 02:02 PM

    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

    Add comment
    10|10000 characters needed characters exceeded