- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-26-2025 02:06 PM
I have created a scheduled report, it supposed to show the open tickets from oldest created one to newst one and group it by assigned to.the report itself works and the scheduled job also works it does sent the email with the report. the problem is that the excel it sends with the report is not organized by opned date nor is it grouped by assigned to. you know why this might be? how can i fix it?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-26-2025 10:57 PM
Thanks @AndersBGS for confirming this.
@sola2 This cannot be achieved directly via excel export in servicenow. But you have this Amazing "Data filter" feature in Excel itself. You can use this and "group by" issue can be resolved from there itself.
But for sorting, I would recommend export excel in the exact sorted way you want. Because that cannot be achieved even via excel tool. For logic, if you sort any column, only that column will be sorted in Excel and other columns won't rearrange, so data will be wrong completely.
However, for group by, data filter will definitely help.
Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for the efforts and also move this questions from unsolved to solved bucket.
Regards,
Shivalika
My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194
My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeEISQCY
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-26-2025 02:39 PM - edited ‎03-26-2025 02:40 PM
Hi @sola2
Please check report conditions and sorting again. Please paste your scheduled job script here for further check.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-26-2025 03:38 PM
These are my report conditions:
these is my scheduled job:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-26-2025 03:00 PM
Hello @sola2
The excel records cannot be grouped by assigned to and sorted - these are not records but configurations. Configurations cannot be copied down to excel. The excel sheet will only contains records.
Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for the efforts and also move this questions from unsolved to solved bucket.
Regards,
Shivalika
My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194
My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeEISQCY
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-26-2025 10:33 PM
Hi @sola2 ,
As @Shivalika also have mentioned in the post, your requirement is not possible as we are talking about report configuration where excel report is basic just a list view.
If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.
Best regards
Anders
Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/