Embedded fields in continuous text

[joachimw]

As a newbie and not being a Java programmer I tried to define a simple report which basically should produce continuous text with embedded data fields. The challenge is that those data fields coming from a simple table within a data base and are not suited for a vertical nor horizontal report type.

 

Please have a look at the attached pdf, which describes my problem.

 

Your help is very much appreciated.

 

[file name=How_to_define_a_report.pdf size=22511]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/How_to_define_a_report.pdf[/file]

[svenn]

If your data base is Oracle you could write your query like this

 

(select content from c where id = 'first_name') as contenta,

(select content from c where id = 'surname') as contenta

.....

from dual

 

I expect that other databases would allow you to do something similar.

 

Then you could have a field with all your information in it

 

"I talked to " + contenta + " " + contentb + " on the phone."....

Post edited by: svenn, at: 2007/05/15 15:50

[joachimw]

Hi Svenn,

thanks for your answer. However, I can't get MySQL to accept multiple SELECT-statements. Is your example Oracle-specific?