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 mine is located. The literal could be anything.
I am just using the literal mine so you can show me and/or point me to links that will tell me how to accomplish my goal of page breaks?
Here is the example:
&CUR_DATE.EVAL
mine
&CUR_DATE.EVAL