Page Break at End throws unwanted additional blank page in PDF

Hi,
Originally posted as "Extra Page Break thrown in Export to PDF" - however I
thought this might be misinterpreted as a page size issue.
We have a report which has a group. The "Page Break at End" option is
checked for the group. The report renders correctly in the report manager
with totals immediately under the last group.
Unfortunately, when exporting to PDF, an additional blank page is added.
Can this be avoided?
Note, the report has three tables which are directly on top of each other -
the tables are all sitting within a rectangle.
many thanks
MattJust a thought - Could I edit the RDL file directly and put a condition in
the PageBreak at End element - is this an possibility?
"Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
news:ex8fbmIGFHA.3732@.tk2msftngp13.phx.gbl...
> Hi,
> Originally posted as "Extra Page Break thrown in Export to PDF" - however
I
> thought this might be misinterpreted as a page size issue.
> We have a report which has a group. The "Page Break at End" option is
> checked for the group. The report renders correctly in the report manager
> with totals immediately under the last group.
> Unfortunately, when exporting to PDF, an additional blank page is added.
> Can this be avoided?
> Note, the report has three tables which are directly on top of each
other -
> the tables are all sitting within a rectangle.
> many thanks
> Matt
>|||In answer to editing the RDL - unfortunately, no.
"Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
news:eWdstsIGFHA.2824@.tk2msftngp13.phx.gbl...
> Just a thought - Could I edit the RDL file directly and put a condition in
> the PageBreak at End element - is this an possibility?
>
> "Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
> news:ex8fbmIGFHA.3732@.tk2msftngp13.phx.gbl...
> > Hi,
> >
> > Originally posted as "Extra Page Break thrown in Export to PDF" -
however
> I
> > thought this might be misinterpreted as a page size issue.
> >
> > We have a report which has a group. The "Page Break at End" option is
> > checked for the group. The report renders correctly in the report
manager
> > with totals immediately under the last group.
> >
> > Unfortunately, when exporting to PDF, an additional blank page is added.
> > Can this be avoided?
> >
> > Note, the report has three tables which are directly on top of each
> other -
> > the tables are all sitting within a rectangle.
> >
> > many thanks
> >
> > Matt
> >
> >
>|||Actually, the additional page only seems to occur when the table has rows
after the last group - in my case, it's a grand total field
"Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
news:eWdstsIGFHA.2824@.tk2msftngp13.phx.gbl...
> Just a thought - Could I edit the RDL file directly and put a condition in
> the PageBreak at End element - is this an possibility?
>
> "Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
> news:ex8fbmIGFHA.3732@.tk2msftngp13.phx.gbl...
> > Hi,
> >
> > Originally posted as "Extra Page Break thrown in Export to PDF" -
however
> I
> > thought this might be misinterpreted as a page size issue.
> >
> > We have a report which has a group. The "Page Break at End" option is
> > checked for the group. The report renders correctly in the report
manager
> > with totals immediately under the last group.
> >
> > Unfortunately, when exporting to PDF, an additional blank page is added.
> > Can this be avoided?
> >
> > Note, the report has three tables which are directly on top of each
> other -
> > the tables are all sitting within a rectangle.
> >
> > many thanks
> >
> > Matt
> >
> >
>|||I believe there are some issues with page breaks while exporting to PDFs..
Hopefully some of these kinds of things will be fixed as time goes forward,
I have yet to be able to eliminate all of the extra pages as well...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
news:ex8fbmIGFHA.3732@.tk2msftngp13.phx.gbl...
> Hi,
> Originally posted as "Extra Page Break thrown in Export to PDF" - however
> I
> thought this might be misinterpreted as a page size issue.
> We have a report which has a group. The "Page Break at End" option is
> checked for the group. The report renders correctly in the report manager
> with totals immediately under the last group.
> Unfortunately, when exporting to PDF, an additional blank page is added.
> Can this be avoided?
> Note, the report has three tables which are directly on top of each
> other -
> the tables are all sitting within a rectangle.
> many thanks
> Matt
>|||I have found a work around - although it's a bit clunky.
The issue seems to be where you have something appearing after the last
group. If there is nothing after the last group, the report exports to PDF
correctly. But because I want grand totals I have not been able to simply
put a summation in the table footer.
Firstly, I am using a stored procedure as my report data source.
I added two additional fields to my stored procedure result set a) a grand
total field and b) a last group flag.
I then put the grand total field into a footer row of the outermost group
and set the hidden property to an expression including the Last Group flag
which evaluates to false when at the last group.
This is not a particularly complex thing to work around - but was quite
painful as I resist having to use unintuitive solutions such as this because
they make maintenance more difficult :)
Note: I would have used pagenumbering to determine the last page but
unfortunately, the Global values for Pagenumber and TotalPages are not
accessible within the body of the report.
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:OLxJc%23NGFHA.2932@.TK2MSFTNGP15.phx.gbl...
> I believe there are some issues with page breaks while exporting to PDFs..
> Hopefully some of these kinds of things will be fixed as time goes
forward,
> I have yet to be able to eliminate all of the extra pages as well...
>
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
> news:ex8fbmIGFHA.3732@.tk2msftngp13.phx.gbl...
> > Hi,
> >
> > Originally posted as "Extra Page Break thrown in Export to PDF" -
however
> > I
> > thought this might be misinterpreted as a page size issue.
> >
> > We have a report which has a group. The "Page Break at End" option is
> > checked for the group. The report renders correctly in the report
manager
> > with totals immediately under the last group.
> >
> > Unfortunately, when exporting to PDF, an additional blank page is added.
> > Can this be avoided?
> >
> > Note, the report has three tables which are directly on top of each
> > other -
> > the tables are all sitting within a rectangle.
> >
> > many thanks
> >
> > Matt
> >
> >
>sql

