Discussions

Expand all | Collapse all

How do I number the lines on a report extract?

  • 1.  How do I number the lines on a report extract?

    Posted 02-27-2018 22:53
    I?m building a tool that auto-create the Work orders needed to replenish our inventory kanbans. The report will always have different items on it. In the extract report I need to number the lines 1 to n where n ranges from 2 to 99.

    I?m looking for suggestions to accomplish this - or to partner with someone who could develop a solution.


  • 2.  RE: How do I number the lines on a report extract?

    Posted 02-27-2018 23:05
    If you just want to sequentially number the lines on a report, if there are not too many columns you can make a Summary report which would break on something unique like Record ID#. So it would be a summary report in name only as each line would be a separate record. 

    Then if you have a Dummy field called Line # with a formula value of 1, then you can show that on the report and set that field to be a running total down the page.


  • 3.  RE: How do I number the lines on a report extract?

    Posted 02-28-2018 00:08
    Thanks. And to make sure, the running total column will show up in the csv export?


  • 4.  RE: How do I number the lines on a report extract?

    Posted 02-28-2018 00:18
    Yes, you can export to Excel