October 27, 2016 at 2:57 pm
A ssrs 2008 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 run of the report. 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>&CUR_DATE.EVAL</p>
<br />
<br />
<br />
<p>
</p>
<p>To the &PAR_NAME.EVAL of &STU_FNAME.EVAL &STU_LNAME.EVAL &PERMNUM</p>
<p>&PAR_ADDR.EVAL</p>
&PAR_CITY.EVAL, &PAR_STATE.EVAL &PAR_ZIP.EVAL<br />
<br />
<br />
<br />
Dear &PAR_NAME.EVAL and &STU_FNAME.EVAL &STU_LNAME.EVAL:<br />
<br />
<br />
This letter is to inform you that &STU_FNAME.EVAL 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>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 />
&SPA_NAME.EVAL<br />
<p>
School Support Liaison/ Attendance Designee</p>
<p>&SCHOOLNAME.EVAL</p>
October 31, 2016 at 3:52 am
How is your HTML being generated? I assume that it is not a dataset, which means that SSRS will see your HTML string as one item, not 4. I wouldn't say that SSRS is really designed with the intent of manipulating a HTML page.
Do you have any kind of datasets you were using for the report? Your best option would be to have each client as a separate row in your data, and then SSRS can loop around that. You can then insert all of your current items within a frame, which is grouped on a client. Then set up the frame to insert a page break after each row.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 31, 2016 at 2:36 pm
Thank you for your suggestion! You stated the following, "You can then insert all of your current items within a frame, which is grouped on a client. Then set up the frame to insert a page break after each row.".
From your statement listed above, would you tell me what a frame is?
November 1, 2016 at 1:46 am
"Frame" possibly wasn't the beat choice of word sorry (what I get for poking in Web Dev recently). I mean that you use an object which has a grouping on it, which you can then insert further items inside (in this case your HTML). The grouping woukd then create a new page (which you can set in the properties) for each new group.
You can do this with a range of items, such as matrices and tables (a table woukd work best here as you have a single item). It would, however, mean changing your setup, however I can invisage a way for sure to effecting read your html and then create page breaks. You likely could with custom code (you can do a lot with that), but not something I've really dabbled much with.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply