Search for text in all reports formulae

system · December 10, 2010, 10:17pm

Is there a way to search for a text used in formulae in all reports (CMS Database). We have hundreds of reports and some are using legacy Crystal formulae. We want to know which reports are using such formulae.

Please share if you have any utilities or scripts.

shamanth (BOB member since 2007-03-01)

system · December 11, 2010, 9:13am

Hi,

This utility can help you with DeskI reports:

And maybe this one could help with WebI reports:

Marek Chladny (BOB member since 2003-11-27)

system · December 11, 2010, 7:29pm

Anything for Crystal Reports?

shamanth (BOB member since 2007-03-01)

system · December 12, 2010, 8:47am

I am sorry, I am not aware of anything for Crystal Reports.

Marek Chladny (BOB member since 2003-11-27)

system · December 13, 2010, 3:14pm

How about creating a BIAR file and converting it to csv or xml and search for the text? Is it possible?

shamanth (BOB member since 2007-03-01)

system · January 28, 2011, 10:22pm

In addition to other suggestions here, you can write script or leverage 3rd party app to extract this info. Specifically, your script will need to use RAS SDK to open and extract formula detail for each report.

open CR with RAS
expose DataDefinitionController
get report DataDefinition
getFormulaFields
for each formula, get name, ID, description, etc etc…

crystal01 (BOB member since 2006-08-30)

system · January 28, 2011, 10:43pm

I resolved this issue using RPT Inspector tool.

shamanth (BOB member since 2007-03-01)