locked
html being passes to ssrs report server RRS feed

  • Question

  • User-1997257017 posted

    A vb.net 2010 web form application is calling an ssrs 2008 report server and passing parameter values. The ssrs report currently contains an  image of the school logo, the address of the school and the current date.  Html is being accessed by a ssrs 2008 report server with the data being stored in a varchar(max) column.

    Right now 1 letter at a time is being generated and exported to a pdf report that prints on one page. Now the user wants to generate up to 4 letters at the same time with one call from the web form application. The letter will remain the same. The only difference will be the mailing address of each letter. The user wants each letter to print on separate pages.

    I am basically planning on placing up to 4 copies of the html listed below in the varchar(max) column. Thus can you tell me what I can do with the html listed below and/or with the ssrs 2008 report to make the different letters print on separate pages?

    <p>&nbsp;</p>
    <p>&nbsp;</p>
    <p>&nbsp;</p>
    <p>&amp;CUR_DATE.EVAL</p>
    <br />
    <br />
    <br />
    <p>
    </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; &amp;PERMNUM</p>
    <p>&amp;PAR_ADDR.EVAL</p>
    &amp;PAR_CITY.EVAL, &amp;PAR_STATE.EVAL &amp;PAR_ZIP.EVAL<br />
    <br />
    <br />
    <br />
    Dear
    &amp;PAR_NAME.EVAL and &amp;STU_FNAME.EVAL &amp;STU_LNAME.EVAL:<br />
    <br />
    <br />
    This letter is to inform you that
    &amp;STU_FNAME.EVAL 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 />
    &amp;SPA_NAME.EVAL<br />
    <p>
    School Support Liaison
    / Attendance Designee</p>
    <p>&amp;SCHOOLNAME.EVAL</p>
    <p>&nbsp;</p> <p>&nbsp;</p> <p>&nbsp;</p> <p>&amp;CUR_DATE.EVAL</p> <br /> <br /> <br /> <p> </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; &amp;PERMNUM</p> <p>&amp;PAR_ADDR.EVAL</p> &amp;PAR_CITY.EVAL, &amp;PAR_STATE.EVAL &amp;PAR_ZIP.EVAL<br /> <br /> <br /> <br /> Dear &amp;PAR_NAME.EVAL and &amp;STU_FNAME.EVAL &amp;STU_LNAME.EVAL:<br /> <br /> <br /> This letter is to inform you that &amp;STU_FNAME.EVAL 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 /> &amp;SPA_NAME.EVAL<br /> <p> School Support Liaison/ Attendance Designee</p> <p>&amp;SCHOOLNAME.EVAL</p>

    Thursday, October 27, 2016 8:34 PM

Answers

  • User-2057865890 posted

    Hi Wendy,

    make the different letters print on separate pages?

    A page break divides a report into separate pages for viewing and printing. Page breaks determine how the content is fitted to a report page for optimal viewing when you preview a report or export it to a different file format.

    reference:

    How to: Add a Page Break (Report Builder 3.0 and SSRS)

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

    Best Regards,

    Chris

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, October 28, 2016 8:26 AM

All replies

  • User-2057865890 posted

    Hi Wendy,

    make the different letters print on separate pages?

    A page break divides a report into separate pages for viewing and printing. Page breaks determine how the content is fitted to a report page for optimal viewing when you preview a report or export it to a different file format.

    reference:

    How to: Add a Page Break (Report Builder 3.0 and SSRS)

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

    Best Regards,

    Chris

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, October 28, 2016 8:26 AM
  • User-1997257017 posted

    Thanks for your reference to  page breaks!

    Monday, October 31, 2016 7:15 PM