Topic
2 replies Latest Post - ‏2013-03-14T23:15:50Z by Bobznkazo0
mistryd
mistryd
28 Posts
ACCEPTED ANSWER

Pinned topic How to display rownum in Cognos Impromptu report

‏2013-01-24T11:13:25Z |
Hi All,
I have a report which displays 15 columns. In addition to this we need to display one more column in the report which would display the rownum of the each line of report.I searched the function list of Cognos 7.5 but couldn't find the similar function.Using the rownum in the oracle database view is hitting the report performance drastically.
Can anyone please tell me what would be the workaround for this ?

Thanx.

Warm Regards,
Mistry
Updated on 2013-03-14T23:15:50Z at 2013-03-14T23:15:50Z by Bobznkazo0
  • SystemAdmin
    SystemAdmin
    280 Posts
    ACCEPTED ANSWER

    Re: How to display rownum in Cognos Impromptu report

    ‏2013-02-12T15:14:25Z  in response to mistryd
    This may not the exact answer to your request but is this help you a bit?

    Display One Column With Multi Values on One Line
    http://www-01.ibm.com/support/docview.wss?uid=swg21335927

    Please excuse me if I misunderstand your question.
    • Bobznkazo0
      Bobznkazo0
      3 Posts
      ACCEPTED ANSWER

      Re: How to display rownum in Cognos Impromptu report

      ‏2013-03-14T23:15:50Z  in response to SystemAdmin
      While your report is open in Impromptu, go to the menu option "Insert\More Objects..." and choose "Row Numbers". That will allow you to insert that field wherever you want it to be located. Once you have dropped it as a column, you can click the field to highlight it and then drag the right field-sizer-box to widen the field for better readability.

      After you have inserted that field once, it will always show in the "Insert" menu automagically.