Help with SQL report formatting
Created: 06 Sep 2012 | 2 comments
SMC 7.1
I have created a report based on an SQL query and it is working as expected. My report has multiple columns (one of them being "site") and by default I can use the pulldown for "group by" to group them by site. This is obnoxious because I then have to refresh the report to get the view I want. My question is:
Is there a way to get the report to automatically group by site every time I open it?
Comments 2 Comments • Jump to latest comment
As I see it you have two main options.
1. Order By Site
2. Count
Order by will get you your sites listed together
Count will get you the ability to Group By and return a count based on the Site but you will need to build drill down reports to support it. Your standard report would be easier to manage.
I do not know of a way to have a report open automatically with the ‘Group By’ option.
If you are confident with your SQL many people just run their reports in SQLSMS and thus you would create the exact display with the query. The built in reporting tool struggles to cater to new SQL users and advanced SQL users at the same time. I think it was around this point you describe that I made that decision to write mostly on the SQL box, but your own feelings may differ.
Michael Cole
Remote Product Specialist
Business Critical Services
Would you like to reply?
Login or Register to post your comment.