| Page Break Qtn... [message #480923] |
Thu, 28 October 2010 02:37  |
Maverick27
Messages: 84
Registered: October 2008
|
Member |
|
|
Can someody pls. tell me what i need to do so that the Group shown by the RED arrow spills over to next page ?
The image shows that my report is grouped into 4 Levels.
Do i simple create a Page Break on Last Group ?
Thanks - Mave
|
|
|
|
|
|
|
|
|
|
| Re: Page Break Qtn... [message #481021 is a reply to message #480941] |
Fri, 29 October 2010 06:07  |
Maverick27
Messages: 84
Registered: October 2008
|
Member |
|
|
Hi Littlefoot...thanks for taking an interest in my issue...
My report is made of 3 GROUPS...On the 2nd Group, i put a PAGE BREAK (After(, but it DID'NT create the Page Break..
Last pic. of attached image is a snapshot of the Report.
Unfortunately, no page break was created...
Thanks - Mave
|
|
|
|
|
|
|
|
|
|
| Re: Page Break Qtn... [message #481078 is a reply to message #481076] |
Sat, 30 October 2010 03:39 |
Maverick27
Messages: 84
Registered: October 2008
|
Member |
|
|
I tend to think so b'coz i'm getting 4 rows for ALL other pages...it's only this particular page that is showing more than 4 !
I'll do some trial & error...
|
|
|
|
|
|
|
|
| Re: Page Break Qtn... [message #481188 is a reply to message #481138] |
Mon, 01 November 2010 11:16 |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
I don't know how to do that by setting "something" in Reports Builder.
However, you might try to do that in the query itself. Something like this example: first, all records from the EMP table (broke on DEPTNO, ordered by DEPTNO, ENAME). Let's suppose that we want to display only 2 records for DEPTNO = 10, and 4 records for other departments; those records are marked with an asterisk:SQL> select deptno, ename, job, sal
2 from emp
3 order by deptno, ename;
DEPTNO ENAME JOB SAL
---------- ---------- --------- ----------
10 CLARK MANAGER 2450 *
KING PRESIDENT 5000 *
MILLER CLERK 1300
20 ADAMS CLERK 1100 *
FORD ANALYST 3000 *
JONES MANAGER 2975 *
SCOTT ANALYST 3000 *
SMITH CLERK 800
30 ALLEN SALESMAN 1600 *
BLAKE MANAGER 2850 *
JAMES CLERK 950 *
MARTIN SALESMAN 1250 *
TURNER SALESMAN 1500
WARD SALESMAN 1250
Now, a query (might be prettier, but you'll get the idea):SQL> select deptno, ename, job, sal
2 from (select row_number() over (partition by deptno order by deptno, ename) rn,
3 deptno, ename, job, sal
4 from emp
5 order by deptno, ename
6 )
7 where rn <= decode(deptno, 10, 2, 4);
DEPTNO ENAME JOB SAL
---------- ---------- --------- ----------
10 CLARK MANAGER 2450
KING PRESIDENT 5000
20 ADAMS CLERK 1100
FORD ANALYST 3000
JONES MANAGER 2975
SCOTT ANALYST 3000
30 ALLEN SALESMAN 1600
BLAKE MANAGER 2850
JAMES CLERK 950
MARTIN SALESMAN 1250
Got it?
|
|
|
|
| Re: Page Break Qtn... [message #481233 is a reply to message #481188] |
Tue, 02 November 2010 02:00 |
Maverick27
Messages: 84
Registered: October 2008
|
Member |
|
|
Thanks - i'll try it out...
In the Frame property where i have set MAX Rec. to 4, do i leave it to what it is ?
Will the result of the SQL statement supercede the Frame Property ?
MAve
|
|
|
|
|
|
| Re: Page Break Qtn... [message #481267 is a reply to message #481238] |
Tue, 02 November 2010 04:37 |
Maverick27
Messages: 84
Registered: October 2008
|
Member |
|
|
Thanks Littlefoot....your query does'nt actually meet my needs..
On Report level, i want to display 2 images for a specific Grp & 4 images for rest...
Whereas your query is discarding some records...
So, this can only be achieved with a code in the Report Trigger..
Mave
|
|
|
|
| Re: Page Break Qtn... [message #481271 is a reply to message #481267] |
Tue, 02 November 2010 04:44 |
cookiemonster
Messages: 13960
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
So to be clear:
The group contains multiple items, 1 of which is an image.
You want the group to retrieve as many records as match the criteria.
However the image item should be supressed after the first 2 records in the group.
|
|
|
|
| Re: Page Break Qtn... [message #481295 is a reply to message #481271] |
Tue, 02 November 2010 06:13 |
Maverick27
Messages: 84
Registered: October 2008
|
Member |
|
|
Currently I have set MAX records of the frame to 4...so i will see 4 images per page. This is what i want...
But for a SPECIFIC group (Floor Lamps), i want to see ONLY 2...
Is then possibe to write a trriger code..
IF GRP = 'Floor Lamps' THEN MAX REC = 2 ELSE
MAX REC = 4
END IF
|
|
|
|
| Re: Page Break Qtn... [message #481297 is a reply to message #481295] |
Tue, 02 November 2010 06:24 |
cookiemonster
Messages: 13960
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
|
Different groups need different frames. So unless your definition of group differs from oracle reports I'm not sure why you think you need a trigger for this. Just hard code that value in that groups frame.
|
|
|
|
|
|
|
|
| Re: Page Break Qtn... [message #481410 is a reply to message #481409] |
Wed, 03 November 2010 04:54 |
cookiemonster
Messages: 13960
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
|
Unless you split floor lamps out into a seperate query - and thus a seperate group (in the oracle reports sense of group) you will not be able to do this. There is no way as far as we can tell of changing the max records property programatically. So if you really want this you're going to have to have floor lamps in a seperate frame - which means seperate group and thus seperate query.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