Page break and subreports

I have a main report that calls subreports. When a subreport has enough data such that it will not fit into the remaining area of the current page the renderer inserts a page break leaving alot of ugly white space. Is there any way to sop this behaviour? This seems like a very basic thing.

not sure is this is the exact reason, but are u using 8.5 * 11 layout for subreport also, if yes u need to decrease it as per your req. because a ful page cannot be accomodated in a page and so ssrs inserts a page break

Priyank

|||

Priyank,

All of the subreports and the main report for that matter are 8.5 x 11 but what would I change them to? Let me give you an example of my problem. Lets say the first sub report takes up three inches of the first page when rendered. If the second sub report takes up less than the remaining space (5.5 inches) it prints on the same page otherwise it page breaks and starts on a new page. Since the subreports can vary in rendered length depending on data I have no idea what their size will be.

Another thread stated that subreports operate under and assumed KeepTogether. While this may explain what is happening it does not resolve the issue.

Page break and subreport

Hello,
Using SSRS 2005, SP1.
I've got a report which contains a subreport.
This subreport is based on a list and can display one or more records.
When i put the subreport in its parent report, i give it an height
which is equal to the height necessary for displaying one record.
When i run my report, if the subreport display one record, there's no
problem.
But if my subreport display more than one record, and then needs to
extend its height, the report works properly but i've got a blank page
after.
As i can't know how much records my subreport has to display, i don't
see how to resolve this problem of blank page.
Is there anyone who've got idea?
Thanks in advance.
Jerome
I hope my english is enough efficient to explain my problem!Jerome,
You're not alone! I am also having this problem, but I'm getting 2
blank pages after my subreport. I ran the subreport by itself and get
no blank pages. I also ran the parent report by itself and get no
blank pages. I only get the blank pages after the subreport when I put
the subreport inside the parent report.
I hope you get feedback because I need it too!!
jennifer
Jerome FAURE wrote:
> Hello,
> Using SSRS 2005, SP1.
> I've got a report which contains a subreport.
> This subreport is based on a list and can display one or more records.
> When i put the subreport in its parent report, i give it an height
> which is equal to the height necessary for displaying one record.
> When i run my report, if the subreport display one record, there's no
> problem.
> But if my subreport display more than one record, and then needs to
> extend its height, the report works properly but i've got a blank page
> after.
> As i can't know how much records my subreport has to display, i don't
> see how to resolve this problem of blank page.
> Is there anyone who've got idea?
> Thanks in advance.
> Jerome
> I hope my english is enough efficient to explain my problem!

Page break and on last record problem

Hello,

In crystal these are available-

1- Conditional Page break 'OnLastRecord'- I have few groups and if I put page break it breaks on each group even if that group has 2 rows but I want a break at the end of the page. So is there conditional page break in SSRS 2005.

2- I am also having problem with controlling Number of lines in a page, few pages are very long as compared to others, though when export to pdf it gives according to the page size set, but not while viewing, is there any work around to this in SSRS 2005.

I will appreciate any suggestion or comment.

regards

1 - this might help you get started http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1682115&SiteID=1 -- if not, what have you tried so far?

2 - when you say "few pages are very long as compared to others" you have to specify: what output format are you talking about? PDF uses printable page size, HTML uses interactive page size, Excel is different because it's allowed to have as many rows as are within an explicit page break set by your code.

I have tried to define "explicit" and "implicit" page breaks separately; see the grey shaded note close to the beginning of this post: http://spacefold.com/lisa/post/Reset-On-Group-(Page-X-of-XX-in-a-group%2c-within-a-total-Y-of-YY-for-the-report)%2c-SQL-Reporting-Services-Style-.aspx. You will also find something similar referenced in the thread to which I linked above.

The difference between behavior of "implicit" page breaks for different formats isn't a bug requiring a "workaround"; it's a feature <s>. Different formats do have different requirements and that's a fact of output life.

So if you want page breaks based on some condition which is external to formatting requirements for a given output format, IOW consistent across output formats, you need to define what that condition is explicitly.

>L<

|||

Thanks for the reply.

I think I am still having problem.

Here is what I am doing-

I have three groups - 1-Customer, 2-Department,3-Priority and the details.

1- need to break if customer = Inactive

2- need to break if Department = Closed

3- need to break Priority = normal

