How to Apply grouping in ssrs


  • Hi,

    I have to create a ssrs report as given below:

    I want to group our report to show its record as given below.

    Please help to solve this problem.



    Friday, April 05, 2013 1:14 PM


  • Hi Rajni,

    Based on your description, it seems that you want to display the "investments" information: calculated values and description of details. If so, you can try to use nested data region or subreport.

    For example, in the main report, group the report data with field "investments" and diaply aggregate values. In the subreport, add a parameter and filter data by field "investments". Then add the subreport into the main report and pass the values from main report to the parameter of subreport.
    For more infromation, please see:Add a Subreport and Parameters

    If I have any misunderstanding,please post both the report and the dataset with sample data to us by the following E-mail address.  It is benefit for us to do further analysis.

    Fanny Liu

    Fanny Liu
    TechNet Community Support

    Monday, April 08, 2013 8:10 AM

All replies