locked
Html value in one column. create Multiple Row Grouping Elements for colum in ssrs report RRS feed

  • Question

  • User-1997257017 posted

    A web form 2010 application calls an ssrs 2008 report currently. In this existing ssrs 2008 report , I will like to create multiple groupings within the report so the report will print on different pages. The multiple groupings would come from 1 (one)  column that is contained within a sql server database where the field is defined as varchar(max).

    I would like the groupings to be based upon specific literals.

    The general page break information is obtained from the following location:

    https://msdn.microsoft.com/en-us/library/dd207058(v=sql.105).aspx .

    However I do not know how to create multiple groupings based on different parts of the same sql server 2012 column containing different literals.

    In the example I am showing you, I would like to create a page break where the literal <html> is located. The literal could be anything.

    I am just using the literal  <html> so you can show me and/or point me to links that will tell me how to accomplish my goal of page breaks?

    <p>&nbsp;</p>
    <p>&nbsp;</p>
    <p>&nbsp;</p>
    <p>&amp;CUR_DATE.EVAL</p>
    <p>&nbsp;</p>
    <p>&nbsp;</p>
    <p>To the &amp;PAR_NAME.EVAL of &amp;STU_FNAME.EVAL &amp;STU_LNAME.EVAL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &amp;PERMNUM</p>
    <p>&amp;PAR_ADDR.EVAL<br />
    &amp;PAR_CITY.EVAL, &amp;PAR_STATE.EVAL &amp;PAR_ZIP.EVAL</p>
    <p>&nbsp;</p>
    <p>&nbsp;Dear &amp;PAR_NAME.EVAL and &amp;STU_FNAME.EVAL &amp;STU_LNAME.EVAL:</p>
    <p>&nbsp;This letter is to inform you that &amp;STU_FNAME.EVAL has the equivalent of 5 or more unexcused absences this school year.&nbsp; 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.</p>
    <p>&nbsp;</p>
    <p>(Option 1)</p>
    <p>Please call me at PHONE NUMBER 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. </p>
    <p>&nbsp;</p>
    <p>(Option 2)</p>
    <p>I have scheduled an attendance review on DATE at TIME.&nbsp; We will meet at PLACE located at ADDRESS. 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 please contact me at PHONE #. </p>
    <p>&nbsp;</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>
    <p>&nbsp;Sincerely,</p>
    <p>&nbsp;&amp;SPA_NAME.EVAL</p>
    <p>School Support Liaison/ Attendance Designee</p>
    <p>&amp;SCHOOLNAME.EVAL</p>
    <html>
    <p>&nbsp;</p>
    <p>&nbsp;</p>
    <p>&nbsp;</p>
    <p>&amp;CUR_DATE.EVAL</p>
    <p>&nbsp;</p>
    <p>&nbsp;</p>
    <p>To the &amp;PAR_NAME.EVAL of &amp;STU_FNAME.EVAL &amp;STU_LNAME.EVAL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &amp;PERMNUM</p>
    <p>&amp;PAR_ADDR.EVAL<br />
    &amp;PAR_CITY.EVAL, &amp;PAR_STATE.EVAL &amp;PAR_ZIP.EVAL</p>
    <p>&nbsp;</p>
    <p>&nbsp;Dear &amp;PAR_NAME.EVAL and &amp;STU_FNAME.EVAL &amp;STU_LNAME.EVAL:</p>
    <p>&nbsp;This letter is to inform you that &amp;STU_FNAME.EVAL has the equivalent of 5 or more unexcused absences this school year.&nbsp; 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.</p>
    <p>&nbsp;</p>
    <p>(Option 1)</p>
    <p>Please call me at PHONE NUMBER 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. </p>
    <p>&nbsp;</p>
    <p>(Option 2)</p>
    <p>I have scheduled an attendance review on DATE at TIME.&nbsp; We will meet at PLACE located at ADDRESS. 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 please contact me at PHONE #. </p>
    <p>&nbsp;</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>
    <p>&nbsp;Sincerely,</p>
    <p>&nbsp;&amp;SPA_NAME.EVAL</p>
    <p>School Support Liaison/ Attendance Designee</p>
    <p>&amp;SCHOOLNAME.EVAL</p>
    </html>

    Tuesday, November 1, 2016 3:30 PM

Answers

  • User-1997257017 posted

    I have tried the page-break-after:always and the page break does not work. How about if I use a filter in a rectangle and the rectangle will set the page break? How would I setup the filter on a rectangle or use the visibility property to display only portions of the html that I want displayed?

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, November 3, 2016 2:03 PM

All replies