Jump to content

Recommended Posts

Posted

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.

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

  • Solution
Posted

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.

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...