I am exporting data into excel sheet. My requirement is to insert space in first record in one of the columns. can anyone help?
Column1 Column2 Column3 Column4
A blank blank D
and also I want to include border for first record.
Webfocus: 7.6.8,ExcelThis message has been edited. Last edited by: Kerry,
PDF,HTML & EXCEL
If the report output is static, ie.. the report length does not change.. you may want to look into excel template.
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
Can you make the first record a subhead?
As Sayed alluded to, I think you can only do borders in Excel with a template.
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
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.
thank you for your responses.
I told customer to insert blank columns manually.
PDF,HTML & EXCEL
Don't do it manually (imho) when
Consider DEFINE FILE or COMPUTE...
|Powered by Social Strata|