2,410
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 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.
#1
André Arnaud de Cal...
291,711
Super User 2024 Season 2
#2
Martin Dráb
230,458
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
