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!

Register Log in
  • Congratulations strongm 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: *

  • Users: FMHarris
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. FMHarris

    Compare Individual & 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...
  4. 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