locked
vb.net calling ssrs report is not displaying page breaks properly. RRS feed

  • 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>&nbsp;</p> 
    <p>&nbsp;</p> 
    <p>&nbsp;</p> 
    <p>12/9/2016</p> 
    <br /> 
    <br /> 
    <br /> 
    <p>  </p> 
    <p>To the Parent/Guardian of Joe Smith&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n
    bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs
    p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
    &nbsp; 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.&nbsp; <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&nbsp;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;">&nbsp;</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>.&nbsp;&nbsp;We will meet at <em>PLACE</em> located at 
    <em>ADDRESS</em>. Please check in at the main office upon your arrival.&nbsp; 
    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. 
    &nbsp;The student and parent should attend this review. If you cannot attend 
    this meeting&nbsp;please contact me at PHONE #. </span></p> 
    <br /> 
    <p>  </p> 
    <p>&nbsp;</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>&nbsp;</p> 
    <p>&nbsp;</p> 
    <p>&nbsp;</p> 
    <p>12/9/2016</p> 
    <br /> 
    <br /> 
    <br /> 
    <p>  </p> 
    <p>To the Parent/Guardian of Joe Smith&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n
    bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs
    p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
    &nbsp; 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.&nbsp; <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&nbsp;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;">&nbsp;</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>.&nbsp;&nbsp;We will meet at <em>PLACE</em> located at 
    <em>ADDRESS</em>. Please check in at the main office upon your arrival.&nbsp; 
    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. 
    &nbsp;The student and parent should attend this review. If you cannot attend 
    this meeting&nbsp;please contact me at PHONE #. </span></p> 
    <br /> 
    <p>  </p> 
    <p>&nbsp;</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>&nbsp;</p> 
    <p>&nbsp;</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