Sorting in Cross tab report for top 100

building reports desktopintelligence
9

  1. MonthNumberofYear returns data type NUMBER, UserResponse returns data type STRING/CHARACTER. You can only compare variables of the same data type.

  2. The WHERE clause in your code only accepts a constant on the right side of the equation, for example:

SUM (<Revenue>) WHERE ( <Year> = 2004)

Take a look at this entry in FAQ Reporter for a work around.

Andreas :de: (BOB member since 2002-06-20)