OraFAQ Forum: Reports & Discoverer » Maximum Record per page 1

Home » Developer & Programmer » Reports & Discoverer » Maximum Record per page 1

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Maximum Record per page 1 [message #272086]

Thu, 04 October 2007 00:23

aslme
Messages: 26
Registered: May 2006
Location: Pakistan

Junior Member

Dear i have report in which their is 2 queryes i want the result of both queryes on a single pages i attach an example report as well as a download link please check and advice me.

http://rapidshare.com/files/60137807/Example_Report_conn_scott.rdf.html

Thanks
Cheers

Attachment: Example Report conn scott.rdf
(Size: 64.00KB, Downloaded 1285 times)

Report message to a moderator

Re: Maximum Record per page 1 [message #272131 is a reply to message #272086]

Thu, 04 October 2007 01:56

Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

From the report output

I need Group wise Deptno and Summary means on a Singele Page I need Deptno 10 and Summary of Deptno 10 only as it is then on next page. Page 2 Deptno 20 and Summary of Deptno 20 and as on remember it must be on 2 queryes It's an example by which i have done my work thanks in Advance.

Please, ask someone to help you writing messages prior to posting them. Punctuation exists - use it! Here you've written several lines of text, but I have no idea what you are saying. Where's the end of a sentence? Where does the new one start? It is readable, but not understandable.

I ran your report - its output IS on a single page. I *guess* you'd like to display:
- department 10 employees and department 10 summary on the first page
- department 20 employees and department 20 summary on the second page
etc.

Is that your idea? If not, then what is it?

Let's assume my guess was correct. In that case
- create a data link between two 'deptno' columns (one in the 'G_DEPTNO' group and one in the 'G_DEPTNO1' group)
- use the Report Wizard to create a new layout
- open the 'R_G_DEPTNO' repeating frame's property inspector and set "Maximum Records per Page" to 1
- run the report

Report message to a moderator

Re: Maximum Record per page 1 [message #272401 is a reply to message #272131]

Thu, 04 October 2007 22:12

aslme
Messages: 26
Registered: May 2006
Location: Pakistan

Junior Member

Sorry for Inconvenient
And Thanks for Guidance
I want exactly you think and I try it but it can not work please can you give me a favor please do these changes your self in a report and reply it I am very great full to you and thanks again for taking intrust.

Thanks

Cheers

Report message to a moderator

Re: Maximum Record per page 1 [message #272430 is a reply to message #272401]

Fri, 05 October 2007 01:00

Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Sorry, won't do. I explained in details what has to be done; I tested it and it works correctly. Follow the guidelines and do it yourself.

Report message to a moderator

Re: Maximum Record per page 1 [message #273129 is a reply to message #272430]

Tue, 09 October 2007 02:56

aslme
Messages: 26
Registered: May 2006
Location: Pakistan

Junior Member

I do it through another way if you don't mind will you upload your file in which you say you can done.

Report message to a moderator

Re: Maximum Record per page 1 [message #273251 is a reply to message #273129]

Tue, 09 October 2007 14:10

Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I'm glad you solved your problem.

And no, I will not upload anything.

Report message to a moderator

Re: Maximum Record per page 1 [message #275116 is a reply to message #273251]

Thu, 18 October 2007 06:33

ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India

Senior Member

LF you are really good tutor.
BTW aslam have you able to solve the issue.

It is realy very simple just create the report with wizard if you are new to reports.

AT

Report message to a moderator

Previous Topic:	CHART OF ACCOUNTS HIERARCHY
Next Topic:	Data Delimited output issues with carriage returns?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 00:37:31 CDT 2024