How to place Text into your Cross Tab Reports?
1. Once you create your cross-tab report using the fields and the rows. Crystal will count the number in the field and give out numeric vallues. For my client I needed to inport a value field with text characters. I was able to change the summary from Count to Maximum thus allowing me to bring in text characters in the crosstab.
Example: Country X Transaction
Before:
USA ASIA EUR OTHER
Transaction1 1 0 1 0
Transaction2 0 1 0 1
Transaction3 1 1 1 1
Transaction4 1 0 0 0
After:
USA ASIA EUR OTHER
Transaction1 Y N Y N
Transaction2 N Y N Y
Transaction3 Y Y Y Y
Transaction4 Y N N N
Right click on the Sumary Field, Summary field Operation
Change from Sum or Count to Maximum and presto the text will come out, or other large numbers othe than 1 or 0, or a count of that field.
gboutin
garyboutin@hotmail.com
[sig][/sig]
1. Once you create your cross-tab report using the fields and the rows. Crystal will count the number in the field and give out numeric vallues. For my client I needed to inport a value field with text characters. I was able to change the summary from Count to Maximum thus allowing me to bring in text characters in the crosstab.
Example: Country X Transaction
Before:
USA ASIA EUR OTHER
Transaction1 1 0 1 0
Transaction2 0 1 0 1
Transaction3 1 1 1 1
Transaction4 1 0 0 0
After:
USA ASIA EUR OTHER
Transaction1 Y N Y N
Transaction2 N Y N Y
Transaction3 Y Y Y Y
Transaction4 Y N N N
Right click on the Sumary Field, Summary field Operation
Change from Sum or Count to Maximum and presto the text will come out, or other large numbers othe than 1 or 0, or a count of that field.
gboutin
garyboutin@hotmail.com
[sig][/sig]