SQLTeam.com | Weblogs | Forums

Ssrs 2008-Multiple Row Grouping Elements obtained from one column in database


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: