SSRS Report
Hi i have a problem in displaying a Continued ... when the group details moves to a new page
please find the screen shots .......
September 22nd, 2011 12:37am
Hi Nag1234,
Welcome to here. If my understanding is correct, you would like the rows in the details group display keep together in one single page, right?
If I misunderstand your question, please let me know.
In this situation, I guess this issue caused by the small report page size, please increase the height size value. As we know,
Reporting Services is designed to use 2 different rules in pagination:
1.
Physical pagination is used to the print control and the TIFF and PDF rendering extensions. It is controlled by the PageSize properties
2.
Logical pagination is used to the HTML and GDI rendering extensions. It is controlled by the InteractiveSize properties
For more detail information, please refer to this
FAQ:
How do I get the same page number in web page and PDF?
Thanks,
Sharp
Please remember to mark the replies as answers if they help you and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
September 23rd, 2011 10:21am
Hi
I have the Residential Loans records in page 1 when the records exceeds the first page it need to display Residential Loans Continued In the next page I know we don't have a option in SSRS to display this way. Can u tell me any logic that would
work so that we can display the continued... ?
September 23rd, 2011 5:35pm
Hi Nag1234,
Thanks for your reply. The reason of why the exceed records need to display in the continue page, I would suggest you read this MSDN article:
Understanding Pagination in Reporting Services (Report Builder 3.0 and SSRS).
To display the
Residential Loans records keep together in one single page, I would suggest you check the check box of Keep together on one page if possible.
SSRS-Keep Together
Thanks,
Sharp
Please remember to mark the replies as answers if they help you and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
September 26th, 2011 5:52am
So except checking we dont have any custom expression to display it Continued ... when the detail group continues on to next page ?
September 26th, 2011 4:56pm
Hi Nag1234,
Welcome to here. If my understanding is correct, you would like the rows in the details group display keep together in one single page, right?
If I misunderstand your question, please let me know.
In this situation, I guess this issue caused by the small report page size, please increase the height size value. As we know,
Reporting Services is designed to use 2 different rules in pagination:
1.
Physical pagination is used to the print control and the TIFF and PDF rendering extensions. It is controlled by the PageSize properties
2.
Logical pagination is used to the HTML and GDI rendering extensions. It is controlled by the InteractiveSize properties
For more detail information, please refer to this
FAQ:
How do I get the same page number in web page and PDF?
Thanks,
Sharp
Please remember to mark the replies as answers if they help you and unmark them if they provide no help.
Hi Nag1234,
As mentioned in this reply, the PDF rending extension controlled by the PageSize property. If the rows count height in the details
group beyond the PageSize value, the extra rows will be displayed in the next page.
Thanks,
Sharp Wang
Please remember to mark the replies as answers if they help you and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
September 30th, 2011 4:24am
hi,
you can solve it by a small workaround.
try this.
remove your table headers.
create headers by placing text box in page header.
in the Residential Loans heading write the below expression.
=iif(Globals!PageNumber>1,"Residential Loans (Continued)","Residential Loans ")
It will definitely work.Regards, Gayathri devi P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)
September 30th, 2011 7:03am
Hi Nag1234,
Welcome to here. If my understanding is correct, you would like the rows in the details group display keep together in one single page, right?
If I misunderstand your question, please let me know.
In this situation, I guess this issue caused by the small report page size, please increase the height size value. As we know,
Reporting Services is designed to use 2 different rules in pagination:
1.
Physical pagination is used to the print control and the TIFF and PDF rendering extensions. It is controlled by the PageSize properties
2.
Logical pagination is used to the HTML and GDI rendering extensions. It is controlled by the InteractiveSize properties
For more detail information, please refer to this
FAQ:
How do I get the same page number in web page and PDF?
Thanks,
Sharp
Please remember to mark the replies as answers if they help you and unmark them if they provide no help.
Hi Nag1234,
As mentioned in this reply, the PDF rending extension controlled by the PageSize property. If the rows count height in the details
group beyond the PageSize value, the extra rows will be displayed in the next page.
Thanks,
Sharp Wang
Please remember to mark the replies as answers if they help you and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
September 30th, 2011 11:20am
HI Gayathri
Thats a good idea but i have a header with different discription i have attached a picture u can get complete idea of it
when the residential loans group go on to a next page we should display continue ...
September 30th, 2011 3:55pm
Hi Nag1234,
Welcome to here. If my understanding is correct, you would like the rows in the details group display keep together in one single page, right?
If I misunderstand your question, please let me know.
In this situation, I guess this issue caused by the small report page size, please increase the height size value. As we know,
Reporting Services is designed to use 2 different rules in pagination:
1.
Physical pagination is used to the print control and the TIFF and PDF rendering extensions. It is controlled by the PageSize properties
2.
Logical pagination is used to the HTML and GDI rendering extensions. It is controlled by the InteractiveSize properties
For more detail information, please refer to this
FAQ:
How do I get the same page number in web page and PDF?
Thanks,
Sharp
Please remember to mark the replies as answers if they help you and unmark them if they provide no help.
Hi Nag1234,
As mentioned in this reply, the PDF rending extension controlled by the PageSize property. If the rows count height in the details
group beyond the PageSize value, the extra rows will be displayed in the next page.
Thanks,
Sharp Wang
Please remember to mark the replies as answers if they help you and unmark them if they provide no help.
please see the attached image which will help to get more idea on my question and thanks for u hard work in posting which might help me later stage
Free Windows Admin Tool Kit Click here and download it now
September 30th, 2011 3:58pm
Hi Nag1234,
Welcome to here. If my understanding is correct, you would like the rows in the details group display keep together in one single page, right?
If I misunderstand your question, please let me know.
In this situation, I guess this issue caused by the small report page size, please increase the height size value. As we know,
Reporting Services is designed to use 2 different rules in pagination:
1.
Physical pagination is used to the print control and the TIFF and PDF rendering extensions. It is controlled by the PageSize properties
2.
Logical pagination is used to the HTML and GDI rendering extensions. It is controlled by the InteractiveSize properties
For more detail information, please refer to this
FAQ:
How do I get the same page number in web page and PDF?
Thanks,
Sharp
Please remember to mark the replies as answers if they help you and unmark them if they provide no help.
Hi Nag1234,
As mentioned in this reply, the PDF rending extension controlled by the PageSize property. If the rows count height in the details
group beyond the PageSize value, the extra rows will be displayed in the next page.
Thanks,
Sharp Wang
Please remember to mark the replies as answers if they help you and unmark them if they provide no help.
please see the attached image which will help to get more idea on my question and thanks for u hard work in posting which might help me later stage
if u see the above image u might know what i am trying to say
September 30th, 2011 4:24pm