| Page protect (?) in an SQL report [message #468499] |
Fri, 30 July 2010 05:19  |
 |
Littlefoot
Messages: 21823
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 helpThe 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 #470929 is a reply to message #470911] |
Wed, 11 August 2010 07:47  |
|
Littlefoot
Messages: 21823
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 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
