Query on Computed Column

gaspare

Hello,

I have this problem: I call a store procedure and it give me a table, in which I add a computed column. But I need to insert a single value from this column in my report...how can I do a query on the store procedure result?

I am a new BIRT user...

Thanks

bhanley

Are you getting all your data back into a BIRT Data Set? If so you should be able to easily apply a filter (Look for the "Filters" property when you edit the data set) to keep only the information you want after the query is executed.

Better yet, can you have the Database do your filter so that you only send backl to the BIRT layer the data you need? This will reduce the work done by the BIRT Engine in processing data and also reduce network latency as you will not take a hit transmitting a load of data you will never need to use.