[issue when passing parameter in jasper report (6.1.1) query]

SQL statement is wrong. please check your query.

Please declare the parameter in the query.

[Parameters in Jasper Report Server are not being taken.]

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)

[When generate the jasper report export to excel getting warning messages]

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

[When generate the jasper report export to excel getting warning messages]

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

[When generate the jasper report export to excel getting warning messages]

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.

[Jaspersoft 6.20.0 can't able to connect a DATABASE]

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

[Jaspersoft 6.20.0 can't able to connect a DATABASE]

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

 

[Jaspersoft 6.20.0 can't able to connect a DATABASE]

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.