Problem to work with parameters passed to JasperSoft report.

[cezar_apulchro]

I created a report in JasperSoft studio that use a table, in this report I created a three parameters in my "Dataset and Query Dialog screen", in this same screen I've my select condition but this is not working that is:
  " SELECT *
FROM my_table
WHERE col1 = $P{param1}
    AND col2 = $P{param2} 
    AND col3 = $P{param3}".
I open the report in my JasperSoft cliking in preview button, after type the parameters an blank page is generated.
Like I sayed this problem occur only in the use of table in the report, in another report configured with the same parameters using same table this problem don't occur the report is generated fine.
How to solve this proble?
Thanks in advanced by any assistance.

[YasirShafique00]

The issue likely lies in how parameters are configured or mapped in your table's dataset. First, ensure the parameters (param1, param2, param3) are correctly passed from the main report to the table dataset. You can verify this by editing the table, checking the dataset parameters, and mapping them appropriately. Additionally, confirm that the data types of these parameters match the database columns. Test the SQL query directly in a database tool with actual values to ensure it works as expected. Finally, enable SQL debugging in JasperSoft Studio to verify if the parameters are being passed correctly in the query.

 

[shreekrishna.shankhwar]

Which version are you using ? I can only see mapping issue.

Please verify these 2 things

1. Main report  Query check

2. in table which dataset is used, Main data set or Any other dataset is created ?

3. Mapping of parameter from Main data set to Table dataset