We have one excel report which will be generated with dynamic number of columns using the Print *. Now I would like to print all columns except first column. As I don't know specific number of columns count, how can be this achieved?
Iam using Webfocus 764 version.
Thank You Sandhya JThis message has been edited. Last edited by: <Kathryn Henning>,
WEBFOCUS 8202/Windows PDF/HTML/XML
February 04, 2015, 04:08 PM
Waz
You should be able to using CHECK FILE HOLD and a -INCLUDE.
E.g.
TABLE FILE CAR
PRINT
COUNTRY
CAR
MODEL
BODYTYPE
ON TABLE HOLD AS TMP_CAR
END
-RUN
CHECK FILE TMP_CAR HOLD
-RUN
TABLE FILE HOLD
PRINT FIELDNAME
WHERE FLDNO GT 1
ON TABLE HOLD AS FEX_COLUMNS
END
-RUN
TABLE FILE TMP_CAR
PRINT
-INCLUDE FEX_COLUMNS
END
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 04, 2015, 04:39 PM
susannah
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
February 04, 2015, 10:08 PM
Sandhya j
Thank You Waz, this solution is working fine.
quote:
Originally posted by Waz: You should be able to using CHECK FILE HOLD and a -INCLUDE.
E.g.
TABLE FILE CAR
PRINT
COUNTRY
CAR
MODEL
BODYTYPE
ON TABLE HOLD AS TMP_CAR
END
-RUN
CHECK FILE TMP_CAR HOLD
-RUN
TABLE FILE HOLD
PRINT FIELDNAME
WHERE FLDNO GT 1
ON TABLE HOLD AS FEX_COLUMNS
END
-RUN
TABLE FILE TMP_CAR
PRINT
-INCLUDE FEX_COLUMNS
END
This message has been edited. Last edited by: Sandhya j,