Answered by:
vb.net calling ssrs report is not displaying page breaks properly.

Question
-
User-1997257017 posted
In an SSRS 2008 r2 report that is called by a vb.net 2010 web form application, I am trying to determine why a page break is not working. The problem is either with the html or the page break in the ssrs 2008 r2 report that was recently converted from ssrs 2008. At the group level in a tablix member I have the disabled property setup with the following code:
=IIF(Fields!stringtemplate.Value like "*END_PAGE*",False,true).
Listed below is the html that is stored in a varchar(Max) field called stringtemplate:
<p> </p> <p> </p> <p> </p> <p>12/9/2016</p> <br /> <br /> <br /> <p> </p> <p>To the Parent/Guardian of Joe Smith &n bsp; &nbs p; 447782</p> <span id=""ADDR_BEG"> </span> <p>4 VERNON AVE </p><span id="ADDR_NEXT">CLER, NE 68111<span id="ADDR_END"></span><br /> <br /> <br /> <br /> Dear Parent/Guardian and Joe Smith:<br /> <br /> <br /> This letter is to inform you that Jarious has the equivalent of 5 or more unexcused absences this school year. <span style="color: black; font-family: arial,sans-serif; font-size: 10pt;"><span style="font-family: arial; font-size: 14px;">We believe student attendance in school is a key component to school success, so it is very important for all children to develop habits of good attendance. Poor attendance contributes to failing grades, decreased learning opportunities, lower academic achievement and may limit your child's opportunities to be involved with school activities.</span><br /> <br /> </span><br /> <p><span style="color: black; font-family: arial,sans-serif;">(Option 1)</span></p> <p><span style="color: black; font-family: arial,sans-serif;">Please call me at <em>PHONE NUMBER</em> to discuss these absences. During this phone conference we will address concerns and issues that may be contributing to the absences, and develop a collaborative plan to try to improve attendance. </span></p> <p><span style="color: black; font-family: arial,sans-serif;"> </span></p> <p><span style="color: black; font-family: arial,sans-serif;">(Option 2)</span></p> <p style="margin: 10pt 0in;"><span style="color: black; font-family: arial,sans-serif;">I have scheduled an attendance review on <em>DATE</em> at <em>TIME</em>. We will meet at <em>PLACE</em> located at <em>ADDRESS</em>. Please check in at the main office upon your arrival. During this meeting we will address concerns and issues that may be contributing to the absences, and develop a collaborative plan to try to improve attendance. The student and parent should attend this review. If you cannot attend this meeting please contact me at PHONE #. </span></p> <br /> <p> </p> <p> </p> <p>We are notifying you so that together we can address all issues that may be contributing to these absences. Communication between the home and school is very important and we request that parents call the school each and every day that a student is going to be absent. Let us work as partners to make your child successful in school.</p> <br /> Sincerely,<br /> <br /> <br /> Tracy smithk<br /> <p> School Support Liaison/ Attendance Designee</p> <p>TECH School</p><span id="END_PAGE"></span><p> </p> <p> </p> <p> </p> <p>12/9/2016</p> <br /> <br /> <br /> <p> </p> <p>To the Parent/Guardian of Joe Smith &n bsp; &nbs p; 447782</p> <span id=""ADDR_BEG"> </span> <p>4841 CLEAR ST #205</p><span id="ADDR_NEXT">VET, NJ 68104<span id="ADDR_END"></span><br /> <br /> <br /> <br /> Dear Parent/Guardian and Joe Smith:<br /> <br /> <br /> This letter is to inform you that Jarious has the equivalent of 5 or more unexcused absences this school year. <span style="color: black; font-family: arial,sans-serif; font-size: 10pt;"><span style="font-family: arial; font-size: 14px;">We believe student attendance in school is a key component to school success, so it is very important for all children to develop habits of good attendance. Poor attendance contributes to failing grades, decreased learning opportunities, lower academic achievement and may limit your child's opportunities to be involved with school activities.</span><br /> <br /> </span><br /> <p><span style="color: black; font-family: arial,sans-serif;">(Option 1)</span></p> <p><span style="color: black; font-family: arial,sans-serif;">Please call me at <em>PHONE NUMBER</em> to discuss these absences. During this phone conference we will address concerns and issues that may be contributing to the absences, and develop a collaborative plan to try to improve attendance. </span></p> <p><span style="color: black; font-family: arial,sans-serif;"> </span></p> <p><span style="color: black; font-family: arial,sans-serif;">(Option 2)</span></p> <p style="margin: 10pt 0in;"><span style="color: black; font-family: arial,sans-serif;">I have scheduled an attendance review on <em>DATE</em> at <em>TIME</em>. We will meet at <em>PLACE</em> located at <em>ADDRESS</em>. Please check in at the main office upon your arrival. During this meeting we will address concerns and issues that may be contributing to the absences, and develop a collaborative plan to try to improve attendance. The student and parent should attend this review. If you cannot attend this meeting please contact me at PHONE #. </span></p> <br /> <p> </p> <p> </p> <p>We are notifying you so that together we can address all issues that may be contributing to these absences. Communication between the home and school is very important and we request that parents call the school each and every day that a student is going to be absent. Let us work as partners to make your child successful in school.</p> <br /> Sincerely,<br /> <br /> <br /> Tracy smithk<br /> <p> School Support Liaison/ Attendance Designee</p> <p>TECH School</p><p> </p> <p> </p>
The <span id="END_PAGE"></span> literal is where the page break should occur. I know there is a problem since the date for letter #2 is appearing at the bottom of letter #1. (What is being displayed is actually letters when run in the ssrs report.)
Thus would you tell me where you think the problem lies at?
Friday, December 16, 2016 12:41 AM
Answers
-
User-2057865890 posted
Hi Wendy,
Take a look at this thread https://social.technet.microsoft.com/Forums/windowsserver/en-US/97aad5c8-79c7-4c1a-9ff0-a2b50579fce3/ssrs-report-setting-up-page-breaks?forum=sqlreportingservices.
Best Regards,
Chris
- Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
Tuesday, December 20, 2016 9:25 AM