Skip to content

    Crystal Report Repair

    Crystal report broken? I'll fix it.

    Totals that don't match, rows that repeat, records that go missing, or a report that stopped working after a Sage upgrade. Tell me which report it is and what's wrong. You'll get a fixed price to fix it before any work starts.

    What I fix

    If the report is wrong, I find out why and fix it.

    Wrong totals

    Sums that run high, subtotals that don't add up to the grand total, or a report that won't tie to Sage's own numbers.

    Duplicate rows

    The same invoice, check, or line printed two or three times, usually because of how the tables are linked.

    Missing records

    Customers, jobs, or transactions that belong on the report and aren't there, often dropped by a link or a selection formula.

    Broken after a Sage upgrade

    Reports and forms that won't open, print blank fields, ask for a database login, or stop with a database error after an upgrade or a move to a new server.

    Reports nobody can maintain

    A report built years ago by someone who has since left, full of formulas nobody wants to touch.

    Forms that print wrong

    Invoices, statements, or checks with fields in the wrong place, text cut off, or information missing.

    Why it happens

    Why Crystal reports go wrong.

    Most broken reports come down to a handful of causes. Finding the right one is most of the fix.

    A link that repeats rows

    Link a header table (invoices, checks, orders) to its detail table (lines, distributions) and every header value repeats once per line. Sum a header amount such as freight or tax across those rows and the total runs high.

    A link that drops rows

    An inner join keeps only records with a match on both sides. An invoice with no lines, or a customer with no salesperson, quietly disappears. The fix is usually a different join or a subreport.

    Hidden rows still counted

    Suppressing a section hides rows from view but leaves them in the totals. Filtering belongs in the record selection, so the totals match what prints.

    Totals calculated at the wrong time

    A running total that resets on the wrong group, or a formula that adds values up as records print, gives totals that change when you change the sort or the grouping.

    Changes from a Sage upgrade

    An upgrade can rename or move tables and fields, change the Crystal Reports runtime, or swap the database driver a report connects through. On Sage systems that run on SQL Server, newer Microsoft ODBC drivers encrypt connections by default, which can stop a report from connecting if the server's certificate isn't trusted. Edits made to a standard Sage report instead of a copy can be overwritten when new versions are installed.

    A stale connection

    A report that still points at an old server, database, or saved login asks for credentials or fails with a database error after a server move.

    Several reports broke in the same upgrade?

    When an upgrade breaks reports and forms in bulk, I work through them as one job: list the custom reports and forms, find what each one depends on, fix what changed, and compare the results with what they printed before. The reports your team needs first, such as month-end, come first, and you know the price before any work starts.

    Tell Me What Broke

    How it works

    From broken to fixed, with the price up front.

    1. 01

      Tell me what's wrong

      Use the form below: which report, what's wrong, and your Sage product and version. I'll reply with what I need, usually the report file and a screenshot of the number that's off.

    2. 02

      Get a fixed price

      Once I've seen the report, you get a fixed price to fix it. Nothing starts until you say go.

    3. 03

      Fixed and checked

      I correct the report and check it against numbers you already trust, such as Sage's standard reports or a total you've verified.

    4. 04

      Back in use

      The fixed report goes back where your team runs it, and I tell you what changed.

    Questions

    Report repair questions.

    How much does it cost to fix a Crystal report?
    It depends on what's wrong, so the price comes after I've seen the report. It's a fixed price, and you know it before any work starts.
    Can you fix a report someone else built?
    Usually, yes. Who built it, and when, matters less than you'd think: I work from the report itself and your data, and I tell you what I changed so the next person isn't starting from scratch.
    Do you need access to our system?
    Usually, over a screen-share or a remote session into your Sage environment. If you'd rather not grant access, I can work from the report file and a backup copy of your data, and hand the fixed report to your IT team or reseller to install.
    Several reports broke after our Sage upgrade. Can you fix all of them?
    Yes. I work through the full set as one job, starting with the reports your team needs first, and you get the price before any work starts.
    Which Sage products does this cover?
    Sage 100, Sage 300, Sage 300 CRE (Timberline), and Sage 100 Contractor. Tell me which one you're on, and the version, when you write.

    Contact

    Tell me what you need.

    Tell me about your project or the problem you need solved.

    Add project details (optional)Company, phone, Sage product, and type of request1 added

    Sage product

    Optional. Skip it if your request isn't about Sage.

    What do you need?

    No retainer, no obligation. You'll get a scope and price before any work starts, and I never contact your current Sage partner without your permission.