Focal Point
[SOLVED]How to suppress printing field names in a report

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

November 04, 2015, 02:50 PM
Harold Trammel
[SOLVED]How to suppress printing field names in a report
Hi all,

In order to copy data from one system into another "generic" system, I have a requirement to produce an Excel document that follows a strict template. The file begins with four lines of text, column descriptions, and column names from a provided template file and is followed by data from database being copied. I have pulled the data from the Excel template document into a HOLD file with 62 fields. I have extracted needed data from the database and put that into a second hold file with 62 fields. To make sure that I could concatenate the files, I used FIELD_1 ... FIELD_62 as field names for both HOLD files and forced all the columns to have the same format. So far so good.

Now I need to send the combined files to an Excel file for processing. The issue is that I cannot have the field names printed to the file. If the created file does not match the template format exactly, the data will not be read into the new system. This will become part of an automated process so opening the Excel file up each time and removing the first row is not a good solution.

I have searched here for some way to skip the first line or suppress field names.

Any suggestions would be appreciated.

Harold

This message has been edited. Last edited by: <Emily McAllister>,


WebFOCUS 8.1.0.1 M
Windows Server 2008
PDF, HTML, Excel
November 04, 2015, 03:02 PM
Harold Trammel
I stumbled on to the answer to my own question. I printed each of the fields as '' and that created a blank line. The export to Excel was perfect.


WebFOCUS 8.1.0.1 M
Windows Server 2008
PDF, HTML, Excel
November 04, 2015, 05:28 PM
David Briars
Harold-

Is the HAL 9000 operational?

(I realize you must get this all the time, sorry. Nice that you follow up on your post. :-))

-Dave




Pilot: WebFOCUS 8.2.06 Test: WebFOCUS 8.1.05M Prod: WebFOCUS 8.1.05M Server: Windows Server 2016/Tomcat Standalone Workstation: Windows 10/IE11+Edge Database: Oracle 12c, Netezza, & MS SQL Server 2019 Output: AHTML/XLSX/HTML/PDF/JSCHART Tools: WFDS, Repository Content, BI Portal Designer & ReportCaster
November 04, 2015, 06:23 PM
Harold Trammel
"I'm sorry, Dave, but I cannot tell you that." Back in 2001, that year's Ebertfest featured a remastered version of "2001: A Space Odyssey". I don't mind that reference at all.

-H


WebFOCUS 8.1.0.1 M
Windows Server 2008
PDF, HTML, Excel