Focal Point
[SOLVED] NOPRINT error

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

September 17, 2018, 11:51 AM
KellyT
[SOLVED] NOPRINT error
Hello,
I'm getting an error now with App Studio 8204 when I have a NOPRINT to display or not display a column in my report. This code worked in App Studio 8104. The &orderNumInvisible.(,<''>). is the code that isn't working.

  TABLE FILE HOLDPULOADDATA
PRINT
     HOLDPULOADDATA.SEG01.BOL AS 'Shipment ID #'
     J0.SEG01.DELLATEFLAG NOPRINT
	 J1.SEG01.show AS 'PO #'
     &orderNumInvisible.(<NOPRINT>,<''>).
     HOLDPULOADDATA.SEG01.Pro# AS 'Trip #'
     HOLDPULOADDATA.SEG01.Trac AS 'Tractor'
     HOLDPULOADDATA.SEG01.Trlr AS 'Trailer'
     HOLDPULOADDATA.SEG01.macroDescription AS 'Trailer or Container'
     HOLDPULOADDATA.SEG01.PUCUSTNAME AS 'Origin Name'
     HOLDPULOADDATA.SEG01.OriginCity AS 'Origin City'
     HOLDPULOADDATA.SEG01.OrigSt AS 'Origin St'
     HOLDPULOADDATA.SEG01.originRegion AS 'Origin ,Region'
     &originRegionInvisible.(<NOPRINT>,<''>).
     HOLDPULOADDATA.SEG01.originMarketArea AS 'Origin ,Market Area'


Thanks in Advance for all your help.

This message has been edited. Last edited by: KellyT,


Prod: WebFOCUS 8.2.0.4
OS: Windows
Outputs: HTML, PDF, Excel, PPT
In Focus since 2005
September 17, 2018, 12:15 PM
BabakNYC
Try adding -SET &ECHO=ALL; and run the code to see how the &variables are being treated.

I tried a similar example and I think the problem is you need a space between ''s.

-SET &ECHO=ALL;
TABLE FILE CAR
PRINT
CAR AS 'AUTOS'
SEATS NOPRINT
SALES AS 'Sales' &orderNumInvisible.(,<' '>).
BY COUNTRY
END


WebFOCUS 8206, Unix, Windows
September 17, 2018, 01:58 PM
KellyT
Hello,
Thank you. By putting the space in between the ' ' it worked. Not sure why that would have changed between 8104 and 8204 but it did. Smiler


Prod: WebFOCUS 8.2.0.4
OS: Windows
Outputs: HTML, PDF, Excel, PPT
In Focus since 2005