6 Replies Latest reply: Jul 18, 2011 2:54 AM by TamasSzecsy RSS

    Report template - How to reference COLNUM in the col template condition?

    TamasSzecsy
      Hi,

      I have a query with 4 columns. based on this query I would like to make a report with a row layout that looks something like this:

      | column1 value |
      ----------------------------------------------------------------
      | column2 value | column3 value | column4 value |

      I created a report template, four column templates: one for column 1, one for the following columns and one for the las column of the report.

      My problem is that when I reference *#COLNUM#* like mod(#COLNUM#,4) = 1 in the Column Template condition fields, then I get *'ORA-06550: line 1, column 34: PLS-00103: Encountered the symbol "#" when expecting one of the following: ( ) - +....'*

      Is referencing COLNUM not allowed in the Column Template Condition field?

      Tamas

      Edited by: Tamas Szecsy on Jul 16, 2011 11:33 PM