I'm trying to setup a schedule for a utilization report to send out an email bi-weekly with an excel attachment. I need it to be a CSV or Excel file. However when I setup the schedule it only sends a link noting "Unable to retrieve url: OURSEVER/Report.aspx CSV type.".
There should be no issue with this reporting being a CSV file. I've thrown "&Dataformat=CSV" at the end of my URL and it pulls up fine. I'm also able to manual export the report on the page to a CSV file. The report is a custom table using a custom SQl query and based on prior notes I thought these could be exported via email on a schedule.