Help with SQL report formatting
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?