[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Newsgroup Home]
|
[news.eclipse.birt] Dynamic column in dataset
|
- From: mouton_sylvain@xxxxxxxx (Sly)
- Date: Thu, 3 Jul 2008 14:56:19 +0000 (UTC)
- Newsgroups: eclipse.birt
- Organization: Eclipse
- User-agent: NewsPortal/0.36 (http://florian-amrhein.de/newsportal)
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