Focal Point
Can PRINT something AS be conditional?

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

June 15, 2006, 02:38 PM
Suzanne
Can PRINT something AS be conditional?
I am graphing multiple graphs in the same fex. I need different y-axis labels for a couple of them. I would like for the label to be determined based on the value of another field. Is it possible to set a condition when printing a field AS?


WF 766
Win2K
June 19, 2006, 04:49 PM
Trav
Your AS can definitely be an amper variable, so if you could figure out how to get the value of your label into an amper, you could do it. That may not get you where you want to go though since you need it based on other values in your report?

example:

-SET &LABEL 'Car Name';
TABLE FILE CAR
PRINT CAR AS '&LABEL'
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
END




Production: 7.6.6 WF Server  <=>  7.6.6 WF Client  <=>  7.6.6 Dev Studio
Testing: <none>
Using MRE & BID.  Connected to MS SQL Server 2005
Output Types: HTML, Excel, PDF
June 20, 2006, 08:33 AM
<JG>
Suzanne You need to generate the labels dynamically and include them
in the API code

Look at the following post

https://forums.informationbuilders.com/eve/forums/a/tpc/...801026531#6801026531
June 20, 2006, 09:35 AM
Suzanne
Thanks for the replies! Is it possible to use the logic for the setY1TitleString command? I have tried without success. I don't get an error, but nothing is displayed.


WF 766
Win2K
June 20, 2006, 09:48 AM
venu
based on your logic populate a variable
and set this variable to setY1TitleString