So I made first group - Group1(Customer) then inside that I made another groupd Group1A(for customer) without any header and footer and changed the Group expresseion with a boolean parameter 'PageBreak' as is mentioned in the article and similarly did the for other groups but still no luck and it is breaking with the Group. Please let me know if I am following this correctly.

I am hiding the boolean parameter as I don't want to prompt it.

thanks

|||

I think you are mixing up a couple of things. The idea of using a parameter had nothing to do with data-based conditional page breaks <s>.

That example I pointed you to had a condition that came in from the outside, so it was a parameter. Your condition has to do with your data, and I didn't mean you to emulate the parameter part . I'm sorry about this...

I wanted you to see the idea of the nested groups in which one group handles your real group break and the other one is responsible for the conditional page break, by grouping on what may be a completely unrelated expression. OK?

I don't have your exact data set but I have created an example with a completely arbitrary page break that is caused by a data condition, instead of the external (parameterized) condition in the other example I pointed to. I will tell you what I did and maybe this will be a better example for you. It isn't going to be *exactly* what you need. But it should show you what you have to do, depending on the effect you're after.

1. I have a table of orders for customers with locale data. I did a query out of this data that looks like this:

Code Snippet

SELECT Customer, Locale FROM OrderHeader ORDER BY Customer

2. In this dataset, let's say I wanted to group by the customer's last name. I only want page breaks if the Locale starts with "N". (I told you it was totally arbitrary! )

3. I set a group on a "normal" group break expression -- in this case

Code Snippet

=Fields!Customer.Value

I set this group to repeat headers since that happened to be where the headers were.

4. I create an outer group on the following, non-normal expression:

Code Snippet

=IIF(LEFT(Fields!Locale.Value,1) ="N",
Fields!Customer.Value,
False)

... and this is the group that has the page break.

Does this help you understand better? The point is, the outer group is going to force a page break when you provide the group break expression with the value that is actually changing, which I've done in the first argument to IIF() here. In the second argument, the value False isn't changing, and the outer group doesn't break.

>L<

|||

Thanks a lot, I thing I got it.

Is there anything like 'OnLastRecord' in SSRS.

and is there a way to get a certain number of rows in a page.

thanks

Page break and grouping question

Hi,
I have to make a report that shows 2 tables one above the other.
The both tables have grouping values, and I want in each page to
display the both tables so I'm making a page break in each group/
table.
The problem is that the both tables goes to separate pages...what I
want is a full page break after the second table is filled up
It looks simple, but I don't know how!
Something like this
---
table 1
record 1, record 2
table 2
record 1, record 2
---
->Break in the end
->Next page
---
table 1
record 1, record 2
table 2
record 1, record 2
---
Thanks for your help,Sorry, I forgot to say that the two tables have different datasets.
Thanks for your help.

Page break after X items

Is it possible to force a page break after a specified number of items in a table?
For instance, I have a name badge report but I'm running into a problem where some badges are sliced down the middle at page breaks when exporting to pdf or tiff. If I could force a page break after every 2nd or 3rd badge it would alleviate that problem.

Thanks in advance.Figured it out. I added a group on Code.GetCount(RowNumber(Nothing)) with a page break at the end and added this function:

public shared function GetCount(CurrentCount As Integer) As Integer
If CurrentCount Mod 2 = 0 Then
GetCount = CurrentCount-1
Else
GetCount = CurrentCount
End If
end function

|||

Hello Nblankton

that was a very good idea, I did try to use it but for some reason it only works with 2 records.

I tried to change it with Mod 4 (I thought that would break after 4 records but that is not the case, I page break after the 1,2 and 4th record).

I'm not sure if I'm missing something or it is a bug.

Any Idea?

Thank you

MQ

|||

You'd also need to also alter the CurrentCode-1 line to subtract the appropriate number so that for all four that returned number is the same.

Something like CurrentCode-(CurrentCode Mod 4)+1.

I worked out a different method later that I think is a little clearer, though. This groups by 3's:

public shared function GetCount(CurrentCount As Integer) As Integer
GetCount = (CurrentCount+1)/3
end function

|||

Hi Nblankton

thank you for the response, after I wrote the note I searched the forum and found this

"=Ceiling(RowNumber(Nothing)/4)" you can put any number (2,5,20) it works, without having to add any code.

Thank you for your help. adding a group to control the amount of record per page is a great idea.

MQ

|||hi, I hope someone can help me!
I don't understand where I must place "=Ceiling(RowNumber(Nothing)/4)"

I added a new group (I selected table, right-click Proprieties, groups and add)
and I've write "=Ceiling(RowNumber(Nothing)/4)" as expression, but when I tried to execute , an error rose!
A scope problem

did I wrong the place to write the expression?

Thanks in advance
sql

Page break after X items

Is it possible to force a page break after a specified number of items in a table?
For instance, I have a name badge report but I'm running into a problem where some badges are sliced down the middle at page breaks when exporting to pdf or tiff. If I could force a page break after every 2nd or 3rd badge it would alleviate that problem.

