Can a Crosstab be used?

[oj75]

I need to create a report formatted as follows:
Client 9/24 9/25 9/26 9/27 9/28 9/29 9/30
1111 A A P P ND ND A
2333 P P P P ND ND A

Basically pulling data for each client and their attendance status for each day of class during the report period. Can I format this data as shown using a crosstab? I created a crosstab but I did not want to perform any calcs on the summary field because the summary field values A, P, and ND are just descriptions of a clients attendance status for a given date. Do I have to go with an alternate solution?

Any info is appreciated.

oj

OJ
DB/.Net/CR Developer

 

[lbass]

If there is only one result per date per customer, you can insert a crosstab and for the summary, choose "NthMostFrequent", N = 1. Since there will only be one response, it will always be the most frequent. (You could also use NthSmallest, NthLargest, mode, maximum, or minimum for the same reason.)

If you have multiple classes, you can also insert this crosstab in the group header or footer, and again, this will work because there will be only one result per date per customer.

-LB

 

[oj75]

LB, thanks for the info.

OJ
DB/.Net/CR Developer

 

[kenhamady]

Or you could use Maximum.

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

http://www.kenhamady.com/

- tek@kenhamady.com