I'm passing few parameters from graph file to Excel report that are displayed in the header. They all work fine but one of them (PRVR) if PM has a value of 1,000,000 or greater it passes ********* to another report, if it's less it works ok.
What is the size of PRVR? If it's less than 9, you may try a DEFINE virtual field and use that in the report and the stylesheet drilldown.
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
September 04, 2009, 03:44 PM
arsalan
PRVR is not a defined field, just using here. Also, PM, whose value is going in PRVR is a computed field in the middle of the code. That makes it difficult to DEFINE a field on top of the code that would contain PM's vlaue. If you can specify with an example that would help. Thanks.
September 04, 2009, 05:03 PM
mgrackin
Try increasing the length of the PM computed field. Make sure its length is long enough to fit numbers above 1,000,000.
Thanks!
Mickey
FOCUS/WebFOCUS 1990 - 2011
September 08, 2009, 10:38 AM
arsalan
I had PM as D12.6 and PMVAR would not show actual value beyond 1,000,000 I changed PM to D12.3 and it now passes all the values that I've seen so far. Wondering PMVAR has some default size set by WebFocus?
September 08, 2009, 12:26 PM
Tony A
To understand why that worked you really need to understand what the formats actually represent. Unlike some other languages a D12.6 doesn't mean 12 integer positions and 6 decimal places, it actually means 12 characters of which the last 6 are decimals and the 7th to last is the decimal point. So your maximum display in a D12.6 would be 99999.999999.
Read the manual section on formats to get a better understanding of what you are doing and then you might be prepared for the intricasies such as this.
T
In FOCUS since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
WebFOCUS App Studio 8.2.06 standalone on Windows 10
September 08, 2009, 02:39 PM
arsalan
I somewhat guessed that when I was testing different values. Thank you all for your replies.