2 Replies Latest reply: Nov 9, 2012 1:54 AM by kikolus RSS

    How to show line numbers

    user8655468
      Hi all

      I would like to put a line number for each row of my results. I want the report to show the results including a line number against each row in sequential order, i.e. numbering each row starting from 1. How do I achieve this, what function do I have to use?

      Thanks.
        • 1. Re: How to show line numbers
          G.Y
          Dear if you want to use continue... number then you can solve your problem by using rownum.
          if you share your complete requirements then maybe someone help you as per your need.

          Note that :- you can also use Row_num over partition by and order by.
          using this one we can create rownum as per our own wish, we can break line number where we want.

          hope it helps

          thanks and regards
          Yassen
          • 2. Re: How to show line numbers
            kikolus
            Hi,
            You can put Summary column with Count function to your query group, and set Reset At property appropriate.