Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. FMHarris

    Help on Crosstab Percentage of Sum

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

    Help on Crosstab Percentage of Sum

    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?
  3. FMHarris

    Help on Crosstab Percentage of Sum

    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...
  4. FMHarris

    Crosstab SUM returning line count

    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]
  5. FMHarris

    Crosstab SUM returning line count

    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...
  6. FMHarris

    Crosstab SUM returning line count

    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.
  7. FMHarris

    Crosstab SUM returning line count

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

    Crosstab SUM returning line count

    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 ) -...
  9. FMHarris

    Crosstab SUM returning line count

    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...
  10. FMHarris

    Compare Individual &amp; Group Sum Percentages

    That worked. Thanks LBass! [medal]
  11. FMHarris

    Compare Individual &amp; Group Sum Percentages

    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...
  12. FMHarris

    How to pass a Parameter to a UNION query for a Crosstab

    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.

Part and Inventory Search

Back
Top