Scheduling the reports customer specific from a consolidate report for all customers

Abhi53
Tera Contributor

Hi Team,

 

Can anyone suggest on possibility to trigger schedules for reports per customer wise from a single consolidated report consisting of records from all customers.

7 REPLIES 7

@Abhi53 

did you get a chance to check my below comment with approach?

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Ankur Bawiskar
Tera Patron

@Abhi53 

you will have to change the report filter condition in script dynamically for each customer in loop and then trigger the scheduled report so that it includes data only for that customer, next time when the loop runs it will update the report filter condition to other customer and will include data only for that customer.

check below links and enhance

Dynamic and individual Emails based on the Report out to the Assignment groups Managers 

How to send weekly scheduled report notifications to each individual assignment group including ONLY... 

Scheduling a report for dynamic Recipients based on the table column of the report

💡 If my response helped, please mark it as correct and close the thread 🔒— this helps future readers find the solution faster! 🙏

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Thanks Ankur for your kind response.

We are on Zurich version so is it possible to achieve it via flow designer , if yes ? please suggest .