Topic: Column Header....

Dear Friends,

lets say i have a several records containing a date which is is assigned to a certain Course id.

e.g.  2.4.2018, 3
        5.4.2018,2
        8.4.2018,3

I want these dates to be the column header depending on the course id i chose

if i chose course 3 the Headers should be 2.4.2018   8.4.2018

I'm stuck... probably i just have a problem to see the wood, although im standing right in the middle of the forrest...


Anyone has an idea for a Script...???

Thank you

Re: Column Header....

Hello lupo ...
You could upload an example with the problem to help you ...

PS: Does that identification you refer to is assigned by the user or is it automatically assigned?

Re: Column Header....

Hello.


SQLite lacks a pivot function. You can do it by report using component a DBCross-Tab obj.

Dmitry.

Re: Column Header....

Found a Solution  using Stringlist... ;-)

Thank you for your support...