Hello, I am encountering a very strange problem with grouping... I have a database that has data for the same field but for different years. For example, the following are all different data fields: 'Standardized Mortality Ratio, 2005' 'Standardized Mortality Ratio, 2006' 'Standardized Mortality Ratio, 2007' 'Standardized Mortality Ratio, 2008' 'Standardized Mortality Ratio, 2005-08' I am trying to group them using the following expression: =LEFT(Fields!Description.Value, INSTRREV(Fields!Description.Value, ",")-1) The first four fields with single years are being grouped together without difficulty, but for some reason the one with '2005-08' is being grouped seperately. The really weird part is that the text being shown for each field is exactly the same for both groups. Thank you for any help you are able to provide.

Hi szenert, I test your datafields in my local environment, all of the below value return "Standardized Mortality Ratio" 'Standardized Mortality Ratio, 2005' 'Standardized Mortality Ratio, 2006' 'Standardized Mortality Ratio, 2007' 'Standardized Mortality Ratio, 2008' 'Standardized Mortality Ratio, 2005-08' So I think the all these value should be grouped in one group "Standardized Mortality Ratio", however they are not, just as you mentioned. Here I would recommend you utilize this expression =LEFT(Fields!Description.Value, INSTR(Fields!Description.Value, ",")-1) to have a test, besides this, make sure "Standardized Mortality Ratio" is same in every datafiled's vlaue, including capital and small letter. After these, if this scenario still exist, please send your the report and relevant datasource to sqltnsp AT microsoft DOT com, With the beginning “hi Challen”, please attach the thread link as well. Once I receive your email, I will give you a feedback as soon as possible. Regards, Challen Fu