At 06:24 PM 3/11/2009, [email protected] wrote:
I made a big BOO BOO!! I have a complex report which runs on many temp
views and tables. The reports was an is working correctly. However, I
put all the temp view creations in the BEFORE DEIGN EEP in the report.
I have a typo and now my report will not open in the designer. It gives
me the error message and thats it. Is there anyway I can edit my EEP to
solve my problem.
Ajay,
If the associated primary table is not defined correctly, you
are not going to be able to open that report in a designer.
In your specific situation, follow the steps below:
01. Make a copy of the report and make sure to associate it
with an existing good table or view.
02. Open the new report in a report designer to fix the code
defined as "On Before Design" action. Save the report and
close the report designer.
Ignore the -ERROR-s related to invalid table objects, etc.
No object will be deleted.
03. Now define the required temporary table accordingly.
04. Using the Database Explorer "Delete" the old report.
05. Using the Database Explorer "Copy" the newly fixed report
as the original report name and make sure to associate
the report with correct temporary table.
That's all there is to it.
Have fun!
Very Best R:egards,
Razzak.
