l857713

Thank you for your reply. I tried to transform the code myself fitting for a MySQL database, but i failed. Could you please help me out? However i think its quite unusual JasperStudio doesn't provide a solution itself, because thats a common 1 to many database with many values associated to one key. In my case: ++++++ ++++++ Key Value ++++++ ++++++ 1 A 1 1 2 B 2 2 3 C 3 3 Well i am glad for every explanation, since i'm new to all this stuff. Thanks in advance

Hello, my column has the following structure ++++++ Value ++++++ A 1 B 2 C 3 Now i have two Column Headers and two fields in my Detail Band, like this. Header 1 Header 2 $F{Value} $F{Value} What i try to achieve ist this output. Header 1 Header 2 A 1 B 2 C 3 Is there a way to accomplish this? I tried several things in SQL and the Expression Editor etc. unfortunately nothing worked. Thank you in Advance.