Expression question

[ozrebel]

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

[mbmorgan]

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

[ozrebel]

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.

[Ankur Gupta]

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/