Apex Code Development You need to sign in to do that
Don't have an account?
Diane Clayton 6 Dynamic Reports
I have a requirement to send a report once a week to individual customers the status of their open orders as an email with attached xsl formatted nicely.
I don't want to manually create a report for each customer. I had tried scheduling an apex class the creates the extract as csv and emails but the client wants it to be formatted nicely with coloured headings and not require the user to format dates
I think it would be possible to create a report of all open orders then write a scheduled apex class to run the report with the report api and filter on each customer. But would it be possible to email that filtered report and attach as xsl?
Any advice or example code appreciated.
I don't want to manually create a report for each customer. I had tried scheduling an apex class the creates the extract as csv and emails but the client wants it to be formatted nicely with coloured headings and not require the user to format dates
I think it would be possible to create a report of all open orders then write a scheduled apex class to run the report with the report api and filter on each customer. But would it be possible to email that filtered report and attach as xsl?
Any advice or example code appreciated.