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

[Anup Gokhale <anupgokhale@xxxxxxxxxxxxxx>]

Sly,
Have you tried using a scripted data source? This way you can construct 
the data set at runtime to have as many columns as required. You can 
then construct a table (at runtime ofcourse) and show the data.

Regards,
Anup Gokhale

Sly wrote:
> Hi all,
>
> Maybe the subject is not very explicit, so I will try to explain what I 
> need :
>
> I have data like this :
>
> Issue   |   CustomField    |    CustomFieldValue    |
> -----------------------------------------------------
> I#1     |    CF#1          |     abcd               |
> I#1     |    CF#2          |     bcde               |
> I#1     |    CF#3          |     cdef               |
> I#2     |    CF#1          |     defg               |
> I#2     |    CF#2          |     efgh               |
> I#2     |    CF#3          |     fghi               |
> I#3     |    CF#1          |     ghij               |
> I#3     |    CF#2          |     hijk               |
> I#3     |    CF#3          |     ijkl               |
> -----------------------------------------------------
>
> And i want a result like this :
>
> Issue   |  CF#1  |  CF#2  |  CF#3  |
> ------------------------------------
> I#1     |  abcd  |  bcde  |  cdef  |
> I#2     |  defg  |  efgh  |  fghi  |
> I#3     |  ghij  |  hijk  |  ijkl  |
> ------------------------------------
>
> My problem is that i don't know the number of CustomField before running 
> this query. I have made a dataset which the result is the query which 
> allows to retrieve this final result, but my question is now how to use 
> or execute the result of this dataset ?
>
> I hope to be clear,
> Thanx,
>
> Sly