We'd like to add some fields to the stock SSRS reports. For example the sales person to the Detail Trial Balance report.
Looking at the dataset it's pulling a stored procedure that is passed all of the parameters from the Report.
Is this there a clean way to add the salesperson to the SP or a separate dataset and join them?
*This post is locked for comments
I have the same question (0)I would recommend starting with the standard SProc but script it out and change the name before making any alterations. This will prevent future changes to the standard SProc wiping out any changes you have made. Same goes for the report, take a copy of it, rename it, and change the dataset to use your new SProc, add your custom fields, and deploy.
Community Member
2
babubaskaran@outloo...
2
Yng Lih
2