Search results for query: *

I figured it out. Thanks for the head start with your initial answer.

That worked great, as usual your extraordinarily quick with the correct answer lbass!! [medal] For the sake of future postings. Can you tell me how would this work if there's more than one grouping?

Example A is what a no frills traditional crosstab would look like. EXAMPLE A: -------------------------- D H N S U Tot a 2 1 2 3 2 10 20% 10% 20% 30% 20% 100% b 1 2 1 4 2 10...

Thanks for all the input but I figured it out a little after midnight. The problem was in the UNION. By default, the UNION operator removes duplicate rows from the result set. If you use UNION ALL, all rows are included in the results and duplicates are not removed. [morning]

Below is the complete content of the command: ------------------------------------------ SELECT srvc_ctr_nm SrvcCntr, a.user_id Employee, rep_actn_cd, CASE WHEN (extend( end_tme, year to second ) - extend( strt_tme, year to second )) < "0 00:01:00" THEN "< 60 " WHEN (extend( end_tme, year to...

I'm using a command because I'm running a UNION query. And I've written a dozen other reports (UNION and non-UNION) that are CR Crosstabs and all of them SUM that field correctly.

No it doesn't. . . Still counting not summarizing. Man this is weird!

Below is the content of the command: ------------------------------------------ SELECT srvc_ctr_nm SrvcCntr, a.user_id Employee, rep_actn_cd, CASE WHEN (extend( end_tme, year to second ) - extend( strt_tme, year to second )) < "0 00:01:00" THEN "< 60" WHEN (extend( end_tme, year to second ) -...

I've created a crosstab in CR10(PRO) using a command against an Informix DB. I used the Count(*) function in the command to create totals that are summarized in the crosstab. The problem I'm having is the SUM field in the crosstab is returning a line count rather than summing the integers...

That worked. Thanks LBass! [medal]

I'm using CR10 and have created a CrossTab that shows each sum and it's percentage of sum for each row by column e.g.: D H N S U Tot a 2 1 2 3 2 10 20% 10% 20% 30% 20% 100% b 1 2 1 4 2...

I am using Crystal 10 Pro and have created a UNION query command as the record source for a crosstab report. I'm trying to figure out how to pass a BETWEEN date parameter to both queries in the UNION to narrow the dataset.