Is there a way to call a report sitting in Sharepoint Report Server, input the parameters (dates), copy the data and paste it into a worksheet?
Basically I have a report sitting in internalreports.company.com/reportserver?/Reports/RPT03+-+Daily+Sales. This then ask for From and To dates. In order to automate it and make it easier to use I want to put the dates in my Excel master so it can download a range of dates or just one, take the data, paste it in and close the connection.
Is this possible or do I need to fiddle higher up in the chain?
Basically I have a report sitting in internalreports.company.com/reportserver?/Reports/RPT03+-+Daily+Sales. This then ask for From and To dates. In order to automate it and make it easier to use I want to put the dates in my Excel master so it can download a range of dates or just one, take the data, paste it in and close the connection.
Is this possible or do I need to fiddle higher up in the chain?