l857713
-
Posts
2 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Everything posted by l857713
-
Multiple values from one column in two different fields
l857713 replied to l857713's topic in Connectors and Platforms
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.
