i want to hide the column "FIELDVAL" In the exl07 report output
TABLE FILE CAR PRINT BODYTYPE SEATS DEALER_COST BODYTYPE AS 'Body Type' COMPUTE FIELDVAL/A50 ='This column showed be Hide in this report'; AS 'Column Title' COMPUTE DUMMY/A5 =''; AS '' BY COUNTRY ON TABLE PCHOLD FORMAT EXL07 ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * SQUEEZE=ON, WRAP=OFF, $ TYPE=REPORT,COLUMN=FIELDVAL, SQUEEZE=0.02,$ TYPE=TITLE, COLUMN=DUMMY,BACKCOLOR=RGB(255 255 255),$ TYPE=DATA, COLUMN=DUMMY,BACKCOLOR=(RGB(255 255 255) RGB(255 255 255)),$ ENDSTYLE END
Thank youThis message has been edited. Last edited by: FP Mod Chuck,
WebFOCUS 8202
February 23, 2018, 11:58 AM
FP Mod Chuck
Developer
Put NOPRINT at the end of that line.
Thank you for using Focal Point!
Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats
February 25, 2018, 03:06 PM
Waz
I think he wants to Excel-Hide the column
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
February 26, 2018, 01:30 AM
Developer
Yes Waz
i need like the functionality of excel hide and unhide in webfocus
if we apply the SQUEEZE on the "FIELDVAL" column when there is no data its working on tittle
if we have a data then its not.
Thank you
WebFOCUS 8202
February 26, 2018, 08:35 AM
MartinY
If I understand well, you want to include the column in the report but not have it shown. But if you perform an "unhide" in Excel have it displayed ?
Us an Excel-Macro template to send your data in. Your macro will hide the column. But this it's Excel who will perform the "hide", not WebFocus.
WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF In Focus since 2007
February 26, 2018, 09:30 AM
Developer
yes exactly that functionality
using Excel-Macro template it can work ?
could you Please give some example for Excel-Macro template.
Thank you
WebFOCUS 8202
February 26, 2018, 09:43 AM
MartinY
I cannot provide Excel-Macro Template sample here.
If you do search the forum and TechLibrary you will find how to us an Excel template and even the GUI is giving you the option.
You must first built your template with the macro in. This file will then be the one you will refer as your focus output format. It will be something such as this
TABLE FILE CAR
PRINT RETAIL_COST
BY COUNTRY
BY CAR
ON TABLE PCHOLD FORMAT XLSX TEMPLATE 'yourFileName.xlsm' SHEETNUMBER 1
END
WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF In Focus since 2007