Expression question

Posted on July 1, 2014 at 3:08am

Hi

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.

Tony

Jaspersoft® Studio
ozrebel's picture
ozrebel
22
Joined: Sep 1 2011 - 9:11pm
Last seen: 6 years 10 months ago

2 Answers:

Posted on July 1, 2014 at 10:27am

I'm only familiar with SQL, but here's something that might help:

select Col3 from [TABLE]

where Col1 = Data1

and Col2 = Data2

 

Note that the syntax might depend on what datasource you are using.

Hope this helps!

M.B.Morgan

mbmorgan's picture
mbmorgan
343
Joined: Apr 14 2014 - 11:15am
Last seen: 9 years 2 months ago

Thanks for the response M.B. Morgan.
I guess I didn't make myself clear enough though.
What I was really looking for was a way to write a query in the Expression editor, as I already have an sql query which has delivered data to me in the format outlined.
Would be great to know if it's possible, or whether I have to re-write the sql to deliver the data in a different manner to start with.

ozrebel - 9 years 2 months ago
add comment
Posted on July 2, 2014 at 12:49am

Hi ,

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.

 

Thanks
Ankur Gupta 
http://ankurthetechie.blogspot.in/
 

Ankur Gupta's picture
Ankur Gupta
8864
Joined: Jan 21 2013 - 10:36pm
Last seen: 18 hours 44 min ago
Feedback
randomness