Problems with a tricky cross-tab!

[jwoodland]

Using Crystal 8.5 I'm having problems with the following situation:

Code(string) Index(#) Spec(string)
IC000009 1 501
IC000009 2 501
IC000009 3 502
IC000009 4 502
IC000009 5 501
IC000010 1 501
IC000010 2 501
IC000010 3 502

I need to pull, and eventually count the MAX index for each code and group by spec. i.e. Code IC000009 will be spec 501 and code IC000010 will be 502.
Using a distinct count cross-tab gives me a correct grand total but has incorrect group totals as it counts the non-MAX indices.
Maybe there is a simple way of actually pulling only the MAX indices from the database? If not is there a way of fiddling the cross-tab??

Any help would be appreciated.

jwood

 

[kenhamady]

What would the cross-tab to actually look like for these records? 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

 

[jwoodland]

There are hundreds of diffrent spec's and each record (index) has a start and end date (amongst other things).
The cross-tab in essence will have end date by month as the column headings and spec as the row headings (groups) with a count of distinct consultant episodes (codes).

Hope this makes it a little easier!