Focal Point
Extremely Challenging...
January 26, 2008, 01:11 AM
focuzsambitExtremely Challenging...
i want to display a report in the below format.
Country Model Dealer_Cost USA Honda 5,000
State Population CA 40000
VA 30000
Canada BMW 7,000
State Population OT 80000
ED 10000
Description:
1.(Country/Model/Dealer_Cost) and (State/Population) are pulled from mutiple data sources.
2. (Country/Model/Dealer_Cost) header comes one but the data repetatve....while (State/Population) header and data comes repetative as the value of country changes.
Any clue how to achive this ?
tks/sam
WF Server: 7.1.4 on Z/OS and Linux, ReportCaster
Data: DB2, DB2/UDB, Adabas, SQL Server, Oracle Output: HTML,PDF,Excel2K
WF Client: Servlet, CGI
January 26, 2008, 04:35 AM
Majid JeddiHi,
Can you post the code.
Thanks
WebFocus 7.6.5
AND WebLogic server as web server
sql2005 as database server
January 26, 2008, 04:53 AM
FrankDutchWhat if country has more than one model?
so
country model cost
usa honda 5,000
state population
CA 40.000
VA 30.000
country model cost
usa bmw 7,000
state population
?? ????
Is there an other link between the two tables than only the country code like sales per state??
|
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 |
January 26, 2008, 10:12 AM
susannahare you asking how to construct your focus database? with state as a segment under country, a sibling segment, if you're retaining the original car file.
or are you building your own database
with country model cost in segment 1, key on country.
and country state population in its child segment.
Or are you asking how to construct a report?
use the OVER command
| In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID |
January 26, 2008, 08:16 PM
LeahI would define a field containing the value "State Population" and use the over command to position the data on the page. I assume you were just using the car file as a for instance and that your data has only one line per 'country'?
Leah
January 27, 2008, 03:56 AM
Alan BIf you have the situation where you want to display one record followed by multiple (one car then multiple states) then a subhead on country for the COUNTRY/MODEL/DEALER_COST could be used.
If however you can have multiple records for COUNTRY/MODEL/DEALER_COST followed by multiple records for STATE/POPULATION, then TABLE is not a way forward I have found helpful. In the past I have used 2 different methods, DM and MAINTAIN, probably depending on the mood I am in, but both do the same thing, create an HTML output manually. Get the data, in COUNTRY order, into 2 SAVE files for DM, 2 stacks for MAINTAIN and then loop through. In DM I loop within -HTMLFORM BEGIN/END to read and display the data from both SAVE files, and in MAINTAIN I create a STACK displayed with the HTML object using roughly the same logic as in the DM.
Alan.
WF 7.705/8.007
January 28, 2008, 10:31 AM
jgelonaI like using MACGYVER. We do many reports like this:
State Totals
Area I Totals
County 1 Totals
County 2 Totals
County 3 Totals
(rest of counties in Area I)
Area II Totals
(counties in Area II)
.
.
.
Area VI Totals
(counties in Area VI)
MACGYVER works great for this kind of report.
In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.