Home » Fusion Middleware & Colab Suite » WebCenter Suite & Portal » Re: Creating a report with the AVG shown at the bottom of the report
Re: Creating a report with the AVG shown at the bottom of the report [message #77356] Wed, 24 April 2002 02:37
arun kumar
Messages: 13
Registered: April 2002
Junior Member
First of all i didnt understand u'r problem as far as i have understood i shall tell u

The Example table which i have selected in
Employee

The Fields are Empno,Ename,Sal And Input_month_year

The Query i will issue for this Example Report Will be
Select
Empno empno,
Ename ename,
Sal sal,
Input_month_year inmon1,
Input_month_year inmon2
From
Employee

In the above Query u can see that i am Repeating the Column Input_month_year for your convienience

First of all i shall show to do this report using a Wizard

OPen the report builder
Issue the Query

Select the Group left Report
group it by inmon1 and select all the fields for the report including the Duplicate input month year inmon2

and then in the totals Select the sal and then the Average for that
When u select the average u get 2 averages
on eis for each input month year and the other for the whole report
Please select only the average for the whole report and not for indivisual input month year

do not display inmon1 Do this using the Wizard u'r Query is Answered

And one more thing Please creat a table befor u do this report

create table employee1
(
Empno varchar2(10),
Ename varchar2(20),
Sal number(10,2),
Input_month_year date
)
/
Previous Topic: Login to portal/mod_plsql
Next Topic: Re: not getting connection from the client
Goto Forum:
  


Current Time: Sun May 31 19:08:51 CDT 2020