|
Excel file production from SQR |
|
|
Written by Brent Martin
|
|
Wednesday, 28 November 2007 |
|
Got this e-mail the other day and I thought I'd pass it along: Hi Brent,
Several years ago while I was employed by Fastenal Company I wrote a set of procedures that enable you to write SYLK files from SQR. These Excel files can contain a fair amount of formatting. I think it will work with any version of SQR. I believe we were running version 4.3 at the time of its creation.
The code is open source (thanks to Fastenal Company) and is available free at:
The Ray Ontko Company
http://www.ontko.com/sqr/sylk.html
Thanks,
Jim Womeldorf
http://greeniceenergystorage.blogspot.com/ I'm not sure how this is different from David Vandiver's Excel libraries , but it's always good to have options. If you do want to write Excel files from SQR, you'll probably be interested in how to publish them to the report repository . This web site also has a very nice SQR reference library at http://www.ontko.com/sqr/.
|
|
Last Updated ( Monday, 28 January 2008 )
|
|
|
Sending SQR Output Files to the Report Repository |
|
|
Written by Brent Martin
|
|
Tuesday, 10 April 2007 |
|
Just yesterday one of my co-workers was using David Vandiver's Excel libraries for SQR to create a spreadsheet document from Excel, and he wanted to send the spreadsheet to the report repository. I knew you had to write to the $PS_HOME/appserv/prcs/[DBNAME]/log_output/SQR_<sqrName>_<ProcessInstance> directory but I wasn't sure the best way to go about it. Anyway I asked David, and he pointed me to this article that describes several options to get the directory programatically so the path name doesn't have to be changed as you migrate it from environment to environment. The option I like is to select PRCSOUTPUTDIR from PSPRCSPARMS for your process instance, then prepend that directory to your filename before you open it. David has written the code for this approach here . Thanks, David!
|
|
Last Updated ( Tuesday, 10 April 2007 )
|
|
|
