John, I hope you have received some useful ideas by now. We use UniVerse on a Windows Platform. After MS Office 2003, the use of xls/xlsx files have been a little more structured. What we do is generally use tab delimited files when the end user will only accept a data file. What we prefer to produce is a pdf file that has a nicer report format or a graph of some kind. We create pdf files from MSWord as well as MSExcel with the Office2010 suite. We execute a file from within UniVerse (e.g. &Hold& location) that produces a pdf and then send it to the end user. We have found this to be very helpful since we can distribute the report/graph and not have to be device specific for viewing purposes.
If you would like additional help on what I mean by executing a document from within UniVerse then please let me know. Here is some brief help on crafting an execute statement to call a doc and create a pdf (e.g. char(27)char(91)char(93)<docpath>char(27)char(91)char(49)char(50)char(42)). Beau Thompson Lead App/DB Developer [email protected] Date: Mon, 6 Feb 2012 16:39:51 -0500 From: "Israel, John R." <[email protected]> To: 'U2 Users List' <[email protected]> Subject: [U2] Building an Excel File Message-ID: <[email protected]> Content-Type: text/plain; charset="us-ascii" We are running UniData on a UNIX platform. We create tab-delimited txt files (and tab delimited txt files with xls extensions) all the time that users open with Excel. Many of these jobs are run in the middle of the night or in a trigger program. In all cases, there is no direct user interaction building these files. We also have some XML files that are coded so that Excel opens them with formatting, colors, filters, etc. Unfortunately, our BB users and iPhone users can not open these files up in a meaningful way. Is there a way to build a TRUE Excel file without any user intervention from UniData or UNIX? John John Israel Senior ERP Developer Dayton Superior Corporation 1125 Byers Rd Miamisburg, OH 45342 Office: 937-866-0711 x44380 Fax: 937-865-9182 [email protected] This message w/attachments (message) is intended solely for the use of the intended recipient(s) and may contain information that is privileged, confidential or proprietary. If you are not an intended recipient, please notify the sender, and then please delete and destroy all copies and attachments, and be advised that any review or dissemination of, or the taking of any action in reliance on, the information contained in or attached to this message is prohibited. _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
