In JasperSoft I can use multiple data sources in one report by setting a 'Virtual Data Source'. How do I do a similar thing in JasperSoft Studio?
Can it be that there isn't any way to use multiple data sources in one report in JasperSoft Studio?
2 Answers:
Hi,
currently in Jaspersoft Studio you work with Virtual Data Source only using the JRS plugin.
This means that you can define from JSS a new Virtual Data Source like you would in JRS.
In JRS user guide the is as far as I know a dedicated chapter called "Example of Creating a Domain Using a Virtual Data Source".
After that you can create you report in JSS that uses a Domain like this.
Moreover I think that in JRS you should already find a sample domain using a VDS.
It should be the one with name "Virtual DS Domain" and description "Example of combining SugarCRM and Foodmart in Domain".
Best regards,
Massimo.
Hi,
with the "JRS plugin" term, I refer to the plug-in used in JSS to deal with JasperReports Server.
Therefore, you can use it by adding a new JRS server installation in the "Repository Explorer" view, under the "Servers" node.
You can later add a new VDS using the context menu on an existing folder and then "New > Data Sources > Virtual Data Source".
Give a look at the attached screenshot.
Best regards,
Massimo.
| Attachment | Size |
|---|---|
 addnewvds.png | 118.17 KB |
Hello Massimo, and thanks very much for your answer and your time.
Now that I understant your intention, I can tell you that I did these actions before, but when I stand on the virtual data source that i created, there is no an 'import' in the popup menu that appears (while there is such an 'import' on a simple, not virtual, data source. So finnally I do not have this data source available as a 'Data Adapter' in the repository view, and hence I do not have it either in the list of available data adapters when I try to define a new report.
Maybe I miss something - so I'll be happy if you can add me on this.
By the way, I couldn't open the pbg you attached.
Thanks again,
Anat.
Hello Massimo and thanks for your reply. Can you please explain to me what is the 'JRS plugin' and where can I find it?