Beyond Cross-Tab in Crystal X

[CarolCook]

I have what amounts to a complicated cross tab report in Crystal X that exceeds the capabilities of Crystal default-cross tab. I have a table that has invoices by customer and job (multiple jobs on a single invoice but each invoice has its own record). So what I need follows. Can this be done via an array? Thanks!

Inv 1 Inv 2 Total
3/4/07 3/23/07
Customer X
Job 1 $100 $300 $400
50% 50%
Job 2 $100 $300 $400
50% 50%
Total $200 $600 $800

 

[FrankTWall]

I am trying to work out what the % values relate to??? Might help with what responses you get.

 

[synapsevampire]

You should build a manual crosstab.

Group by Customer, then Job, then manually create formulas for the invoicesums/percents.

Customer group
stringvar array invoices;
numbervar array invamts;

details
if not({table.invoice}) in invoices then
redim preserve invoices[ubound(invoices)+1]
redim preserve invamts[ubound(invoices)+1]
invoices[ubound(invoices)] := {table.invoice}
invamts[ubound(invoices)] := {table.invoice}

group footer:
display here

Can't really work it out right now as I don't have the time, but those are the basics.

-k