Lost Data Tab on Report Query Window 1

[HaleyJo]

I was creating a report as an Admin using the Data tab in the Report>Query window but now when I open Report>Query, the SQL tab is the first tab. I no longer have a Data tab and can no longer modify the report. I must have selected the Profile tab, clicked the SQL Radio Button, clicked Edit, then OK. I have not modified the SQL. HELP! How can I get the Data tab back?

 

[B555]

The only time I have seen that is if you saved your IMR as a snapshot. When you do that it locks your data so it will always look at what you had when you saved it. If you did this, I don't know of any way to get it back with out a rebuild.B

 

[mfgf]

You are seeing the SQL tab instead of Data, Filters etc because the report has been converted to use hard-coded SQL (by pressing the "Convert to SQL" button). Once this has been done and the report has been saved, there's no way back, sorry. You will need to create the report again from scratch.

Regards,

MF.

 

[HaleyJo]

Many thanks for the responses. Even though it was not the answer I wanted, at least I can move on and stop trying to find a way to backout what I did.