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     how to define a column that's just a blank
Go
New
Search
Notify
Tools
Reply
  
how to define a column that's just a blank
 Login/Join
 
Member
posted
I need my report to have certain columns in certain orders, and I need to insert a few columns that are just blank. I've got other data fields that are numbers and dates.

Is there a simple way to define something and just have it return a blank column in the report?

Thanks!


wFDS: 7.7.03, OS: Windows, Output: Mostly Excel
 
Posts: 22 | Registered: November 15, 2012Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Is this what you're looking to accomplish?
DEFINE FILE CAR
BLANK/A1 = '';
END
TABLE FILE CAR
PRINT MODEL
      BLANK
      SEATS
BY CAR
END
-EXIT


WF 7.7.05
HP-UX - Reporting Server, Windows 2008 - Client, MSSQL 2008, FOCUS Databases, Flat Files
HTML, Excel, PDF
 
Posts: 149 | Location: Dallas, TX | Registered: June 08, 2007Reply With QuoteReport This Post
Virtuoso
posted Hide Post
DEFINE FILE CAR
SP/A1 = HEXBYT(160, 'A1');
SP2/A2 = SP|SP;
END
TABLE FILE CAR
PRINT CAR
SP
SP2
BY COUNTRY
END  


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Reply With QuoteReport This Post
Expert
posted Hide Post
Smiler . . . HEXBYT . . .
 
Posts: 3035 | Location: Middle Tennessee [8204M Gen48 in Test&Prod] | Registered: February 23, 2005Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Or just
TABLE FILE CAR
PRINT 
  CAR
  COMPUTE SP/A1=; AS ''
BY COUNTRY
END 
 
Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     how to define a column that's just a blank

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