Specifying MongoDB subreport connection

[eugene.doktorov]

Hi guys,

I'm using Jaspersoft Studio 5.5.0

I have a report which connects to MongoDB database

I have a subreport which connects to a different MongoDB database

When I intergrate the subreport into the report, I need to specify an alternative connection via "Use another connection" option in Subreport withard.

I googled and found anwers for sql databases like the following: "Choose the Use another connection option and type java.sql.DriverManager.getConnection("jdbc:postgresql://localhost:5432/jasperdb5a", "postgres", "postgres")" expression in the area below

My question is: What is the expression format for Mongo DB?  

Thank you!

Eugene

[jasperUser12]

Ok, so you need to follow these 3 steps:

1. Add the jaspersoft mongodb driver jar to your build path (under project->properties->java build path->add external jar).
2. Include this code in your jrxml - <import value="com.jaspersoft.mongodb.connection.*"/>
3. Your subreport expression will be like this <connectionExpression><![CDATA[new com.jaspersoft.mongodb.connection.MongoDbConnection("mongodb://x.x.x.x:27017/xxx", "username", "password")]]></connectionExpression>

Hope that helps!