I have made a report that uses a dataset that is populated from a stored procedure. I would like to have the pages break in the report when there is a change in one of the columns. The column contains these values 200, 210, 220, and cellar. The problem is I would like the pages to group all the 200s together and the cellars on their own pages. Is there a place in the report designer I can put some logic to group together if it starts with a 2?
I attached a picture of where I set the grouping.