SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Easy reporting Problem !!


Easy reporting Problem !!

Author
Message
rk1980factor
rk1980factor
SSC Eights!
SSC Eights! (965 reputation)SSC Eights! (965 reputation)SSC Eights! (965 reputation)SSC Eights! (965 reputation)SSC Eights! (965 reputation)SSC Eights! (965 reputation)SSC Eights! (965 reputation)SSC Eights! (965 reputation)

Group: General Forum Members
Points: 965 Visits: 101
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.
Attachments
myreport.xlsx (30 views, 12.00 KB)
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search