Connect to MongoDB using JasperReports Server web app

Posted on April 2, 2014 at 1:27am

I have a Mongo DB database and I want to extract data from it and produce reports in JasperReports. I've read http://community.jaspersoft.com/wiki/mongodb which discusses how to connect MongoDB to JasperReport.

However that document only gives instructions for the GUI app version of JasperReports Server, and I am using the JasperReports Server web app.

Is it possible, using the web app, for me to connect MongoDB to JasperReports? How?

 

JasperReports® Server
cabalamat's picture
cabalamat
2
Joined: Apr 1 2014 - 5:05am
Last seen: 8 years 10 months ago

I had a similar issue that I solved by the following:

  • dowload iReport Designer or jaspersoft studio from sourceforge
  • Create a Data Adapter and add your mongo database with login credentials
  • Create a JasperReports Server Connection and refer it to your own JasperReports Server instance
  • Create a new JasperReport using the Report Wizard
  • After creating your report, publish / upload it to your JasperReports Server.
  • The .jrxml file will now be visible within your JasperReports Server as a 'Topic'
  • Login and Create an Ad-Hoc-Report in your  JasperReports Server
  • Choose the Topic selection and browse to the directory that you uploaded your report to previously
  • And that should be it!

However, the problem that I encountered througout this process was that there were no fields from my mongodb visible. The Jaspersoft Studio tool Preview produced an empty report. 

My database, called shortstories, has a collection called hardbackbooks. And each row in 'hardbackbooks' contains the 2 fields, content and created_date. The query string I used when creating the report is below; Can anyone help with this JasperSoft to MongoDB syntax, please? 

{collectionName : 'hardbackbooks',
 
findFields : {
'content':1,
'created_date':1},
rowsToProcess:20
}

 

mike_28 - 8 years 10 months ago
add comment

0 Answers:

No answers yet
Feedback