Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Page protect (?) in an SQL report (Apex 3.2.1, Oracle 10g XE, MS Windows XP SP3, IE7)
Page protect (?) in an SQL report [message #468499] Fri, 30 July 2010 05:19 Go to next message
Littlefoot
Messages: 21564
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'm looking for a feature similar to "Page protect" frame property in Reports Builder. Reports help
The Page Protect property specifies whether to try to keep the entire object and its contents on the same logical page.

What does it mean? Here's an example: There's an SQL report that breaks on first column (a year). It looks like this:
[This is page 1 -------------------------]

2006
Sponsorship  1535         101.38
Member       4620         100.69
Total        6155         

2007
Sponsorship  1200         109.95
Other        1250         112.38


[This is page 2 -------------------------]
2007
Member       5000         106.91
Total        7450          

2008
Sponsorship  1200         98.79
Member       5000        104.53
Total        6200       
...

Note how 2007's data is "broken" in two; some lines are on the first page, while the others are on the second page.

"Page protect" would result in a following output:
[This is page 1 -------------------------]

2006
Sponsorship  1535         101.38
Member       4620         100.69
Total        6155         


[This is page 2 -------------------------]
2007
Sponsorship  1200         109.95
Other        1250         112.38
Member       5000         106.91
Total        7450          

2008
Sponsorship  1200         98.79
Member       5000        104.53
Total        6200 

In other words, all data that belongs to a certain "break column" (year, in this case), should be kept together.

"Number of rows" region properties I tried to use aren't good enough, because there are different numbers of lines for every year; if it was fixed, no problem - but it is not.

Any idea?
Re: Page protect (?) in an SQL report [message #468540 is a reply to message #468499] Fri, 30 July 2010 10:58 Go to previous messageGo to next message
dr.s.raghunathan
Messages: 540
Registered: February 2008
Senior Member
break in year content column would have help
Re: Page protect (?) in an SQL report [message #468568 is a reply to message #468540] Fri, 30 July 2010 12:49 Go to previous messageGo to next message
Littlefoot
Messages: 21564
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Excuse me, but I don't understand what that means.
Re: Page protect (?) in an SQL report [message #470911 is a reply to message #468568] Wed, 11 August 2010 06:48 Go to previous messageGo to next message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
I think, following is what you are searching for.
Actually dr.s.raghunathan has given the answer. I am just justifying.

Go to Page Edit > Report > Report Attributes > Break Formatting > Breaks.

Select first column in that option.
Here in your case, Year will be the first column of the report query.

regards,
Delna
Re: Page protect (?) in an SQL report [message #470929 is a reply to message #470911] Wed, 11 August 2010 07:47 Go to previous messageGo to next message
Littlefoot
Messages: 21564
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Oh, THAT break! Yes, I'm aware of it. But, unfortunately, it solves nothing in my case. I want that ALL records that belong to a certain "break column" (a year, for example) are placed on the same page. I'll try to illustrate it once again - watch "in parallel". First column are line numbers - imagine that a paper has only 8 lines.

On the left side, you'll see that year 2007's data spans two pages (page 1 and page 2) - I don't want that!

On the right side, you'll see that year 2007 is on the second page. As there's no room for year 2008, it goes to page #3. But, page 2009 has only 3 records and it fits to page #3 so it shares the page with year 2008 (i.e. there's no need to move year 2009 to page #4).

Line Wrong (i.e. no "page protect"       Right (i.e. "page protect")
==== ================================    ================================
1    2006                                2006
2    Sponsorship  1535         101.38    Sponsorship  1535         101.38
3    Member       4620         100.69    Member       4620         100.69
4    Total        6155                   Total        6155
5
6    2007
7    Sponsorship  1200         109.95
8    Other        1250         112.38
     ---- page break ----------------    ---- page break -----------------
1    2007                                2007
2    Member       5000         106.91    Sponsorship  1200         109.95
3    Total        7450                   Other        1250         112.38
4                                        Member       5000         106.91 
5    2008                                Total        7450
6    Sponsorship  1200          98.79
7    Member       5000         104.53    
8    Total        6200      
     ---- page break ----------------    ---- page break -----------------
1    2009                                2008
2    Member       1000         105.00    Sponsorship  1200          98.79
3    Total        1000                   Member       5000         104.53 
4                                        Total        6200
5
6                                        2009
7                                        Member       1000         105.00
8                                        Total        1000
     ---- page break ----------------    ---- page break -----------------
Re: Page protect (?) in an SQL report [message #470938 is a reply to message #470929] Wed, 11 August 2010 09:27 Go to previous message
dr.s.raghunathan
Messages: 540
Registered: February 2008
Senior Member
i understand...
I saw the solution on using BIP. Also heard jasper report helps to derive that sort or output layout. If some one helps and explaining how they did it, it will be helpful to me on learning sake. However, in page 3 2008 alone can come first on left side column and it should follow 2009 on right column. Is it not?

yours
dr.s.raghunathan
Previous Topic: Hide port number
Next Topic: Need Help
Goto Forum:
  


Current Time: Thu Jun 04 19:02:48 CDT 2020