I am having a problem displaying only certain lines in my report. I only want to look at the information on lines 50, 51, 52 and 53 that begins with certain criteria.I have no idea how to just display those 4 lines. Any help is appreciated.This message has been edited. Last edited by: Kerry,
August 25, 2010, 10:15 AM
Prarie
What is the Criteria? When you say Begins...like a string of characters?
In Focus since 1993. WebFOCUS 7.7.03 Win 2003
August 25, 2010, 10:16 AM
<d3nis370>
Its the begining of a policy number like AQH or AQS
August 25, 2010, 10:20 AM
Francis Mariani
WHERE POLICY_NBR LIKE 'AHQ%' or POLICY_NBR LIKE 'AQS%'
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
August 25, 2010, 10:23 AM
<d3nis370>
Francis I got that part but how do I make my query to only look at the policy numbers on lines 50-54?
August 25, 2010, 10:32 AM
Francis Mariani
What? Will they always be on lines 50-54 - what makes the policy numbers on lines 50-54 different that the others? I dontgetit!
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
August 25, 2010, 10:42 AM
Prarie
Yes I agree with Francis...will they always be on those lines? There has to be something else that makes them different...and you need to screen on that also.
August 25, 2010, 01:17 PM
Darin Lee
Once you limit the report to the data on lines 50-54, they're no longer on lines 50-54 - they're lines 1-5. If you know the exact LOCATION (as opposed to slecting on values of those records) you could do something like this.
TABLE FILE CAR PRINT COUNTRY MODEL COMPUTE COUNTER/I2=COUNTER + 1; BY COUNTRY WHERE TOTAL COUNTER FROM 5 TO 9; END
Regards,
Darin
In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat
August 25, 2010, 05:46 PM
Waz
I think Darin's suggestion is the way to go, the lines can always be parameterised, and determined prior to the TABLE FILE, assuming the range of lines can be determined.