Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] first record format
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] first record format
 Login/Join
 
Silver Member
posted
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
 
Posts: 32 | Location: memphis,tn | Registered: January 25, 2007Reply With QuoteReport This Post
Guru
posted Hide Post
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
 
Posts: 285 | Location: Texas | Registered: June 27, 2006Reply With QuoteReport This Post
Expert
posted Hide Post
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
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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.
 
Posts: 1533 | Registered: August 12, 2005Reply With QuoteReport This Post
Silver Member
posted Hide Post
thank you for your responses.

I told customer to insert blank columns manually.

Thanks,
Sareesh.


Webfocus 7.6.8
PDF,HTML & EXCEL
 
Posts: 32 | Location: memphis,tn | Registered: January 25, 2007Reply With QuoteReport This Post
Expert
posted Hide Post
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.
 
Posts: 3045 | Location: Middle Tennessee [8204M Gen48 in Test&Prod] | Registered: February 23, 2005Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] first record format

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.