Dropdown list in Excel report

[fabio.hunziker]

Hi there,

I am working on a Project in Jaspersoft Studio. One requirement is, that in one column, instead of just text there should be a dropdown list in each cell filled with data from the database.
I have looked basically everywhere but have not found an answer yet.

Does anyone know how to solve this problem?

[anish.rai]

Thank you for posting to the Jaspersoft Community. Our team of experts has read your question and we are working to get you an answer as quickly as we can. If you have a Jaspersoft Professional Subscription plan, please visit https://support.tibco.com/s/ for direct access to our technical support teams offering guaranteed response times.

[Scott Andersen]

There are a subset of Excel properties supported by Jaspersoft's Excel exporter. This does not include the properties associated with data validation.

A list of those properties is found here: https://jasperreports.sourceforge.net/config.reference.html

You may be able to  create a custom exporter that will implement these properties. You would need to write java code to implement this custom java class. Unbderstand this is a complex extension of Jaspersoft. The links below may be helpful.

The Excel properties around data validation are discussed here: https://docs.devexpress.com/OfficeFileAPI/DevExpress.Spreadsheet.DataValidation

JasperReports JAVA API is  here:  https://jasperreports.sourceforge.net/api/index.html