Posted on 2004-11-15
Last Modified: 2012-08-14

I need a program that dumps all reports formula name, formula, parameters, SQL in a text file. How can I get access to the .rpt file, to get those informations.

I have got the job to "compare" some reports, I have to check if the GUI is the only difference in some reports. I have to "compare" about 200 repots, with about 10-20 formula each. If I have to open all reports manually, I have to manually compare 2000-4000 formulas. That is not what I want. Help anyone ?

If possible, then I'd like to see some code for that also :-)
Question by:win32
    LVL 100

    Accepted Solution

    Crystal has some of that ability.  I forget the method but there is an ability to print the report definition or something like that.  I don't have CR here so I can't look it up.

    Here is a link to some third party tools that may be useful

    LVL 13

    Expert Comment

    You can try exporting a few of your reports choosing 'Report Definition' as the format to see if that gives you enough information.  It will at least give you the formulas and their definitions for each report.

    If you have a developer version of CR, and have VB skills, you can probably write your own utility to document your reports using the RDC object model.

    LVL 26

    Assisted Solution

    by:Kurt Reinhardt
    Report Inspector is very good.  It gives you the ability to compare and/or modify groups of reports at a time.  Here's a link:


    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    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…
    There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    746 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now