SCHEDULE REPORT NOT WORKING

sola2
Tera Contributor

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?

1 ACCEPTED SOLUTION

Shivalika
Mega Sage

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

 

View solution in original post

7 REPLIES 7

New Developer_S
Giga Sage

Hi @sola2 

Please check report conditions and sorting again. Please paste your scheduled job script here for further check.

These are my report conditions:

sola2_0-1743028718974.png

 

these is my scheduled job: 

sola2_1-1743028718977.png

 

 

Shivalika
Mega Sage

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

AndersBGS
Tera Patron
Tera Patron

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/