Thanks in advance.Figured it out. I added a group on Code.GetCount(RowNumber(Nothing)) with a page break at the end and added this function:

public shared function GetCount(CurrentCount As Integer) As Integer
If CurrentCount Mod 2 = 0 Then
GetCount = CurrentCount-1
Else
GetCount = CurrentCount
End If
end function

|||

Hello Nblankton

that was a very good idea, I did try to use it but for some reason it only works with 2 records.

I tried to change it with Mod 4 (I thought that would break after 4 records but that is not the case, I page break after the 1,2 and 4th record).

I'm not sure if I'm missing something or it is a bug.

Any Idea?

Thank you

MQ

|||

You'd also need to also alter the CurrentCode-1 line to subtract the appropriate number so that for all four that returned number is the same.

Something like CurrentCode-(CurrentCode Mod 4)+1.

I worked out a different method later that I think is a little clearer, though. This groups by 3's:

public shared function GetCount(CurrentCount As Integer) As Integer
GetCount = (CurrentCount+1)/3
end function

|||

Hi Nblankton

thank you for the response, after I wrote the note I searched the forum and found this

"=Ceiling(RowNumber(Nothing)/4)" you can put any number (2,5,20) it works, without having to add any code.

Thank you for your help. adding a group to control the amount of record per page is a great idea.

MQ

|||hi, I hope someone can help me!
I don't understand where I must place "=Ceiling(RowNumber(Nothing)/4)"

I added a new group (I selected table, right-click Proprieties, groups and add)
and I've write "=Ceiling(RowNumber(Nothing)/4)" as expression, but when I tried to execute , an error rose!
A scope problem

did I wrong the place to write the expression?

Thanks in advance

Page break after X items

Is it possible to force a page break after a specified number of items in a table?
For instance, I have a name badge report but I'm running into a problem where some badges are sliced down the middle at page breaks when exporting to pdf or tiff. If I could force a page break after every 2nd or 3rd badge it would alleviate that problem.

Thanks in advance.Figured it out. I added a group on Code.GetCount(RowNumber(Nothing)) with a page break at the end and added this function:

public shared function GetCount(CurrentCount As Integer) As Integer
If CurrentCount Mod 2 = 0 Then
GetCount = CurrentCount-1
Else
GetCount = CurrentCount
End If
end function

|||

Hello Nblankton

that was a very good idea, I did try to use it but for some reason it only works with 2 records.

I tried to change it with Mod 4 (I thought that would break after 4 records but that is not the case, I page break after the 1,2 and 4th record).

I'm not sure if I'm missing something or it is a bug.

Any Idea?

Thank you

MQ

|||

You'd also need to also alter the CurrentCode-1 line to subtract the appropriate number so that for all four that returned number is the same.

Something like CurrentCode-(CurrentCode Mod 4)+1.

I worked out a different method later that I think is a little clearer, though. This groups by 3's:

public shared function GetCount(CurrentCount As Integer) As Integer
GetCount = (CurrentCount+1)/3
end function

|||

Hi Nblankton

thank you for the response, after I wrote the note I searched the forum and found this

"=Ceiling(RowNumber(Nothing)/4)" you can put any number (2,5,20) it works, without having to add any code.

Thank you for your help. adding a group to control the amount of record per page is a great idea.

MQ

|||hi, I hope someone can help me!
I don't understand where I must place "=Ceiling(RowNumber(Nothing)/4)"

I added a new group (I selected table, right-click Proprieties, groups and add)
and I've write "=Ceiling(RowNumber(Nothing)/4)" as expression, but when I tried to execute , an error rose!
A scope problem

did I wrong the place to write the expression?

Thanks in advance

Page Break after sub report - Not by design

All,

I have a report for a Quote print that has 1 table with 1 group in it by Quote #. The detail level is showing the line items on the quote and a second detail line for a sub report to show any notes. If the quote has 1 line on it, I am always getting a page break after the sub report even if it doesn't display anything.

The report shows the following:

Note each of these will contain a rectangle that the text boxes are displayed in unless it is a sub-report then no rectange.

Group header 1 - Address information

Group header 1 - contains a sub report for some notes

Group header 1 - Opening paragraph

Group header 1 - Blank line

Group header 1 - contains the line headings

Detail - contains the line details

Detail - contains the sub report for line notes

Detail - blank line for spacing

Group footer 1 - hidden based on expression

Group footer 1 - hidden based on expression ** One of these 2 lines will print based on the expression

Group footer 1 - sub report for more notes

Group footer 1 - Closing paragraph

Group footer 1 - Signature area

Group footer 1 - sub report for last page of terms / scope notes. NOTE: This sub report also contains a table and the table has a page break before so that I can get these on another page.

So, after # 8 above there is a page break. The remaining footers before # 14 easily fit on the rest of the page. The group 1 also has a page break at the end so it breaks between quotes. I have tried to insert a page break on the rectangle for # 13 and remove the page break on the sub report in # 14 but although everything fits it doesn't page break before the sub report.

It looks like it always page breaks after the last page in the sub report.

