One of our clients use SharePoint Online & uses a simple lists-based case management system. They want to receive weekly report in email based on the data in lists, preferably using configuration (or designer).
I see there are two components here, actual reporting engine capable of talking to Online SharePoint (preferably in cloud) & second would be a scheduled workflow to shoot email if engine already does not do this.
I searched a lot for solutions from likes of Bamboo or hosted SSRS, but could not find anything for SharePoint Online.
Has anyone come across any product or useful strategy in this regard.
My last option is Custom Workflow using Visual Studio which will dump static data in excel/pdf/html & send it as an attachment.