[SOLVED] Rules for "ON TABLE PCHOLD AS ' &ERVAR' FORMAT EXL07"
FOCUS Nation:
We want to create unique excel outputs, format EXL07 or XLSX, with something similar to
"ON TABLE PCHOLD FORMAT AS '&DATE Details' FORMAT EXLO7"
Somehow I am now adding the &VARIABLE correctly and the Excel does not open but is sent over to be saved in an unassigned folder.
TIA for any suggestions. I did check all over Tech Support and Focal Point and I am reasonably assured that somebody will find an already-published solution. The ready responses is what makes Focal Point awesome. This message has been edited. Last edited by: S.J. Kadish,
Does your &DATE variable have "/" in it? You should probably remove them when using the variable in a file name.
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
February 09, 2017, 09:56 PM
j.gross
Sandy--
Simple rule: It will work with an amper var if, and only if, it works when the value is hard-coded.This message has been edited. Last edited by: j.gross,
- Jack Gross WF through 8.1.05
February 10, 2017, 11:29 AM
S.J. Kadish
I appreciate everybody's help here. I was able to use the following:
-SET &SAVE_DATE = &DATEMTDYY; -* YADA YADA YADA (must retain as a comment) ON TABLE PCHOLD AS 'Subrogation &SAVE_DATE' FORMAT XLSX
Minor item - the file name is lower case.
I am not closing this one yet because some other folks may have some sage advice to share.