change parameter value?

dahweeds

Can I change a parameter value? Where will I best run the script?

example:
Need to run query based on different field if user checks some box.
if (params["checkedBox"] == true){
params["dataField"].value = "trueChoice";
} else {
params["dataField"].value = "falseChoice";
}

In my mind, that should set the parameter for this kind of query

"SELECT " + params["dataField"].value + " FROM database"

Also, I'd like to display the changed parameter value on the
report in a dynamic text box.

but I tried this kind of changing parameter value script in many places with no changes.

I also tried setParameterValue("dataField", "falseChoice") in a initialize script but it did not seem to work.

I could do something like this in PHP, but have not enough java/Birt experience.

Thanks in advance for any help.
From David

mwilliams

Hi David,

Can you explain this a little more? Are you wanting to change which data field is brought in by the query based off of a true/false parameter? Or are you wanting to let the user specify a field to bring in by the query? Or am I not understanding correctly at all? Some sample data might help to visualize what you're wanting. Thanks.