Focal Point
[SOLVED] Rules for "ON TABLE PCHOLD AS ' &AMPERVAR' FORMAT EXL07"

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/5687084586

February 09, 2017, 11:24 AM
S.J. Kadish
[SOLVED] Rules for "ON TABLE PCHOLD AS ' &AMPERVAR' 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. Cool

This message has been edited. Last edited by: S.J. Kadish,


Sandy Kadish
Dev: 8.2.04- PostgreSQL
Test: 8.2.04 - PostgreSQL
Prod: 8.2.04 - PostgreSQL
February 09, 2017, 12:47 PM
Francis Mariani
The O in EXLO7 is just a typo when posting here?

Zeros: 000000000000000000000
Os: OOOOOOOOOOOOOOOOOOOO


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, 12:50 PM
S.J. Kadish
Thanks, Francis
Smarter to type "ON TABLE PCHOLD FORMAT XLSX" Wink


Sandy Kadish
Dev: 8.2.04- PostgreSQL
Test: 8.2.04 - PostgreSQL
Prod: 8.2.04 - PostgreSQL
February 09, 2017, 12:53 PM
Squatch
quote:
Originally posted by Francis Mariani:
The O in EXLO7 is just a typo when posting here?

Zeros: 000000000000000000000
Os: OOOOOOOOOOOOOOOOOOOO

Hence the historic use of a slash in the zero:




App Studio
WebFOCUS 8.1.05M
Windows, All Outputs
February 09, 2017, 01:47 PM
Francis Mariani
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) Wink
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.

More critical - have a great weekend. Smiler


Sandy Kadish
Dev: 8.2.04- PostgreSQL
Test: 8.2.04 - PostgreSQL
Prod: 8.2.04 - PostgreSQL