This discussion is archived
6 Replies Latest reply: Jul 18, 2011 12:54 AM by TamasSzecsy RSS

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

TamasSzecsy Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points