I am using oracle 6i report builder.I have created a matrix report with different type of grouping and i tried to add a slno in the matrix report.I used summary column for showing the Serial Number but the serial number is showing on the report when user has select only one item (fromitem=01 and toitem=01).when user has select more than one item (from item=01,toitem=10)it showing the error
'REP-1510 Group manager unable to compute column'.
How to solve this issue,how can create serial number in my matrix report
try this one
SELECT ROW_NUMBER() OVER (ORDER BY COLUMN_NAME) SLNO FROM TABLE_NAME;