Is there a way to save all non-hidden data in Jet Reports as a CSV file? We want only displayed data to be saved as the file (e.g. no "auto+hide+values" or any hidden columns/rows).
Here's an outline of our current process (multiple CSV's daily):
1) Select all.
2) Click on "Select Visible Cells" icon (found this from an Excel tips website, otherwise would've had to delete hidden cells each time after pasting).
3) Choose "Copy".
4) Open a new Excel Sheet.
5) Right click mouse, see if "Paste Special…" is there.
6) "Paste Special..", "Values and Number Formats" into a new file. Sometimes, it doesn't allow you to choose "Paste Special…" and you have to close all Excel files and re-open file for it to work.
7) Save as CSV, click OK to first message box, click Yes to second message box.
Can someone suggest an easier method? Bonus points if it can be used with Jet Scheduler.
Thanks,
Alex
Date
Votes
4 comments
-
Jet Reports Historic Posts I have also looked into this and was informed that you cannot save the report without the hidden formulas. our Navision tech went to a jet class a few weeks ago and specifically asked this question. Sorry, i wanted to do this also.
-
Jet Reports Historic Posts Have you tried using a macro within Excel?
Perhaps Jet Report could give us some guidlines or details on how to invoke a macro after Jet calculations are complete? -
Jet Reports Historic Posts Have you tried using a macro within Excel?
Perhaps Jet Report could give us some guidlines or details on how to invoke a macro after Jet calculations are complete?
I'd like to know that to, I've been looking for it the other day but didn't find it right away. -
Jet Reports Historic Posts I have had a quick look through the help for Jet 'Automating Reports and Programmability', 'Programming with Jet Reports', they detail some of athe VBA code.
You can record a macro to cater for your output steps, then within the code editor, insert the jet code around that. You may want to experiment with the Jet VBA code on its own first to find out exactly which to put before and after your code.
Alternatively, you could set your Jet report to run automatically, then record a macro from another sheet to open it, and save as CSV. We actually use a SQL Server DTS package to read information out of scheduled Jet reports - so that may work for you too.
Please sign in to leave a comment.