-1

Report Sheet deleted when Design or Refresh is clicked

Jet Reports Historic Posts

September 10, 2014 19:28

None

Follow

Hi JET-btr,

Thanks for the help with this, it worked. I am not sure how it was created, as it is an older report created by a person no longer with the company.

Tkaal

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Jet Reports Historic Posts September 10, 2014 19:28

  Hello,
  
  I am new to Jet and to the JetReports Community forum, and I am not quite sure how this works, but here is my dilemma…
  
  I have a report that has an option tab and a report tab…when I click on Design or on Refresh, the report tab is deleted. It is not hidden, it is gone.
  
  I am not sure what other information to provide, but I have attached the file.
  
  Thanks in advance for any help.

  • CRP 612.xls
• 0
  
  Jet Reports Historic Posts September 10, 2014 20:02

  I had the same problem with your report but if I changed Cell A1 of the report to Auto+Hide+VALUES, it no longer disappeared.
  
  Did you create this report or did you use one of the Wizard tools?

• 0
  
  Jet Reports Historic Posts September 11, 2014 15:15

  Just as a followup - in looking at your original report, it appears that it was became slightly corrupted at some stage.
  
  The A1 cell actually had Auto+Hide+VALUES+Formulas=Sheet18,Sheet1,Sheet2+Autosheet
  everything that follows the VALUES looks very similar to problems I have created in my own work when I didn't properly return to the design mode before working on a report.
  One way I have done this is to put an excel filter on a report after I've run it, and then tried to return to design mode without removing the filter.
  
  Of course, this sort of thing is also the reason that most of my reports have backup versions - but that can cause it's own headache if I don't remember to save a new backup version once I've made changes :)