surima.tvs3

SQL statement is wrong. please check your query. Please declare the parameter in the query.

Hi, You can try like below so you can able to generate the report with dynamic and optional data. SELECT .... COLUMNS FROM .... TABLE WITH JOINS WHERE (P."CR_NUMBER" LIKE '%$P!{crNumber}%' or $P!{crNumber} is null) AND (P."NAME" LIKE '%$P!{partyName}%' or $P!{partyName} is null) AND (D."PROV_DEC_REF_NUMBER" LIKE '%$P!{provRef}%' or $P!{provRef} is null) AND (D."DEC_REF_NUMBER" LIKE '%$P!{reference}%' or $P!{reference} is null) AND (D."VERSION_RECT" LIKE '%P!{version}%' or P!{version} is null)

Even a blank report also getting error only. Anyone please suggest any solution.

Thanks for the answer. But even a blank report also getting error only. Anyone please suggest any solution.

When generate the xlsx report from Jasper using Spring boot. Report generated successfully but getting some warning messages. In the report design we have not used any group by functions and any other functions. Report is created by drag and drop the field as a simple report. Please find the below warning content We found a problem with some content in "test.xlsx". Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes. After click yes, getting the below Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded. Please suggest the steps to resolve the warning issue.

Issue solved when I connect with jdbc 9.4.0 jar file. Before i am used jdbc42 for 6.8.0 version.

Issue solved when I connect with jdbc 9.4.0 jar file. Before i am used jdbc42 for 6.8.0 version

We are trying to connect a database MSSQL from the jasper version 6.20.0 (Open source). can't connect the Database. But connections happened in jasper version 6.8.0 (licensed version). Any one of you please help us to move forward.