Skip to main content
Question

How do I number the lines on a report extract?

  • February 28, 2018
  • 0 replies
  • 42 views

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.
This topic has been closed for replies.

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.