Hi Razzak My primary table is created correctly. However I tried you suggestion can copied the report and used an existing table as the primary table and it still will not open in the designer. I traced the epp and it stops exactly at the point of syntax error and aborts.
Any suggestions? Ajay "A. Razzak Memon" <[email protected]> Sent by: [email protected] 03/11/2009 07:07 PM Please respond to [email protected] To [email protected] (RBASE-L Mailing List) cc Subject [RBASE-L] - Re: Error in Before design EEP 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. P Please consider the environment before printing this e-mail. Thank you.
