November 1, 2016 at 9:59 am
In an 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?
example is listed here:
<p>&CUR_DATE.EVAL</p>
<p>To the &PAR_NAME.EVAL of &STU_FNAME.EVAL &STU_LNAME.EVAL &PERMNUM</p>
<p>&PAR_ADDR.EVAL<br />
&PAR_CITY.EVAL, &PAR_STATE.EVAL &PAR_ZIP.EVAL</p>
<p> Dear &PAR_NAME.EVAL and &STU_FNAME.EVAL &STU_LNAME.EVAL:</p>
<p> This letter is to inform you that &STU_FNAME.EVAL has the equivalent of 5 or more unexcused absences this school year. 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>(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>(Option 2)</p>
<p>I have scheduled an attendance review on DATE at TIME. We will meet at PLACE located at ADDRESS. 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 #. </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> Sincerely,</p>
<p> &SPA_NAME.EVAL</p>
<p>School Support Liaison/ Attendance Designee</p>
<p>&SCHOOLNAME.EVAL</p>
<html>
<p>&CUR_DATE.EVAL</p>
<p>To the &PAR_NAME.EVAL of &STU_FNAME.EVAL &STU_LNAME.EVAL &PERMNUM</p>
<p>&PAR_ADDR.EVAL<br />
&PAR_CITY.EVAL, &PAR_STATE.EVAL &PAR_ZIP.EVAL</p>
<p> Dear &PAR_NAME.EVAL and &STU_FNAME.EVAL &STU_LNAME.EVAL:</p>
<p> This letter is to inform you that &STU_FNAME.EVAL has the equivalent of 5 or more unexcused absences this school year. 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>(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>(Option 2)</p>
<p>I have scheduled an attendance review on DATE at TIME. We will meet at PLACE located at ADDRESS. 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 #. </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> Sincerely,</p>
<p> &SPA_NAME.EVAL</p>
<p>School Support Liaison/ Attendance Designee</p>
<p>&SCHOOLNAME.EVAL</p>
</html>
November 2, 2016 at 2:06 pm
"However I do not know how to create multiple groupings based on different parts of the same sql server 2012 column containing different literals."
Normalization is a beautiful thing. And now you should understand a bit better the reason for it.
November 2, 2016 at 2:08 pm
"However I do not know how to create multiple groupings based on different parts of the same sql server 2012 column containing different literals."
Normalization is a beautiful thing. And now you should understand a bit better the reason for it.
November 2, 2016 at 2:30 pm
I'm confused with how your data/report is laid out but have you tried enabling Page Breaks on the grouping and then adding an expression to the Page Break Disabled property of that group to set this to true for everything that isn't "<html>"?
=iif(Fields!Col.Value="<html>",false,true)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply