Home » Developer & Programmer » Reports & Discoverer » Printing based on the count of records / running total (merged)
Printing based on the count of records / running total (merged) [message #234620] Wed, 02 May 2007 13:06 Go to next message
pravin9
Messages: 42
Registered: May 2007
Member
Hi
I have a problem with report i want to display data in the first page of report if it contains only 5 records
if it contains more than 5 records i need to leave the first page blank and start displaying from the second page
is there a way i could acheive this

thanks for ur time in advance
to display data in a report based on the number of records [message #234713 is a reply to message #234620] Thu, 03 May 2007 00:42 Go to previous messageGo to next message
pravin9
Messages: 42
Registered: May 2007
Member
Hi,
1. i would like to display data on the number of records if i have 5 records or less i need to display it in the first page otherwise it should display from second page and so on

2.how do i display running total for each page in report

could u people give me a little detailed view of these

thanx for ur time in advance
Re: to display data in a report based on the number of records [message #234725 is a reply to message #234713] Thu, 03 May 2007 00:57 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It depends on your client application and Oracle version.

Regards
Michel
Re: to insert records based on the count of records in reports [message #234727 is a reply to message #234620] Thu, 03 May 2007 00:58 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Same answer as in your other post.
http://www.orafaq.com/forum/t/81027/102589/
Don't multipost, above all in the same forum!

Regards
Michel
Re: to insert records based on the count of records in reports [message #234730 is a reply to message #234727] Thu, 03 May 2007 01:03 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
And please take the time to determine the right forum, instead of posting each and every question in the General forum.
Re: to insert records based on the count of records in reports (Merged) [message #234887 is a reply to message #234620] Thu, 03 May 2007 07:09 Go to previous messageGo to next message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
have you got the answer or still searching ...
Re: to insert records based on the count of records in reports (Merged) [message #234988 is a reply to message #234887] Thu, 03 May 2007 11:48 Go to previous messageGo to next message
pravin9
Messages: 42
Registered: May 2007
Member
Hi trivedi
Iam new to this site so i did not know which forum to post this question yet to get a answer
thanks for ur response
Running total in reports [message #235012 is a reply to message #234620] Thu, 03 May 2007 13:53 Go to previous messageGo to next message
pravin9
Messages: 42
Registered: May 2007
Member
Hi,
1.How do i display Running total in reports
2.I need to display data in the first page of report if it contains 5 records otherwise it should leave the first page blank and then display from the second page

Execuse me if i have reached the wrong forum for this question

Thanks for ur time in advance

Regards,
Re: Running total in reports [message #235203 is a reply to message #235012] Fri, 04 May 2007 05:50 Go to previous message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
to display running total it is ok . just take a summary column and count(no_of_records), display that summary column in the page .

for second question if your client really wants this type of report? then you must use some condition in before report trigger to check no of records ?

I am trying and as soon as I will get it I will send the solution you should also try.

Ashu
Previous Topic: Print Text on last page fix at bottom
Next Topic: automatic update reports if column added in database
Goto Forum:
  


Current Time: Wed Dec 07 22:35:01 CST 2016

Total time taken to generate the page: 0.06985 seconds