Mass Edit Crystal Reports

Posted on 2011-10-19
Last Modified: 2012-06-22
I have a collection of over 100 reports written for an application that used DB2 as the database.
The applications is being upgraded and moved to an MSSQL database.
In their great wisdom the developers have elected to use identical file layouts for the new system, but they adopted a new column naming schema.
The tables have the same data types, lengths, and positions, only the names have changed.
Is there any way to mass-edit the crystal reports to change references to the field names?

Question by:kinsey
    LVL 18

    Accepted Solution

    Not sure if this is possible , but you may check this tool:
    LVL 100

    Assisted Solution

    There are other tools that might be useful

    I suspect you may need to do this individually since the field names have changed.

    LVL 100

    Expert Comment

    This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    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 …
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    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…

    730 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

    20 Experts available now in Live!

    Get 1:1 Help Now