Home Forums Reporting Services Reporting Services Grouping Values in a Report?? RE: Grouping Values in a Report??

  • September 20, 2012 at 1:08 pm

    #1540331

    vani_r14 (9/19/2012)

    Hi there

    can 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 report

    Or

    Would you like to have them listed as individual groups

    Cheers

    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.

    Thanks

    Good Luck 🙂 .. Visit www.sqlsaga.com for more t-sql code snippets and BI related how to articles.