It's all about the answers!

Ask a question

RTC BIRT: How to get TYPE_ID relevant to {Current Project Area} in the TYPE table?

Clement Liu (1.5k54249) | asked May 19 '14, 7:38 a.m.
edited May 19 '14, 7:39 a.m.
One of the datasets in my report needs to use TYPE_ID as its parameter from user input. So I was trying to construct a report parameter by using the TYPE table. However, the table doesn't have a project area column. I tried using a filter like this because TYPE_ID string does contain the project area item_id :

TYPE_ID like '{Current Project Area}%'

But this doesn't work. The dataset returns nothing. 

Any ideas? Thank you!

Clement Liu commented May 20 '14, 3:05 p.m.

Hi, @azito, any ideas? Thanks.

Be the first one to answer this question!

Register or to post your answer.