Hello.
IŽm a newbie in BIRT and I have a issue, related to:
I'm developing a Chart report that is using two DataSets, one is to fetch
a the Database registry that will give me a column with a sql query
script, that later will be used to substitute the default queryText of the
second dataset.
This 2nd Dataset is used to populate a chart with 2 columns.
For these I created a Report parameter "{}Key" related to the key of the
registry that I want to fetch the SQLScript, and then, I created a Cascade
Parameter called "{}SQLScript" that receives the result of the sql query
script stored in the 1st dataset.
These is working very well.
The problem is that, at the time I'm seeing the report, I don't want to
see the parameters panel and choose the only option that I will have, that
is the SQL Query Script stored in the only row that I will receive.
My question is very simple, how can I choose automaticly (validate) this
parameter that I receive and pass througth the parameters panel directly
to the report.
I tried many things like configuring the parameter as hidden. but the
problem is that, in the parameters panel ("{}SQLScript" ComboBox or
ListBox) for birt the first choice all the time is, or a blank text or
some default value that I put for this parameter.
I really would appreciate some help in these case..
Best wishes for all Birt developers or users.