[How to combine data from multiple sources in one report?]

Thank you. Unfortunately what I need to be able to combine are two Excel sources, so I guess I will have to look for another solution.

[How to combine data from multiple sources in one report?]

Hi, I am using the community edition of iReport and JasperReports Server 5.0.0 to try and make reports that compare/contrast data from multiple sources. For example, I might want to use statistics from two separate Excel files in a chart in one report, or maybe I would take some data from an Excel file and also some data from a database and display that information in one report. 

 

In iReport, at the top of the screen, it seems like you must select only one data source for a given report (for example, FoodMart): 

 

Additionally, it also seems like you can only connect one data source to a report in Jasper Server:

However on Jaspersoft's main site, in the "Reporting" section under "Products," it says that  "Jaspersoft reporting software takes information from one or more data sources and presents it in an easy-to-read, highly interactive format so business users can stay informed and make better." Could anyone provide some insight into this issue? Where can I find more information about how to do this? Is it only possible to use multiple data sources with the commercial version?

 

Thanks!

[How to create an Excel data source in JasperReports Server?]

 

Thank you Marianol. I have added the XML file, but I do not quite understand the last part of your comment. Do you mean that I add those attributes to the 'xlsdataadapter' tag of the XML file (i.e. property name="net.sf.jasperreports.data.adapter" value="repo:/reports/Test/XLS_Data_Adapter.xml") ?

Also does that mean that under the "Data Source" section of my report I will select "Do not link a data source"? Should I put any information about this data adapter under the "Controls & Resources" section?

[How to create an Excel data source in JasperReports Server?]

Thank you! I have added the XML file, but I do not quite understand the last part of your comment. Do you mean that I add those attributes to the 'xlsdataadapter' tag of the XML file (i.e. property name="net.sf.jasperreports.data.adapter" value="repo:/reports/Test/XLS_Data_Adapter.xml") ?

 

Also does that mean that under the "Data Source" section of my report I will select "Do not link a data source"? Should I put any information about this data adapter under the "Controls & Resources" section?

[How to create an Excel data source in JasperReports Server?]

Hi, I am fairly new to JasperServer, and I am trying to deploy a new report to JasperReports Server 5.0.0 using an Excel data source. I successfully connected my Excel file as a data source to create the report using iReport, but I do not understand how to add that Excel file to JasperServer so that I can connect it to the report on the server. When I am logged into JasperServer using the default admin accout, "jasperadmin," I right-click on "Data Sources" on the left side of the screen and then I select "Add Resource > JasperReport."  Then I see this page:

 

 

I select my local JRXML file and type the name "testPieChart," and then I select the "Data Source" button on the left, where you set up the data source connection. Then, I select the option to "Click here to create a new data source" which then brings me to this page: 

 

 

Under the drop-down menu for "type" there are options for 

• Bean Data Source
• Hadoop-Hive Data Source
• Internal Diagnostic Data Source
• JDBC Data Source
• JNDI Data Source
• Mongo DB Data Source
• Virtual Data Source

So, how to I create an Excel data source? Do I use one of the above types? I really need to use Excel files as data sources for my application so any help would be extremely appreciated.

Thanks!

Edit - I'm sorry about the formatting of the screen shots

 

[How to use the test databases packaged with Jasper Server?]

Thank you, that worked!

[How to use the test databases packaged with Jasper Server?]

Hi, I am new to JasperReports software, and I have downloaded the new JasperServer 5.0.0 Community Edition for my 64-bit Windows machine. I am attempting to learn how to use the iReports Designer that came included with the JasperServer package. I have been trying to follow the instructions included on this page:

 

http://community.jaspersoft.com/wiki/basic-report-creation

 

However, I am having issues on the "Define Data Source" section. I am attempting to connect to the sample "food mart" database. Here is a screenshot of my action:

When I click test I get prompted to type in the password again:

So, I type "jasperdb" and then an error window pops up that says the authentification failed:

I believe that this database should be working, because when I log into my local JasperServer through my browser, I can see Analysis Components > Analysis Data Sources > Foodmart Data Source (which has "type" JDSB Data Source), and all of the information is the same

• Name - Foodmart Data Source
• Driver - org.postgresql.Driver
• URL - jdbc:postgresql://127.0.0.1:5432/foodmart
• name - jasperdb
• password - jasperdb

 

Does anyone have any insight into why I am having this issue? Do you have any advice/suggestions on how I can test iReport Designer using the sample "Foodmart" database? 
 

Thanks!