CrossTab-Limited Fields 1

[PAWelch]

I am a novice user of Crystal 9.0. I am tasked with designing a report to be used by multiple clients. A crosstab report is to show a grade scale that can vary-some clients use 0-4, some 1-8. The goal is to display the instructors' grade distribution-are they using the entire grade scale? All data is drawn from an MSAccess database.

Ex:
Name 1 2 3 4 5 Total
Jones 2 16 14 7 39
Smith 15 22 1 38

When I designed the report for Client 1, it worked great. They have a 5-point grade scale. However, my next client has a 7-point grade scale. When I refresh the data, it limits Client 2 to the same 5-point scale. So I need the cross-tab to recognize the different grade scales so that each client doesn't have to have their own version of the report. Any suggestions? Thanks in advance!

 

[Thadeus]

The way I approached a similar issue, was to create multiple sections (GH1a, GH1b, GH1c) which alternately suppress dependent on the number of columns to be displayed.

So:
in GH1a I have 4 columns of data.
in GH1b I have 5 columns of data.
in GH1c I have 6 columns of data.
If client one uses the 5 point scale, as you displayed, GH1a and GH1b would be suppressed.

Now in my real-life example, I didn't use a cross-tab object, but created my own cross-tab by inserting formula fields that present the data as I outlined above:

GH1a || {@col01} {@col02} {@col03} {@col04}
GH1b || {@col01} {@col02} {@col03} {@col04} {@col05}

and so on...

~Thadeus