Focal Point
how to define a column that's just a blank

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

July 17, 2013, 03:16 PM
reportmasterlvl3
how to define a column that's just a blank
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
July 17, 2013, 03:24 PM
linus
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
July 17, 2013, 04:11 PM
Prarie
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
Smiler . . . HEXBYT . . .
Or just
TABLE FILE CAR
PRINT 
  CAR
  COMPUTE SP/A1=; AS ''
BY COUNTRY
END