How to change DataSourceReference at run time using REST API

[admin.vizexperts]

Hello All,

I am beginner in jsasper reports.

I have created a report using ireport 5.5.0 and deploy it in jasperserver 5.5.0.

I am able to run from my web application using REST API.

Now i have a requirement to chagne the datasource reference at run time.

More specific:   Currently i am using the PostgreSql as a database.

There might be requirement that i need to use MySQL (at run time) having database with same name and schema.

So, pleaes tell me how can i change the datasource reference using REST webservice.

Thanks

[hozawa]

Why don't use just create 2 reports to use as a data source- one using PostgreSQL as a resource and another using MySQL. In your report, just change the url to get the data.

[admin.vizexperts]

Thanks hozawa for your prompt reply.

I can do this, but our requirement is to call same template but with different data source as per requirement.

[hozawa]

If your look at the jrxml file, you'll find that datasource is just a data in CDATA. Have you tried parameterizing it? That way you can just send parameters to switch.

[admin.vizexperts]

I am to parameterize the queryString, but not found any info for dataSourceReference.

That we need to define at the time of deployment of report into jasperserver.

In addition i have not added any datasource at the time of deployment. I have taken a parameter for datasource.

From my web application I have passed the already added database(in jasperserver) reference to my xmlstring. But it is showing blank report.