| Continued. [message #205167] |
Thu, 23 November 2006 13:20  |
sasi242
Messages: 11
Registered: March 2005
Location: india
|
Junior Member |
|
|
Hi All
i am trying to run a report.i want to show 10 records/page and total at the end of each department.say a department has 12 records,then i want to put a message instead of total as "Continued" and then i want to show total in next page after the 12th record. any suggestions pls.
Thankyou
Sasi
|
|
|
|
| Re: Continued. [message #205203 is a reply to message #205167] |
Thu, 23 November 2006 20:23  |
|
|
Try to put this on format trigger of your total(must be varchar)
if record < total then
return 'Continued';
else
return to_char(total);
end if;
I haven't tried it but it might work.
If not then create text item on top of your total then
in format trigger do this.
On total = if record = total return false else true
on text item = if record < total return true else false
.. so that it will only display if applicable
[Updated on: Thu, 23 November 2006 20:26] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
