Want to Print Items with Sales Summery Under Each Group. RRS feed

  • Question

  • Hi,

    I want to Print Items Sales Summery Under Each Group i.e Company ->Costcenter->Department
    in a drill down sql server report with thier row and column subtotals.
    I m getting only last level summery right now , how can i insert Items Sales Under Each Group.

    Tanks in Advance.
    Monday, May 18, 2009 11:31 AM


  • Hi,


    Create a new report named sub report with parameters to display the Sales Summery, set the query string like this:

    Select * from table where Company= @parameter or Costcenter = @paramete or Department =@paramete

     And then, drag the report from solution explorer into the each group header in the report you mentioned. After that, right click the subreport in the main report, click properties, and set the field value for the parameter.


    Hope this helps.


    • Marked as answer by Raymond-Lee Friday, May 29, 2009 6:42 AM
    Wednesday, May 20, 2009 4:17 AM