crosstabs with a subreport.

[dgillz]

I have a very simple cross tab report with Customers across the top, and items down the left side, with Qty on Order being summarized.

The client wants to put Qty on Hand and Qty Short (Qty on Hand - Total Qty on Order) to the immediate right of the cross tab, so he can easily see which items he is short on. I wrote a linked subreport to do this, but it is only picking up the last item from the subreport instead of displaying this info for every item. This is most likely because I put the subreport in the report footer, right next to the crosstab.

Basically I need the info on the subreport to display right next to the crosstab, or I need an ability to display additional info in the crosstab.

Ideas? Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[Ngolem]

is "Total Qty on Order" a summary field??

if it isn't then why don't you try using an sql expression to get this quantity... "Qty on Hand - Total Qty on Order". this way no calculation would be necessary while the report is printing

other than that I rarely use an automatic so cannot help. Jim
JimBroadbent@Hotmail.com