Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Search Multiple Crystal Reports for Field reference

Posted on 2013-01-17
4
Medium Priority
?
512 Views
Last Modified: 2013-01-17
Hi EE,

We have had a major change in our system and i need to find where a particular field is referenced in over 200+ crystal reports and i was wondering if there was a way that i could search and find all reports that had this reference and output to a text file.

Any help would be greatly appreciated.

Many Thanks

Ross
0
Comment
Question by:Ross Turner
4 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 1500 total points
ID: 38786303
THere is nothing built into Crystal that will do this.

You can find some report management tools which sound relevant at the link below.
I haven't used any of them.

http://www.kenhamady.com/bookmarks.html#doc
0
 
LVL 35

Expert Comment

by:James0628
ID: 38786309
There is no way to do this in CR 10 (the version I've used).  CR itself didn't have a feature like that, and the RPT files themselves are encrypted or something, so you can't just search them for field names.  I haven't used the more recent versions of CR, so I can't say for sure whether it's possible with any of them.  I rather doubt it, since it wasn't possible in the past, but I really don't know.  Hopefully someone else can answer that.

 There are third-party "report management" tools and some of them might let you do that.  You can find some listed here:

http://www.kenhamady.com/bookmarks.html


 James

 PS: Ah, Peter beat me to it.  :-)
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 38787329
Agree with the above.  I hadn't looked at an RPT file in a while so I looked at a couple in Notepad.  There is very little that can be deciphered and what can is not useful for your purpose.

The tools linked above are probably your best bet.

mlmcc
0
 
LVL 7

Author Closing Comment

by:Ross Turner
ID: 38787855
Many Thanks
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

926 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question