Jump to content
Changes to the Jaspersoft community edition download ×

Cannot create query that needs parameter


rhayhurst

Recommended Posts

Hi.  I'm a total noob and not a Java developer.  I'm also totally desparate.

I want create a table with parameters.  This means that I the SQL must contain parameters.

In order to add parameters, the dataset needs to exist. 
In order to create the dataset, the parameters need to exist. 

Paradox.

Specifically, here are my steps.  
- I've created a report using a template that I created.
- Next, I need to create a table.  I drag the element into the "Details" band.
- The Wizard starts, which will create a new Dataset.
- I name the Dataset, and tell it to use the existing connection.
- I give the SQL, which contains syntax for parameters.  ("...WHERE logs.AccountID=$P{accountId}...)
- I get an error:  Exception... Reason: Parameter "accountId" does not exist

Of course it doesn't exist!  I haven't had the chance to create it!

Can anyone help?

 

Link to comment
Share on other sites

  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

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...