Any ideas on how to get around this?

Thanks in advance,

Sherry

Try this:
1.- In the sub report (on every List or Rectangle you have):
1.1.- Right click, Properties.
1.2.- uncheck "Insert a page break after this list".
1.3.- Click on "Edit details group"
1.4.- uncheck "Page break at end".|||

Thanks for the feedback. I had tried that and then it wouldn't page break.

I did resolve it although I feel the original way should have worked.

I created another Group 1 for the same grouping clause (Quote #). This pushed my original grouping to Group 2. I then put a page break after Group #2. I only had a group footer for Group # 1 with the sub report in it. I had to take the sub report page break before off.

Thanks again,

Sherry

page break after list not working

Has anyone experienced a problem with page breaks after list's?
I have a list and i have selected for a page break after list but it does
not appear to be working?
How can I force a page break for each row process from the dataset?Dave,
Not sure if this will help but I think when viewing as html, the page break
is not shown, but should work in pdf format or print preview.
cheers,
Batty.
"dave" wrote:
> Has anyone experienced a problem with page breaks after list's?
> I have a list and i have selected for a page break after list but it does
> not appear to be working?
> How can I force a page break for each row process from the dataset?|||I resolved my problem by ensuring that the width of my lists and subreports
were clearly smaller than the page i was trying to print on. When you have a
subreport for example that has a width wider than the page, very strange
things will happen.
Hope this helps.

Page Break after a value in one of the report groups

There are 3 groups in my reportâ' grp1, grp2 and grp3, with grp1 at the top,
grp2 in the middle and grp3 at the bottom. I need to insert a page break when
the value of grp1 record becomes â'abcâ'. Is this possible? If so, I will
really appreciate if someone can let me know how.
Thanks in advance,
SauravDid you ever find out how to do this? I need a page break in a report just
like you are descibing.
Thanks
"sajmera" wrote:
> There are 3 groups in my reportâ' grp1, grp2 and grp3, with grp1 at the top,
> grp2 in the middle and grp3 at the bottom. I need to insert a page break when
> the value of grp1 record becomes â'abcâ'. Is this possible? If so, I will
> really appreciate if someone can let me know how.
> Thanks in advance,
> Saurav
>sql

Page break after a group ??

Hi all
In my report, a page break is getting addred for each group of records. Thus
if a group has only 3 lines of data , RS adds a page break and the next
grouping starts on a new page. Thereby making the report span in more pages
thatn expected.
I've checked the settings in the "edit group" window as well as on the table
properties but can not find anything that should cause these page breaks.
Any pointers are appreciated.
Thanks
KWould you verify that your RDL does not contain any PageBreakAtEnd tags.
What is the settings for the report and body heights?
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"k" <test@.msn.com> wrote in message
news:uluuhnghEHA.3964@.TK2MSFTNGP12.phx.gbl...
> Hi all
> In my report, a page break is getting addred for each group of records.
Thus
> if a group has only 3 lines of data , RS adds a page break and the next
> grouping starts on a new page. Thereby making the report span in more
pages
> thatn expected.
> I've checked the settings in the "edit group" window as well as on the
table
> properties but can not find anything that should cause these page breaks.
> Any pointers are appreciated.
> Thanks
> K
>|||here are my settings:
Report Height = 11"
Body height = 3.125"
The rdl conatined the "PageBreakAtend" tag in the first grouping tag. But
if I remove the tag completely, then at the end of the group, the page break
is not displayed but the Table header is displayed as if its a new page.
"Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> wrote in message
news:#2hN$wghEHA.384@.TK2MSFTNGP10.phx.gbl...
> Would you verify that your RDL does not contain any PageBreakAtEnd tags.
> What is the settings for the report and body heights?
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "k" <test@.msn.com> wrote in message
> news:uluuhnghEHA.3964@.TK2MSFTNGP12.phx.gbl...
> > Hi all
> >
> > In my report, a page break is getting addred for each group of records.
> Thus
> > if a group has only 3 lines of data , RS adds a page break and the next
> > grouping starts on a new page. Thereby making the report span in more
> pages
> > thatn expected.
> >
> > I've checked the settings in the "edit group" window as well as on the
> table
> > properties but can not find anything that should cause these page
breaks.
> >
> > Any pointers are appreciated.
> >
> > Thanks
> > K
> >
> >
>|||I am not quite sure what you in your RDL.
From the sounds of description, you did not understand why you were getting
a page break at the end of your group. You seemed to have resolved that by
the discovery of the PageBreakAtEnd tag in the first (outermost) group.
Do you have RepeatOnNewPage set for the table header or group header rows?
If you do then you will get a them repeated when a new page occurs.
If you want you can post your RDL I will take a look at it.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"k" <test@.msn.com> wrote in message
news:uyQYjQhhEHA.3476@.tk2msftngp13.phx.gbl...
> here are my settings:
> Report Height = 11"
> Body height = 3.125"
> The rdl conatined the "PageBreakAtend" tag in the first grouping tag. But
> if I remove the tag completely, then at the end of the group, the page
break
> is not displayed but the Table header is displayed as if its a new page.
>
> "Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> wrote in message
> news:#2hN$wghEHA.384@.TK2MSFTNGP10.phx.gbl...
> > Would you verify that your RDL does not contain any PageBreakAtEnd tags.
> > What is the settings for the report and body heights?
> > --
> > Bruce Johnson [MSFT]
> > Microsoft SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> >
> > "k" <test@.msn.com> wrote in message
> > news:uluuhnghEHA.3964@.TK2MSFTNGP12.phx.gbl...
> > > Hi all
> > >
> > > In my report, a page break is getting addred for each group of
records.
> > Thus
> > > if a group has only 3 lines of data , RS adds a page break and the
next
> > > grouping starts on a new page. Thereby making the report span in more
> > pages
> > > thatn expected.
> > >
> > > I've checked the settings in the "edit group" window as well as on the
> > table
> > > properties but can not find anything that should cause these page
> breaks.
> > >
> > > Any pointers are appreciated.
> > >
> > > Thanks
> > > K
> > >
> > >
> >
> >
>

page break after 10 rows

I have a report with 1 grouping level, and I want to display only 10 records
per page. How can I force this grouping in RS, can I use functions like
Rownumber, and how precisely does it work ?Yes, search this forum, it's been mentioned loads of times in here.
Effectively use the RowNumber function divided by 10 with the Ceiling
function.
--
Regards
Chris
joia wrote:
> I have a report with 1 grouping level, and I want to display only 10
> records per page. How can I force this grouping in RS, can I use
> functions like Rownumber, and how precisely does it work ?|||Hi, the easiest way to do it, as i found out, is using this function:
System.Math.Ceiling (RowNumber (Nothing)/10)
where 10 can be replaced by a report parameter.
Cheers, Johan
"Chris McGuigan" wrote:
> Yes, search this forum, it's been mentioned loads of times in here.
> Effectively use the RowNumber function divided by 10 with the Ceiling
> function.
> --
> Regards
> Chris
> joia wrote:
> > I have a report with 1 grouping level, and I want to display only 10
> > records per page. How can I force this grouping in RS, can I use
> > functions like Rownumber, and how precisely does it work ?
>|||I am new to reporting services. Can you show me how to use this function?
Thanks,
Anna
"joia" wrote:
> Hi, the easiest way to do it, as i found out, is using this function:
> System.Math.Ceiling (RowNumber (Nothing)/10)
> where 10 can be replaced by a report parameter.
> Cheers, Johan
> "Chris McGuigan" wrote:
> > Yes, search this forum, it's been mentioned loads of times in here.
> > Effectively use the RowNumber function divided by 10 with the Ceiling
> > function.
> > --
> > Regards
> > Chris
> >
> > joia wrote:
> >
> > > I have a report with 1 grouping level, and I want to display only 10
> > > records per page. How can I force this grouping in RS, can I use
> > > functions like Rownumber, and how precisely does it work ?
> >|||I figure out how to use this function now.
Thank you for sharing this function.
Anna :)
"Anna" wrote:
> I am new to reporting services. Can you show me how to use this function?
> Thanks,
> Anna
> "joia" wrote:
> > Hi, the easiest way to do it, as i found out, is using this function:
> > System.Math.Ceiling (RowNumber (Nothing)/10)
> >
> > where 10 can be replaced by a report parameter.
> >
> > Cheers, Johan
> >
> > "Chris McGuigan" wrote:
> >
> > > Yes, search this forum, it's been mentioned loads of times in here.
> > > Effectively use the RowNumber function divided by 10 with the Ceiling
> > > function.
> > > --
> > > Regards
> > > Chris
> > >
> > > joia wrote:
> > >
> > > > I have a report with 1 grouping level, and I want to display only 10
> > > > records per page. How can I force this grouping in RS, can I use
> > > > functions like Rownumber, and how precisely does it work ?
> > >

