Focal Point
field value in Graph heading?
September 04, 2007, 02:08 PM
Jason K.field value in Graph heading?
I would like to add a field's value to a graph subtitle.
I have
setSubtitleString("<YEARMONTH_NAME Consolidated Sales to Goal Graph");
the graph shows a title of literally "<YEARMONTH_NAME Consolidated Sales to Goal Graph" without evaluating the Yearmonth_Name field. I tried a .eval and got the same result.
Any ideas?
Prod: Single Windows 2008 Server running Webfocus 7.7.03 Reporting server Web server IIS6/Tomcat, AS400 DB2 database.
September 04, 2007, 02:27 PM
FrankDutchJason
you have to put that value in an amper value and then that will work
So do something like
TABLE FILE XXX
PRINT YEARMONTH_NAME
ON TABLE HOLD AS AAA FORMAT ALPHA
END
-RUN
-READ AAA, &YMN
.....
GRAPH ...
Now you can say
setSubtitleString("&YMN.EVAL etc...");
I hope this helps
|
Frank |
| prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7 |
September 04, 2007, 02:49 PM
Jason K.Super!
It works very well, thanks FrankDutch! One last thing, When I create this hold file, where does it go? I'm doing this in the MRE, and doing a search on the windows directory for the hold file's name 'AAA' I get nothing.
It's being rendered as 000006August for some reason, and I'm trying to figure out if the problem is in my HOLD file, or in the conversion using -READ AAA, &YEMN
Thanks!
Prod: Single Windows 2008 Server running Webfocus 7.7.03 Reporting server Web server IIS6/Tomcat, AS400 DB2 database.
September 04, 2007, 03:14 PM
FrankDutchThe file is just there for a while, only for this process.
Ad the start of your program type
-SET HOLDLIST=PRINTONLY
And see if that number is gone.
|
Frank |
| prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7 |
September 04, 2007, 03:27 PM
Jason K.I added the -SET HOLDLIST=PRINTONLY to my .fex and it still retains that 000006 in front of the August.
Ideas?
Prod: Single Windows 2008 Server running Webfocus 7.7.03 Reporting server Web server IIS6/Tomcat, AS400 DB2 database.
September 04, 2007, 03:31 PM
FrankDutchyes
change the line where you read the record
-READ AAA &FILL.A6. &YEMN.A9.
this is a fixed form read, you skip the first 6 characters.
|
Frank |
| prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7 |
September 04, 2007, 04:35 PM
N.SelphYou have to turn VARCHAR off. If your database was Oracle you use:
SQL SQLORA SET VARCHAR OFF
If its SQL Server it is
SQL SQLMSS SET VARCHAR OFF
or
ENGINE SQLMSS SET VARCHAR OFF
etc.
(Prod: WebFOCUS 7.7.03: Win 2008 & AIX hub/Servlet Mode; sub: AS/400 JDE; mostly Self Serve; DBs: Oracle, JDE, SQLServer; various output formats)
September 04, 2007, 05:09 PM
Jason K.Per your advice, I went ahead and changed my master file from A30V to an A30, it works now.
I'm amazed at how often I have to do that but I forget about it. I guess it's just the cost of having a tool that can use anything as a datasource.
Thanks for the help folks.
Prod: Single Windows 2008 Server running Webfocus 7.7.03 Reporting server Web server IIS6/Tomcat, AS400 DB2 database.