how to sum and subtotal by project code in vs 2005 reporting service.[Answered] RSS

• • Reply
  z0mbie

  None

  0 Points

  5 Posts

  how to sum and subtotal by project code in vs 2005 reporting service.

  Jul 21, 2011 11:56 PM|z0mbie|LINK

  
  I need to display the sub total for each project code as follow.I am new to RS . Any help would be appreciated. Thanks.

  
  Code  EmployeeName          Projectcode  Salary   TotalIncome  
                                                            Leave    TotalDetact
  000      Adam                        ADM         1000      1000
                                                              100       100  
                                               ELS         1100      1100
                                                               100       100
  
  010       Eris                           ADM        15000      15000
                                                               500        500
  
  Subtotalfor                             ADM         16000      16000    // I dont know how to do in here.
  Project                                                     600        600
  
  2 persons
  
  1 person                                 ELS            1100       1100
                                                                  100        100 

• • Reply
  Gatsy

  Member

  120 Points

  47 Posts

  Re: how to sum and subtotal by project code in vs 2005 reporting service.

  Jul 22, 2011 02:58 AM|Gatsy|LINK

  Select the group seen at the bottom of the IDE, then right click then select add total row.

• • Reply
  z0mbie

  None

  0 Points

  5 Posts

  Re: how to sum and subtotal by project code in vs 2005 reporting service.

  Jul 22, 2011 03:18 AM|z0mbie|LINK

  Hi Gatsy,

  Thanks for your reply. I want to show table details without grouping.

  At Subtotal Section, After i insert group by project code , it effects on table details even  i uncheck in "include group header and group footer".

  Should i use subtotal for footer , right?

  As you said, Select the group seen at the bottom of the IDE, then right click then I cant add the total row. It only appears "select table 1 and select body"

  Could you please explain me more?

  Thanks for your time.

• • Reply
  You-Hu Fu

  Contributor

  6670 Points

  794 Posts

  Re: how to sum and subtotal by project code in vs 2005 reporting service.

  Jul 27, 2011 02:52 AM|You-Hu Fu|LINK

  Hi,

  Please refer to this same thread http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/ae838732-3dcf-43e6-8519-cfac5c81bfca 

  Thanks

  Please mark the replies as answers if they help or unmark if not.
  Feedback to us
  Microsoft One Code Framework