Page break & Service Pack !

Can anyone let me know how I check which Service Pack I do have in SQL
Server Reporting Services.
The second problem is in the reporting services I can see all the pages but
when I export in to PDF I can see proper page break, any idea what's the
problem.
ThanksOn Oct 12, 10:01 am, "Rogers" <naiss...@.hotmail.com> wrote:
> Can anyone let me know how I check which Service Pack I do have in SQL
> Server Reporting Services.
> The second problem is in the reporting services I can see all the pages but
> when I export in to PDF I can see proper page break, any idea what's the
> problem.
> Thanks
The first answer is as follows:
SELECT SERVERPROPERTY('productversion') AS SQLServerVersion,
SERVERPROPERTY ('productlevel') AS ServicePackLevel, SERVERPROPERTY
('edition') AS SQLServerEdition
To get version specs check this link.
http://support.microsoft.com/default.aspx?scid=kb;en-us;q321185
For the second question, if I'm understanding you correctly, the
interface has no page breaks by default. it all appears as a single
page. The PDF renderer breaks it up into pages.
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Is that version gave me SQL Server Reporting Services.
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1192244268.917148.26670@.e9g2000prf.googlegroups.com...
> On Oct 12, 10:01 am, "Rogers" <naiss...@.hotmail.com> wrote:
>> Can anyone let me know how I check which Service Pack I do have in SQL
>> Server Reporting Services.
>> The second problem is in the reporting services I can see all the pages
>> but
>> when I export in to PDF I can see proper page break, any idea what's the
>> problem.
>> Thanks
>
> The first answer is as follows:
> SELECT SERVERPROPERTY('productversion') AS SQLServerVersion,
> SERVERPROPERTY ('productlevel') AS ServicePackLevel, SERVERPROPERTY
> ('edition') AS SQLServerEdition
> To get version specs check this link.
> http://support.microsoft.com/default.aspx?scid=kb;en-us;q321185
> For the second question, if I'm understanding you correctly, the
> interface has no page breaks by default. it all appears as a single
> page. The PDF renderer breaks it up into pages.
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||On Oct 15, 8:46 am, "Rogers" <naiss...@.hotmail.com> wrote:
> Is that version gave me SQL Server Reporting Services.
> "EMartinez" <emartinez...@.gmail.com> wrote in message
> news:1192244268.917148.26670@.e9g2000prf.googlegroups.com...
> > On Oct 12, 10:01 am, "Rogers" <naiss...@.hotmail.com> wrote:
> >> Can anyone let me know how I check which Service Pack I do have in SQL
> >> Server Reporting Services.
> >> The second problem is in the reporting services I can see all the pages
> >> but
> >> when I export in to PDF I can see proper page break, any idea what's the
> >> problem.
> >> Thanks
> > The first answer is as follows:
> > SELECT SERVERPROPERTY('productversion') AS SQLServerVersion,
> > SERVERPROPERTY ('productlevel') AS ServicePackLevel, SERVERPROPERTY
> > ('edition') AS SQLServerEdition
> > To get version specs check this link.
> >http://support.microsoft.com/default.aspx?scid=kb;en-us;q321185
> > For the second question, if I'm understanding you correctly, the
> > interface has no page breaks by default. it all appears as a single
> > page. The PDF renderer breaks it up into pages.
> > Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
If I understand you correctly, generally speaking, the service pack
level of SQL Server is the same as for SSRS/Reporting Services that
you are running. Hope this clarifies it further.
Regards,
Enrique Martinez
Sr. Software Consultant

