Home » Developer & Programmer » Reports & Discoverer » Continued.
Continued. [message #205167] Thu, 23 November 2006 13:20 Go to next message
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.

Re: Continued. [message #205203 is a reply to message #205167] Thu, 23 November 2006 20:23 Go to previous message
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

Try to put this on format trigger of your total(must be varchar)

if record < total then
return 'Continued';
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

Previous Topic: try to put two report into one
Next Topic: procedure entry point psoasyn could not be located in orapls.dll
Goto Forum:

Current Time: Sat Aug 19 23:17:44 CDT 2017

Total time taken to generate the page: 0.07235 seconds