[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [Newsgroup Home]
[news.eclipse.birt] Dynamic column in dataset

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