Report 2.5/Graphics 2.5 --- Passing and filtering data problem.

From: Wernberg-Tougaard <Christian.H:wernberg-Tougaard_at_uvm.dk>
Date: 8 Jul 1998 09:46:23 GMT
Message-ID: <01bdaa54$68394380$100514ac_at_chwer1>

In a report I do some calculations on data retrived from a group-expression.
The recived data look-like this:

Group 1		Type 1		Data1
Group 1		Type 2		Data2
Group 2		Type 1		Data3
Group 2		Type 2		Data4

etc.

I manipulate data (Data1-4) so the output is like this

Group 1		Data1 / Data2	(divided by)
Group 2		Data3 / Data4

etc.

My problem is, that when I pass data into Graphics something goes wrong. There is on every graph, 2 identical plots, which, I my opinion, is due to Type1 and Type2.

If I have understood Graphics correctly, the query specificed retrive data (from reports) without asking any questions (as long the types match). This is why I can't resolve the problem with a "GROUP BY" expression in the query.

I have thought of many solutions, but yet one solving the problem remains. The present solution-suggestion is to use a query-filter, which goes like this:

FUNCTION OGQUERYFILTER1(chartobj IN og_object,

                        query IN og_query)
                        RETURN BOOLEAN IS

BEGIN
 if mod(rownum,2)=0 then return(true);
 else return (false);
 end if;  

END; This should remove every second row (and solve the problem). But as the filter executes for every row there is no knowledge of rownum.

Does anybody have any suggestions ????

Anyway, TIA

-- 
Christian Wernberg-Tougaard
Political Economist
Danish Ministry of Research and Information Technology, Building Society

Received on Wed Jul 08 1998 - 11:46:23 CEST