0

Delete Hide Columns

Jet Reports Historic Posts

February 02, 2011 09:34

None

Follow

Hi,

I'm sure this question has been asked previously but I can't find it in the Search.

Can Jet delete hidden columns in the report on running Report/Refresh?

Thanks

Stuart

• Facebook
• Twitter
• LinkedIn

4 comments

• 
  Jet Reports Historic Posts February 03, 2011 00:43 Official comment

  Yep, thanks :)

• 0
  
  Jet Reports Historic Posts February 02, 2011 12:11

  Hi Stuart,
  
  The Jet Scheduler has an option to refresh a report and save it without hidden rows, columns and sheets. I've attached a screen shot of the options to set so that you may find and recognize it easily.
  
  Other than that, I don't know of a Jet Reports option to do it. I know some people wrote a VBA script to do the trick. Maybe they're willing to share their solution with us on this forum.

  • Scheduled task - Output.png
• 0
  
  Jet Reports Historic Posts February 02, 2011 23:07

  Thanks Hans. :)
  
  So it can only be done through Scheduler rather than as a report setting?

• 0
  
  Jet Reports Historic Posts February 03, 2011 00:36

  Hi Stuart,
  
  You are correct. If you actually deleted hidden rows, columns, or sheets, you would no longer be able to re-run the report since Jet formulas would be lost. It would be easy in this case for you to save over a report you had created with one that no longer contained Jet formulas and could no longer be refreshed. The scheduler, on the other hand, always saves a new file and never overwrites the original report, so it cannot destroy your report which is why this is an option in the scheduler. Does that make sense?
  
  Regards,
  Hughes