Hi Mike
My web session timed out with my first reply, so this one is a little more clipped!
I'm going to make some assumptions here, so bear with me. It's a bit hard doing this without knowing your setup, so this is the most basic method I can think of doing this.
A. you have contacted dbase admin to find out what has changed (eg location of dbase source for all tables, generated SQL views etc).
B. something is actually broken with the report - either a field has been removed, renamed or it's data type has been changed. Someone, somewhere has changed something. Either that or it's Crystal giving you random joy.
First - take a copy of your report without fixing the tables (if this is possible). Let's call this Report A
Second - take a copy of your report after CR has fixed the tables. Note the tables it has changed. Let's call this Report B
In report design using Field Explorer (with "Show field type" selected) compare the two reports.
Once you find the changed item(s), you should be able to correct it in Report B (either the table reference by linking to the updated table name, the field reference by referring to the updated field name; the field type, by correcting any formulas etc that point to it).
If you're unable to do this then it's a slower process.
Take a copy of your report. We'll call it Report C
In the design of Report C, use the File, Save As to save a copy of the subreport - let's call it Report D.
Use Database, Verify Database option.
See if Report D runs. If so, wonderful - see next paragraph.
If not, slowly strip out the fields until you have a working report. Suggest you start with date fields (changed from string to date or visa versa). Then number references. If you get back to one field & it doesn't work, then start again & remove entire tables (start with any SQL generated tables), one at a time, as it may be a link or an entire table that has changed.
Once Report D is working, delete the subreport from Report C (even if Report D worked without changing anything).
Use Database, Verify Database option.
Fix any tables/references that you did to get the Report D working (if they are in the main report of Report C).
See if the whole thing works.
If no joy, then you'll need to do the same with the main report of Report C as you did with Report D. Slowly strip out fields until it works. If that doesn't work, remove tables. Don't delete your formulas, simply comment them out.
If you do accidentally delete formulas, you still have Report A you can refer back to (even though it doesn't work - it has all the formulas & references).
Best of luck
IP Logged
