| 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
)
/
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
