CODEWITHSUNDEEP
parametersreportpentaho
user3437557
user3437557

Reputation: 21

pentaho report designer 5.0.1 parameter error

I'm trying to search for a record in the database whith this code:

select att_value_1
FROM BUS_ENT_INSTANCE
where bus_ent_id = 1154 and att_value_1 = ${NumeroProcesso}

On the previous version, 3.9 , this piece of code used to work but in the new version, 5.0.1, it doesn't work.

It says "The parameters provided for this report are not valid."

When I substitute the "NumeroProcesso" by a process number directly instead of using a parameter it works, otherwise this is what happens.

Any suggestions?

Upvotes: 2

Views: 1170

Answers (1)

Sebastián Vásquez
Sebastián Vásquez

Reputation: 135

Did you choose the option "Validate Values" when you've created your parameter? If yes, probably you aren't choosing a valid value.

I remember I had a problem with parameters too...and it was because the type of the parameter was incorrect. Make sure you selected the right "Value Type" for your parameter.

I hope it helps.

Regards,

Tatan.

Upvotes: 1

Related Questions