Page break

Hello,

I'm using SQL 2005 reporting services.

I habe table with two group.

Group A and Group B.

I set Page break at start and at end for each group in order each group will be in the new page.

it is not working and I'm getting group A and B in the same page

Do you have visibility properties set on the groups? If so, pagebreaks will be ignored.|||

I know this problem but no, I have no visibility set.

I currently change from table to list and it seemse to work fine but still..

I have group A header and footer and also for group B

My problem is that the first header from group A is in the same page with first header from Group B

Also last record in the Group B in the same page with the footer from group A.

Aslo I have a problem with document map. I create a document map from group A and group B and if the content is not in a differed pages the document map build successfuly but the link is not correct

Page break

Hi All,

I have created one report. When I click on view report information about different countries will be displayed.

By default, reporting services breaks pages of report on some criteria.

I want to break the pages of report on country basis.

For example: Australia: page should include only rows belonging to Australia.

Please teach me how to do this.

Regards

Abdul

Hi Abdul,

Have a read on my article below

http://www.koffeekoder.com/ArticleDetails.aspx?id=339

|||

Hi,

I hope you already have a group created in your report based on Country field. If yes you just need to select the table, right click properties, select groups tab, from the group list select the desired group in your case it will be country and click edit.

you are now on Grouping & Sorting properties dialog box. Just check Page break at end check box and that should resolve your issue.

Cheers,

...

Dont forget to click "mark as answered" on the post that helped you.

...

sql

page break

Hi,
I have a report with multiple pages.
I added a page break but then went to the table properties and unchecked the
page break checkbox.
However, when i run the report from my vb.net application I can see a page
break at the end of each page. How can I delete the page breaks?
Thanks.You can get page breaks from groups, lists, etc... Either search through
the RDL or check each one of the items to ensure your not asking for page
breaks somewhere else...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"collie" <collie@.discussions.microsoft.com> wrote in message
news:ABEEBB6A-A408-48C0-A528-F881D5815A65@.microsoft.com...
> Hi,
> I have a report with multiple pages.
> I added a page break but then went to the table properties and unchecked
the
> page break checkbox.
> However, when i run the report from my vb.net application I can see a page
> break at the end of each page. How can I delete the page breaks?
> Thanks.

page break

I have a matrix and I want to insert a page break on a column group. I dont
see the option under grouping and sorting properties for my column groups
only on the rows?On Nov 2, 10:39 am, RYF <R...@.discussions.microsoft.com> wrote:
> I have a matrix and I want to insert a page break on a column group. I dont
> see the option under grouping and sorting properties for my column groups
> only on the rows?
Unfortunately, this functionality does not exist currently. A
workaround would be to create 2 matrices/matrix controls in the report
and have the columns you want on the odd pages in the first matrix
control (and do a page break after it) and the columns you want on the
even pages in the second matrix control (and do a page break after it
as well). Sorry that I could not be of greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

