Hello All,
We have a requirement in our project where we need to prepare the jrs report results in excel format and then share it with client.
To do this, I have created 6 reports in JRS (Report builder is at version 6.0.1). These 6 reports are to be manually run every day and then extracted into excel and there, I need to consolidate all 6 reports into one excel and then share it with client.
I need to automate this process.
So, my question is
a) Is there a way to run the JRS reports through scheduled jobs or cron jobs, etc.
b) Can we automate the extracting of JRS report results into excel sheet through a job or through some command line utilities, etc..
c) Is there a way to extract the report results into the existing excel sheet. I know that when we export the jrs report results into excel, it does give us a option to do so by giving us a link asking us to copy into excel's 'Data--> From Web' . But what I need is to know if there is an option to do this in the background through some command line, api, etc.
Thanks
Venkatesh Prasad