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

Report message to a moderator

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

Report message to a moderator

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: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It depends on your client application and Oracle version.

Regards
Michel

Report message to a moderator

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: 68665
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

Report message to a moderator

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: 7901
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.

Report message to a moderator

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 ...

Report message to a moderator

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

Report message to a moderator

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,

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jul 04 12:01:44 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.