InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 02:52:51 GMT20http://www.sqlservercentral.com/Forums/Topic1356319-150-1.aspx[quote][b]vani_r14 (9/19/2012)[/b][hr]Hi therecan you please clarify - if my understanding is correct -You would like to group BC1, BC2, BC3, BC4, BC5 as one group if that is the case then you need to add a calculated field. You can do it either in your sql query or in your reportOr Would you like to have them listed as individual groups Cheers[/quote]Hi Vani,Yes I want to add them up as a group. I am using a cube to get this data from so can you tell me based on that? I know its like a CASE statement in SQL but I am not sure what to do if coming from a cube.ThanksThu, 20 Sep 2012 13:08:33 GMTa4applehttp://www.sqlservercentral.com/Forums/Topic1356319-150-1.aspxHi therecan you please clarify - if my understanding is correct -You would like to group BC1, BC2, BC3, BC4, BC5 as one group if that is the case then you need to add a calculated field. You can do it either in your sql query or in your reportOr Would you like to have them listed as individual groups CheersWed, 19 Sep 2012 16:13:41 GMTvani_r14http://www.sqlservercentral.com/Forums/Topic1356319-150-1.aspxCan you show us the SQL code?I had a similar problem, but what I wanted was to group 2 different fields, and all I had to do was to add an UNION operator.So this is a shot in the dark, if you have an UNION operator just remove it.Wed, 12 Sep 2012 05:38:21 GMTdavdam8http://www.sqlservercentral.com/Forums/Topic1356319-150-1.aspxYou could add a [b]calculated field[/b] on which you should group on.You can use [b]mid[/b] function in the report expression for the new field and extract only first 2 words like 'BC' AND 'HC' from the fields whose values are BC1, BC2,etc.If you can google for 'add calculated field in SSRS' you will find the tutorial and same for mid function.Mon, 10 Sep 2012 00:39:08 GMTH4Khttp://www.sqlservercentral.com/Forums/Topic1356319-150-1.aspxHi,I have an SSRS report to build that looks like this.Name Count TotalBIKE COMPANIES 50 3000HELMET COMPANIES 10 200The problem is I have 5 different bikes Companies (BC1, BC2, BC3, BC4 and BC5) and the same with Helmet Companies. I am pulling this data from the CUBE.When I pull data from the Cube I see it asBC1 15 400BC2 15 1600BC3 0 0BC4 20 1000BC5 0 0HC1 1 20HC2 39 165HC3 8 10HC4 0 0HC5 2 5Now, my task is to group BC1, BC2, BC3, BC4, BC5 as one group and HC1, HC2, HC3, HC4, HC5 as one group and get the report as required. Please suggest me a way or a good tutorial to work. I am totally new to SSRS and SSAS, so please bear with my terminology. I know there is something called NamedSets, but is that the way we do it?Thanks in advanceFri, 07 Sep 2012 18:28:16 GMTa4apple