Focal Point
[SOLVED] first record format

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

October 20, 2010, 02:06 PM
SG
[SOLVED] first record format
Hello All,

I am exporting data into excel sheet. My requirement is to insert space in first record in one of the columns. can anyone help?

Data:
Column1 Column2 Column3 Column4
A blank blank D
B C
and also I want to include border for first record.


Thanks,
SG.
Webfocus: 7.6.8,Excel

This message has been edited. Last edited by: Kerry,


Webfocus 7.6.8
PDF,HTML & EXCEL
October 20, 2010, 03:20 PM
Sayed
If the report output is static, ie.. the report length does not change.. you may want to look into excel template.

Thanks,
Sayed


WF 8.x and 7.7.x Win/UNIX/AS400, MRE/Portal/Self-Service, IIS/Tomcat, WebSphere, IWA, Realmdriver, Active Directory, Oracle, SQLServer, DB2, MySQL, JD Edwards, E-BIZ, SAP BW, R/3, ECC, ESSBASE
October 20, 2010, 03:27 PM
GinnyJakes
Can you make the first record a subhead?

As Sayed alluded to, I think you can only do borders in Excel with a template.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
October 21, 2010, 09:54 AM
njsden
Ginny is right about the border issue in Excel (EXL2K) format as is only supported as of WebFOCUS 7.6.9 which a bit more recent than the one SG currently uses.

SG, I don't think I understand your presentation requirement correctly. Is this perhaps what you need?

Column1                   Column2  Column3
A       <blank>  <blank>  B        C 


If so, you just need to add a couple of dummy columns with no titles.

DEFINE FILE CAR
DUMMY/A1 WITH CAR = ' ';
END

TABLE FILE CAR
PRINT COUNTRY AS 'Country'
      DUMMY AS ''
      DUMMY AS ''
      CAR     AS 'Car'
      MODEL   AS 'Model'
ON TABLE PCHOLD FORMAT EXL2K
END


When posting either code or "sample output", please make sure to use the "</>" button in your Post window toolbar.

- Neftali.



Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
October 22, 2010, 03:53 PM
SG
thank you for your responses.

I told customer to insert blank columns manually.

Thanks,
Sareesh.


Webfocus 7.6.8
PDF,HTML & EXCEL
October 23, 2010, 10:00 PM
Doug
Don't do it manually (imho) when

"We Can Do That In WebFOCUS!"


Consider DEFINE FILE or COMPUTE...


   In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
   Most recent: 8204 Gen 48 in Test and Production.
   Currently Available. Please contact me.