Crosstax rows question 1

[wrk6718]

Have a crosstab with the a code for each salesperson and the columns are the products...works fine...
Now management wants to see the rows by last,first name...but one one row
Is there a way I can "combine" code,last,first name if each is a separate field so I can use a crosstab?
Or must I return to totaling the detail sections?
Using 8.5 Windows 2000

 

[kenhamady]

You can write a formula that combines Last and First into one field, and then use the combined formula as your row field. Something like:

Last + ', ' + First 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