Report Builder: How can I dynamically generate the numbers or rows of a table?

Kinetic ERP
,
1

Hello,

One of our new plant needs some changes to our job traveller report. I intend to make a copy of our current version and make it their own.

Amongts the requested changes are a table which would print at the end of the report, that would be one row for every label needed for that job.
(I calculate via total of parts needed / parts per package = total of labels needed for the job.)

So I need to dynamically generate a series of rows which would contain the label number incremented. from 1 to total of labels.

The table would have column headers (12 columns in total) where one of the column would be the label number, incremented…

How can I do that ?

Thanks

Pierre

2

You can do that with a CTE in the dataset query:

WITH cte
AS ( SELECT 1 AS n
     UNION ALL
     SELECT n + 1
     FROM cte
     WHERE n < 10 )
SELECT n
FROM cte;