cezar_apulchro Posted November 27 Posted November 27 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 Posted November 29 Posted November 29 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 Posted Sunday at 03:38 AM Posted Sunday at 03:38 AM 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
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now