Home » Developer & Programmer » Reports & Discoverer » Maximum Record per page 1
Maximum Record per page 1 [message #272086] Thu, 04 October 2007 00:23 Go to next message
aslme
Messages: 25
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
Re: Maximum Record per page 1 [message #272131 is a reply to message #272086] Thu, 04 October 2007 01:56 Go to previous messageGo to next message
Littlefoot
Messages: 20897
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
Re: Maximum Record per page 1 [message #272401 is a reply to message #272131] Thu, 04 October 2007 22:12 Go to previous messageGo to next message
aslme
Messages: 25
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
Re: Maximum Record per page 1 [message #272430 is a reply to message #272401] Fri, 05 October 2007 01:00 Go to previous messageGo to next message
Littlefoot
Messages: 20897
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.
Re: Maximum Record per page 1 [message #273129 is a reply to message #272430] Tue, 09 October 2007 02:56 Go to previous messageGo to next message
aslme
Messages: 25
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.
Re: Maximum Record per page 1 [message #273251 is a reply to message #273129] Tue, 09 October 2007 14:10 Go to previous messageGo to next message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'm glad you solved your problem.

And no, I will not upload anything.
Re: Maximum Record per page 1 [message #275116 is a reply to message #273251] Thu, 18 October 2007 06:33 Go to previous message
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
Previous Topic: CHART OF ACCOUNTS HIERARCHY
Next Topic: Data Delimited output issues with carriage returns?
Goto Forum:
  


Current Time: Wed Dec 07 10:56:08 CST 2016

Total time taken to generate the page: 0.05414 seconds