Need to build the multi tenant environment with single database/datasource

[nsen]

All,

I have a application and this application reporting environment is jasper server. And this application using lot of tenant.  Our db is multitenant.  What is the way to do single report using diferent tenant and showing in the report for corresponding tenant data only. I prepare the multiple organization but I am not figuring out how to connect with same datasource for diferent organizer.  

 

Any body can you help me regarding that.

 

Thanks

 

Nilanjan

 

 

[marianol]

Put your datasource conneciton and reports in /Public so they are available for all the tenants. You can thn use the LoggedInUser Tenant ID to segregate the data in the report and if you are using domains for AdHoc do the same thing in your domain security file.