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.