Crosstab but no summaries 1

[MeganRoss]

I'm using Crosstab Expert (ver XI) to create a report like a crosstab but i don't need the summaries. The rows will be part # and the column will be customer. The supposed summary would be selling_price. One of the key aspects of the reports is to compare customer pricing and if customer pricing is not setup i need the field to stay null not 0.00.
Example:
cust1 cust2 cust3 cust4 ..........
part1 1.00 1.50 1.75
part2 5.00 5.00 5.25
part3 3.00 3.50 3.50

I've tried suppressing the sum field in format field(isnull(selling_price)) i still get 0.00. When i convert selling_price to text i lose my decimals (even if I round it before converting)but I do get my nulls.
Is there anyway to get around choosing a summary?
Do i have to do manual crosstab? if yes, how do i create the columns? the enduser will select cust by prompt (there could be 1-1000)
Any guidance would be greatly appreciated.

 

[lbass]

If there is one price per customer/part# combo, then you can use a maximum as your summary. You should be able to right click on the summary field->format field->number->customize->suppress if zero.

-LB

 

[MeganRoss]

I knew i was missing something simple. Thank you.