Page brakes after top group item

I just started with reporting services.
I created report that has two groujping items in the table. Everything works
fine just I always get second row for the top level group on the second
page. This doesn't make any sense to me
1) I am using HTML rending and I don't need all this pages
2) the top group item has only one detailed item and second has about 8
items they all can fit on one page even if viewed in collapsed state
3) There are no any forced page breaks for any table items and for table
itself.
Any ideas how to solve the problem?
ShimonSorry
I just figure out that it looks like that only in preview but on the site it
looks fine.
Thanks,
Shimon.
"Shimon Sim" <estshim@.att.net> wrote in message
news:eeQ3XrQeEHA.2376@.tk2msftngp13.phx.gbl...
> I just started with reporting services.
> I created report that has two groujping items in the table. Everything
works
> fine just I always get second row for the top level group on the second
> page. This doesn't make any sense to me
> 1) I am using HTML rending and I don't need all this pages
> 2) the top group item has only one detailed item and second has about 8
> items they all can fit on one page even if viewed in collapsed state
> 3) There are no any forced page breaks for any table items and for table
> itself.
> Any ideas how to solve the problem?
> Shimon
>

Page Borders

We're creating a text report (i.e. not tabular, etc.) that will run several
pages. We would like to have a border around each page, including the page
header and page footer. We've set a body border, but that doesn't draw
horizontal lines at the top an bottom of each page.
We've tried putting our controls in a rectange and expanding the rectange to
be encompass a page both vertically and horizontally, but the page header is
excluded from this border (plus we suspect we'll have additional problems if
our individual controls causes a page break). Also, though we have the
rectange control's height set to 9 inches, it shrinks such that it ends
after the last control in the region.
Any suggestions for defining a border on each page, the first page excluded
(it's a cover page)?
We're using MS Reporting Services 2005.
Thanks,
ChrisNot sure if this does exactly what you're looking for, but in addition
to the body border, have you tried putting horizontal lines in the page
header & page footer?
Eva Pierce Monsen|||Thanks for Eva's informative inputs,
Hi Chris.
As Eva has mentioned, you can explicitly customize the SSRS report's header
and footer sections in the VS 2005's report designer. Just right click on
the report designer's empty area and you'll find the "Page Header" and
"Page Footer" option in the context menu, select either one to edit the
template.
#Adding a Page Header and Footer to a Report
http://msdn2.microsoft.com/en-us/library/ms159677.aspx
BTW, as for the body's border setting, based on my local test, it also
works (display both horizental and vertical lines). I simply set the border
width and border style (solid) and the runtime report displays both
horizental and vertical border lines for the report body. I think the
problem you met is possibly specific to report body's size.
Hope this helps.
Regards,
Steven Cheng
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Steven,
The horizonal body borders appear when we first render the report. However,
when we export the report to PDF, the horizontal lines at the top & bottom
of the body do not appear. Also, the border does not encompass the header
and footer, so even if the horizontal lines did appear, it isn't quite what
we're looking for. The prototype I'm working off of is a MS Word document
that has a page border that does encompass the header & footer.
Any other suggestions?
Thanks,
Chris
"Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
news:NasHAxdjGHA.4528@.TK2MSFTNGXA01.phx.gbl...
> Thanks for Eva's informative inputs,
> Hi Chris.
> As Eva has mentioned, you can explicitly customize the SSRS report's
> header
> and footer sections in the VS 2005's report designer. Just right click on
> the report designer's empty area and you'll find the "Page Header" and
> "Page Footer" option in the context menu, select either one to edit the
> template.
> #Adding a Page Header and Footer to a Report
> http://msdn2.microsoft.com/en-us/library/ms159677.aspx
> BTW, as for the body's border setting, based on my local test, it also
> works (display both horizental and vertical lines). I simply set the
> border
> width and border style (solid) and the runtime report displays both
> horizental and vertical border lines for the report body. I think the
> problem you met is possibly specific to report body's size.
> Hope this helps.
> Regards,
> Steven Cheng
> Microsoft Online Community Support
>
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> Get Secure! www.microsoft.com/security
> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||Hi Chris,
Thanks for your response.
Yes, the body border solution has its natural limitation since it does not
include the Header and Footer sections. Have you tried Eva's suggestion on
customizing the UI through the Header and Footer template in the report
designer? As I've also mentioned in the previous message, you can right
click on the report designer's empty area and you'll find the "Page Header"
and "Page Footer" option in the context menu, select either one to edit the
template. Thus, you can put some report item(such as Line ) into the header
or footer section to simulate a border line. How do you think of this?
Regards,
Steven Cheng
Microsoft MSDN Online Support Lead
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hey Chris,
How are you doing on this issue, does the further suggestion help you some?
If there is still anything we can help, please feel free to post here.
Regards,
Steven Cheng
Microsoft MSDN Online Support Lead
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)