Grouping Issue with Cross Tab Report

[Becky1]

Can you please help. I'm using Version 10 Crystal Reports and I'm having trouble with a Cross Tab report.
I'm returning 6 columns and the first two columns are automatically being grouped which I do not want. Can I remove the grouping.
Example i'm getting
Ord No Customer Product ID
003 John 7648438
456456
5768787

but I want
Ord No Customer Product ID
003 John 7648438
003 John 456456
003 John 5768787

Can you please help.
Thanks
Becky

 

[lbass]

I'm assuming that all three are row fields. Concatenate them in a formula:

{table.orderno}+" "+{table.customer}+" "+totext({table.productID},0,"")//remove totext() if prodID is a string

Then use the formula as your row field.

-LB

 

[Becky1]

Hi,

Sorry, I forgot to mention that the report is exported to excel and requires separate columns for ord no, customer and Prod ID.

Thanks,

Becky

 

[lbass]

I think you will then have to create a manual crosstab, in which you group on Order No, Customer, and Prod ID, and then drag the Order No and Customer into the ProdID group header or footer.

If you need help with creating the column summaries, please explain what your column field is and what your summary is.

-LB