[news.eclipse.birt] Re: Chart Report - Parameter validation

[Jason Weathersby <jasonweathersby@xxxxxxxxxx>]

Luis,

Instead of using a cascaded parameter (which I assume you are using to 
gurantee your first data set is called before the charts) why not make 
one simple parameter for the key, and add a hidden table above the chart 
that uses the first dataset and in the column you want create an event 
on the oncreate to capture it in a global js variable and use it in your 
second dataset before your chart is created.

Jason

Luís Ventura wrote:
> 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.