How can I change the group by in a schedule report.

[Ron24]

I have about 8 group bys in 6 reports.  Is it possible to change the group by in a schedule report or does servicenow just group by on the default group by for schedule jobs.

[Community Alums · Accepted solution]

Hi Ron,

The concerned report which you are using in your scheduled job in "report" field , you will have to do "Group by" on that report itself. 

1. Navigate to System Definition > Scheduled Jobs.
2. Click New.
3. Select Automate the generation and distribution of a report.
4.  In the "Report " field select your concerned report here.

Or, if you have your scheduled job which consists of your report just change the report with the report which has group by

Mark my answer correct & Helpful, if Applicable.

Thanks,

Sandeep