One field has many values.

[tinka]

Hi, I am creating a report from one table using only two fields. The one field I am concerned about though, is called GLAccountNbr. Wihtin in this field there are many values,(780902 STI,780700 Classic,780912 Non Sti, etc) that I want to pull out individually and use in more than one column heading. like this;
780902 780700 780912

Under these headings will be the dollar amount for these products from another field. I think I should use the cross tab feature but I am not sure how to go about this. How do I pull the values from that one field to populate different columns in my report?

Please Help.

Tinka

 

[kenhamady]

Simply make that field the column field of the cross-tab, and Crystal will add a new column for every value that occurs in the report. The field you want to sum should be the summarized field of the cross-tab

You control which records and account values get into the report by using the select expert or select tab. Ken Hamady

http://www.kenhamady.com/

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