Share Formulas across Reports

[Former Member]

I have several reports using the same formula which means I need to update all of them everytime there is a change. Is there anyway I can share a formula from one report to another if I don't have any repository, so when I change in one spot it changes in all my reports?

Thanks,

Will

[former_member292966 · Accepted solution]

Hi Will,

A repository is the only way to do what you want.

Thanks,

Brian

[JWiseman · Accepted solution]

also look into third party tools like .rpt inspector. here's a good source for 3rd party products. look at the section

RPT Management Utilities (Edit & Analyze properties across multiple RPT files):http://kenhamady.com/cru/comparisons/rpt-management-utilities

[abhilash_kumar]

Hi Will,

Now that your reports are ready any other suggestions would involve making changes to all reports anyway.

E.g: - Move the logic in the formula to the database by way of creating a Stored Proc/View.

       - Create a SQL Expression if that's possible

       - Create a UFL

-Abhilash