I've been experimenting with crosstabs for the last day or so and while they perform an important function, at first glance they seem to have a mind of their own. In looking for information, I note with alarm that crosstabs are completely unmentioned in the Knowledge Base, this discussion, and the Works discussion. Given the wealth of essential knowledge found in these areas, it makes me suspicious that they are either so simple that no one except me is puzzled about them, or that they are so DOA that everyone but me stays away from them completely. 3 items in particular mystify me:

1) How do you get more than one crosstab to print in a report?

Example: I want to display a crosstab of products vs salesreps with the summary data being quantity sold. The records are in the INVOICE table (only one product per invoice). I set up the crosstab with row labels being product and column labels being salesrep. I get the desired result, except I want a separate crosstab for each product class. Specifically, if the sorted invoice records are:

ID, Class, Prod

11, 10000, 10001

98, 10000, 10002

47, 10000, 10002

13, 10000, 10003

24, 20000, 20005

21, 20000, 20007

12, 20000, 20009

85, 20000, 20009

I want one crosstab summarizing sales by product and rep for Class 10000 products, and a another for Class 20000.

My select statement is:

SELECT INVOICE BY PRODUCT BY SALESREP

In the report definition, I specify GROUP BY CLASS.

No matter what I do, I get a report consisting of one crosstab summarizing sales for all products, instead of two.

Am I missing something obvious here?

2) Still using the above, the row labels are sorted in product order, but the salesrep column labels refuse to sort, and appear in a seemingly uncontrollable order. Ideas?

3) The above behavior happens when the select criteria are in the report definition. As soon as I set the criterion to GETLIST KEY_PRINT_@STATION and supply the appropriate list (as I do with all other reports), REPORTER gives an error. Clicking "CLOSE" in the error window leads to a General protection Fault in RT.DLL. Does anyone recognize this as an issue or know what I'm doing wrong?

Thanks in advance for digesting this rather lengthy missive and offering any assistance or clarification.

Very few developers use reporter. At best it is an end user tool. It is slow, buggy and prone to faults. Use OIPI.

The Sprezzatura Group

World Leaders in all things RevSoft

View this thread on the forum...