Easy reporting Problem !!

• rk1980factor

  SSCommitted

  Points: 1681

  More actions

  July 15, 2016 at 2:48 pm

  #315237

  I am facing very easy reporting problem but can't figure out why this is happening.

  I created SSRS report in Report Builder 3.0. The report looks like one in the attachment.

  select Name,comp.Month,Date, Corporation, Line.Route, people,total people from comp join Line on comp.route=Line.route where (comp.receipt = Line.receipt)

  and comp.year=2016 and def='oil' order by name,date

  What I wanted is :

  1) Display of Report should be sort by Name first and than by Date

  2) I want to display sub-total under people for particular name as group.

  So for example:

  1) It should sort by name and than by date so in attach file data e.g. should be Exxon Inc and third column should have 11/22/2014,12/22/2014 and 05/22/2014 in order.

  But my result only sorts Name ( when i run query to test before building the final report it sorts both name and date but when i finally run the report it only sorts name and not date.

  2) want to display sub-total under people for name group. When i right click on that field in designer mode and click add total, it adds total for each row of people. So for e.g. in attach file it shows me 6 under that sub-total 6 , 3 under that sub-total 3, 5 under that sub-total 5. What i want is to show sub-total 14 under people for exxon inc, under bp inc 17 under people etc.

  please let me know what i am missing.