Here is the situation.
We have a package that's maintained by external contractor and the package serves more than one companies so package can't be updated for us.
We have several reports with huge case statements (same/similar calculation) and they frequently change depending upon various conditions like business cycle, time of year etc... that we need to manually update as there is no way to make them dynamic.
Now the question is, is there a way to calculate that in one report and somehow reference it in all reports so we can only change at one place?
I checked layout component reference but it needs to copy the data items to bring the list in that doesn't serve anything.
If there is a way to get reference link directly to a data item in another report, that'll make it a lot easier.
Thanks for any idea.
Quote from: Suraj Neupane on 03 Jun 2015 03:26:26 PM
Here is the situation.
We have a package that's maintained by external contractor and the package serves more than one companies so package can't be updated for us.
We have several reports with huge case statements (same/similar calculation) and they frequently change depending upon various conditions like business cycle, time of year etc... that we need to manually update as there is no way to make them dynamic.
Now the question is, is there a way to calculate that in one report and somehow reference it in all reports so we can only change at one place?
I checked layout component reference but it needs to copy the data items to bring the list in that doesn't serve anything.
If there is a way to get reference link directly to a data item in another report, that'll make it a lot easier.
Thanks for any idea.
Sadly not. The idea is to have centrally-managed calculations like this defined in the metadata model. If you can't do this, you're going to have to define the calcs in each report.
MF.