Using LEFT in a crosstab formula

[get2work]

Created a formula named "short descrip" as
Left ({PACKAGE.PACK_DESC},9) in the row section of the crosstab. The purpose was to combine like product names based on the first 9 characters. The summarized field is count(MAP.PIN_NUM). The product names are grouping as desired, but the pin count is not combining totals for each combined product name group. Instead, only the pin count for the first row is displayed.

Example: without using left(field,9)
Product A - 50 cards 100 pins
Product A - 60 cards 200 pins
Product B - 50 cards 600 pins

Example: using left(field,9)
Product A 100 pins
Product B 600 pins

Product A should have totaled 300 pins.

Is there such a thing as sum(count(MAP.PIN_NUM)) in a crosstab?

 

[synapsevampire]

I just tested it here and it counted fine using CR 8.5.

-k

 

[get2work]

Thanks! I'm using CR 8.0.1.1 - Do you think that may be the issue? Is there a way to get this to work using 8.0.1.1?

 

[synapsevampire]

Have you applied the hotfixes?

That may help, I don't see it listed as a bug.

-k

 

[get2work]

No - I haven't applied hot fixes - sorry, don't know what they are. I have opted to have CR8.5 installed, hopefully by 06/02/03... Thanks for the support!

 

[kenhamady]

I will take a wild guess here that your quantity is in a string field (not a number), and your summary operation in the cross-tab is Minimum or Maximum, rather than sum.

If you put VAL () around your existing formula for Quantity it will convert it to numeric, and you can then sum it.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com