I am designing a report in Jaspersoft Studio and have data arranged in the following format
Col 1 Col 2 Col 3
data 1 data 2 data 3
data 4 data 5 data 6
What I would like some help with is in writing a query that will give me the contents of Col 3 when Col 1 = data1 and Col 2 = data 2
All fields are strings.
Would greatly appreciate some help on what might be the correct syntax.
Thanks in advance.
Have you tries using PrintWhenExpression Property
This will allow you to decide when to print the contents of Column 3 , and that would be the expression you mentioned Col 1 = data1 and Col 2 = data 2
Do Let me know if you need further details on this resolve.