[news.eclipse.birt] Re: Dynamic column in dataset

[Rafal Wojtowicz <rwojtowicz@xxxxxxxxx>]

Sly,
 So you have made a dataset which returns only one string field with 
the sql select query inside? If so, It will be hard to use it, because 
you also have to 'tell' Report Engine about each column specification in 
dataset and after that create bindings to the table in report. I think 
it's better to just make a static query which retrieves maximum possible 
number of columns (if you don't know how many will be there) and then 
set visibility to false on columns, which contain null values.



Sly pisze:
> Hi Rafal,
>
> Thanx for your answer. But in fact my problem is that I want this result 
> in a dataset and not in a crosstab or a cube.
> So I have made a dataset which build the right query to obtain the 
> wanted result (the resul of the dataset is just one cell with the query 
> text).  My problem is that I don't know how execute this query to have a 
> new dataset with the final result.
>
> Sly