We had a few issues getting to the bottom of how to add the LDAP functionality to JasperReports.

So here is how we did it:

Open ‘applicationContext-security.xml‘ which is located in:
/usr/local/glassfish3.1.2/glassfish/domains/domain1/autodeploy/jasperserver.war/WEB-INF

This is where it is if you’ve followed our earlier blog post, how to deploy JasperReports Server 4.0 on Glassfish 3.1/3.2.

If you didn’t then it’ll be located within your JasperReports directory somewhere.

Changes:

To help you find what needs to be changed, download my version of the applicationContext-security.xml file and use some file comparing software to note the changes from the original version.

There are changes on lines:

• 14: Unremarked the “ldapAuthenticationProvider” line.
• 78: Enter your LDAP host “ldap://blah.blah.co.uk:3286”.
• 83: Enter username/email address/account name here.
• 84: Enter the password to the above account on this line.
• 93: Enter the domain content ‘DC’ structure for your LDAP directory.

i.e.
DC=staff,DC=google,DC=co,DC=uk

Apache Directory Studio will help test the above configuration & help you find your LDAP host, ‘DC’ structure, using its search features.

Once you’ve made the changes to this file, start up Glassfish again and you will be able to login using your corporate account.

*Things to note, if you have a local account in JasperReports with the same name as the account that you’re trying to access from LDAP, access will only be granted using the local password that was set to this account – Not a password coming from your LDAP host.

iReport, JasperReports Server & subreports what a nightmare

It has taken far too long to work out how to get them to play nicely, so I thought I’d sum it up since I couldn’t find any complete information on how to do it.

There is partial information which I based the following on here

• Connect iReports to JasperReports Server, so you can add content.
• In the ‘Repository Navigator’ Right click on your server name and select ‘Add’ / ‘Folder’.
• Right click on the new folder and select ‘Add’ / ‘JasperServer Report’.
• Enter an ID, Name & Description for your report, the ID needs underscores instead of spaces.
• Locate the main JRXML file, I’ve select one from my HDD.
• Locate the Data Source, I’ve select one that I’ve already created on the server, its easy to create.
• On clicking finish, a dialog box ‘JRXML validation’ might pop up, this is iReports checking your main report for any subreports, it then changes any subreports links in order to reference the file in the repository. Click continue to whatever it suggests.
• Note this above part has changed your master file to point to “repo:subreport.jrxml” rather than what it referenced before, which was “subreport.jasper”.
• Now if you open out your tree you’ll notice that you’ve got a ‘Main jrxml’ and your subreport in your ‘Resources’ folder.
• If you’ve multiple nested subreports, now is the time to upload them as well, because iReports has choosen to ignore any but the first one that it found.
• Its easier to do this on the JasperReports Server side of things, find the new report in your Repository right click and ‘Edit’ it, then click ‘Controls & Resources’ / ‘Add Resource’ now upload another ‘subreport.jrxml’ file, Click ‘Next’ and give it a Name & ID, Click ‘Next’ & ‘Submit’.
• Repeat above for any other subreports.
• Switch back to iReports and Refresh your ‘Repository Navigator’ tree, in order to show the files uploaded in JasperReports Server.
• In the ‘resources’ folder right click the subreport which is referenced first in the main jrxml file & click ‘properties’.
• Hightlight and Copy with Ctrl + C the ‘Parent Folder’ line which displays, then click ‘Cancel’. In my case I’m copying the line /XX/Report1/Report1_files/Report1-Tenure.jrxml
• Once copied, Right click & ‘Open in editor’ on the ‘Main jrxml’ report in your tree.
• Highlight the subreport on the main report and click on the three dots next to the ‘Subreport Expression’ property in the properties panel.
• Replace everything after “repo: with what is copied to your clipboard. in my case I end up with “repo:/XX/Report1/Report1_files/Report1-Tenure.jrxml”.
• Click Save icon, and Right click on the Main report and write the changes back to it by selecting ‘Replace with current document’.
• Link up your other Nested subreports in the same fashion, loading each one in turn to the editor, changing their ‘Subreport Expression’ property and write the information back to the correct resources jrxml file.
• Making sure that you add “repo: before the path, as that wont be there as the nested subreport wasnt found by iReports first time around.
• Now finally you can Right click the main report and ‘Run JasperServer Report’. Your report will also work on your server.
• Other things to note, remove any refernces to ‘$P{SUBREPORT_DIR} +’ and just reference the actual subreport, otherwise it wont be able to find the file.