a simple report!!

[saritha]

Hello all,
I have a simple report here with a query say "select * from emp"...... The report displays its information deptno wise on every page i.e deptno 10 is displayed in 1st page deptno 20 is displayed in 2nd page...etc when hiredate is passed as a parameter to the report.My report has two groups one for deptno & sum(sal) and the group for other fields (empno,ename , sal..so on) . My question is how do I display the deptno on the top of the everypage.

the format of the report is:1st page

DEPTNO:10

EMPNO ENAME SAL JOB COMM
100 AAA 3000 clerk 80
200 BBB 2000 xyz 100
300 CCC 1000 abc 90
---------------
6,000$


2nd page:

same way...

I just want the deptno to be displayed on the top of the page.
how do I do that?


Thanks
Saritha

[dinesh_hm]

The simplest way to acheive that would be to
use the group above type of report in the
report creation wizard

Then in the group fields option select the
desired column and if you desire to give a page break
for every new value of the column set the maximum records per page in the property palette
to 1 for the repeating frame enclosing the object

[saritha]

Hi dinesh,
Thanks is there any other way to handle that, because I have different issue too to be considered if I use group_above type the other issue doesn't work.

I used group_left because it should display sum(amont) for all rev_codes whcih start with 10,000 or 72,000 or 53,000....
for all thse rev_codes I want the sum (amt) and also for each rev_code starting with 10,000 or 53,000 or 72,000 i want the sum(amt), so for this to happen I used group_left.

Is there any other way?

thanks
saritha

[dinesh_hm]

Is your report a matrix type of a report ?
if you can tell me/mail me (dinesh_hm@yahoo.com) the exact format of the desired output , then maybe a definite solution can be given .