cezar_apulchro Posted November 26 Posted November 26 I'm trying to create a Jaspersoft report table with parameters but I've problems to do this, I don't having error in the creation of the report simply don't show my data of my db. I will try to pass the how I did step by step: 1 - new report in my project 2 - choice the template, define the name and finished. 3 - in the band summary I drag and drop the pallette table 4 - after customizing the table I click in the button of "Dataset and Query dialog" 5 - in this screen I put the "SELECT * FROM my_table" 6 - in this same screen I choice parameters button to create my parameters. 7 - I click in add button and edit button 8 - in the screen opened I type the name of my parameter in the field name 9 - and ok button to create the parameter. A|fter to create the parameters I open the "Dataset and Query dialog" again and I complete the mysql select with my parameters: "SELECT * FROM mytable WHERE colA = $P{paramCmpA} AND colB = $P{paramCmpB} AND colC = $P{paramCmpC}" I'll say agai my report is generated with blank page. I googled and don't find any reference of jaspersoft table with parameters. Thanks in advanced for any assistance.
Solution cezar_apulchro Posted November 27 Author Solution Posted November 27 I solved the problem, solution: 1 - create new report 2 - in main report open the Dataset and Query Dialog 3 - in the screen opened put the sql command 4 - click in the parameter button to create your parameters 5 - ok button 6 - configure your table into main report 7 - into Dataset and Query Dialog screen type only the sql select Thanks adn best regards.
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