I have created a report. It works fine. I have some nested NL functions, have some hidden columns and rows, etc. Now I want to take some of this information and forward it. I trickly want to have a worksheet with values. How do I take some of the info from my report page and put it to a new worksheet but only have values.
This is a report I run monthly. Some months I may have 10 rows, other months may have 100 rows, so there is not a set amount of information.
Thanks,
Amy
Date
Votes
1 comment
-
Jet Reports Historic Posts HI Amy,
The Jet Scheduler will do this. If you schedule the report to run, look at the Output page. You can change the output format to "Values Only Workbook" and check the "Remove Hidden Rows, Columns, and Sheets" box. Does that do what you want?
Regards,
Hughes
Please sign in to leave a comment.