I have a report from a production system written with MS Report Builder 3 that I need to load into a ERP (with the ability to run a SQL script beforehand). The report from the production system has some records with identifiers that are not unique and before I load into the ERP I would like to add a trailing digit to make them unique. The trailing digit is the count of each instance (ie first instance is 1, second is 2 etc)
Ideally I would like to do this in MS Report Builder if possible because there are a lot of other moving parts in the current SQL script.
Is it possible to somehow get a count or the like in each row of the Report Builder report? I have tried but am getting aggregate function errors.