Save As Excel Greyed Out
I'm pausing my print script in the report preview mode. I can print, print setup, Save as PDF, but the Save as Excel is greyed out. I'm have admin priv. and all of my users have permission to "export".
Save as Excel will need to be selected when you are not paused in preview mode. Why do you need to do this? (Knowing why may suggest an alternate approach.)
May be a bad process...but it is how I show the user a "preview" of their report or form before they "continue" to the print dialog.
Certainly open to a better way.
It's the paused script that keeps this menu option from being available. If you just enter preview mode without pausing the script, you can select this option provided that your access privileges permit exporting data.
Unlike Save As PDF, the spreadsheet that is produced by this option does not attempt to reproduce what you see on the screen in Preview mode anyway so previewing it isn't much use in predicting what you'll find in the Excel file.
If you want to save as Excel, you can use this option either before or after you run the script to preview the report.
So, my options are:
End the script at the layout I would want to export/print (preview or not, optional). Is there an easy way to continue a script from there???
Include the export script step as an optional dialog box choice within the script
Is there an easy way to continue a script from there?
Put a button on your layout that performs the latter part of your script. This can be a button set in the Sliding and Visibility on the Inspector's position tab with "hide when printing" to keep it from appearing in printed copy or PDF's.
Great! That, and the conditional formatting, is creating some great UI options we couldn't have even imagined in 2.1 :-) Thanks for the help.
Retrieving data ...