Hi,

  I am Nagendra, i have some problem in my report.
I want print grand total at the last page and the fixed place. it should print at same place irrespective of no.of records.


regards
Nagendra P.

Firstly you need to set-up a query in the 'before-report-trigger' to
count how many records your main query will bring back.  

The following query is in my 'before-report-trigger' and immitates my
main query ..

select count(*)
into :p_no_recs
from customer;

Eg. I have a main query that brings back 105 records therefore :p_no_recs = 105

In my main query I have a formula column as follows:

function CF_1Formula return Number is
begin
  :p_count := :p_count + 1;
return (:p_count);
end;


I have a summary column cs_grand_tot, at report level enclosed by a frame M_1, print condition MUST BE all

On M_1 I have a format trigger:-

function M_1FormatTrigger return boolean is
begin
if :p_count = :p_no_recs then
  return (TRUE);
else
  return (FALSE);
end if;
end;

Now for the important bit ... if you want the grand total to appear in a fixed position anywhere on the last page you must place the frame above the main query frame ... and OVERLAPPING it (not outside or inside)

It must not sit within the main query's frame becase this causes the
grand total to appear after the main frame records.

It works, give it a go !

Cheers
Greg B.