2 Columns 1 Field

[strom99]

Hi

I have a field BILL_UNIT and it contains either GAL or LBS as values. I need to split this column up into 2 different columns, one that would display GAL for each product that is associated by GAL and one for LBS and total each. How would I go about this.

-Thanks-

 

[csm2]

If those are the only values possible int his field then you can group on this field which will give you two groups: one for GALS and one for LBS. If other values are possible then create a formula to select only GALS and LBS and grup them.

 

[kenhamady]

If you want two columns, see my FAQ on conditonal columns and conditional totals. You would do a formula for each value, and each formula would then be a column. You could subtotal and grand total these formula columns if you needed to. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)