Video Screencast Help

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 CommentsJump to latest comment

JSpur's picture

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.

michael cole's picture

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

Principal Business Critical Engineer

Business Critical Services