<p>I'm a new user to BIRT and TRIRIGA, and am having some issues with my datasets. If this is a duplicate topic, my apologies. Although I've found a few variants of this question, nothing seems to provide the answer I need. </p>
<p> </p>
<p>I have a form in TRIRIGA with multiple smart sections and queries. I'm using this form as my base dataset. When I open it in BIRT, I of course see all the smart sections and custom queries (each as separate datasets) that are part of the form. Most of the reporting data I need is in the form's main v2BO dataset; however, one v2QRY has some data that I need. </p>
<p> </p>
<p>When I pull in fields from this v2QRY dataset, they always return the exact same results, regardless of what the v2BO dataset returns. There is a parameter on the v2BO dataset, which works fine. There is also a parameter on the v2QRY: system__parentRecordId. This parameter seems to not function. If I give it the parent record ID, my result set is NULL. If I leave the default value in place, I can "preview results" and see that it returns every record in the database applicable for this query. The first record in the list, is the value set that I see every time I run the report with the default v2QRY param value.</p>
<p> </p>
<p>When I view the actual form in TRIRIGA, everything seems to work fine. I see all the data properly filtered as I expect, why can I not filter the data in BIRT?</p>
<p> </p>
<p>I've seen comments about binding the v2QRY to the v2BO, but when I right-click the v2QRY there is no such option. I've tried making the default value of the v2QRY equal the parameter input for the v2BO, but again this just makes my result set for v2QRY return NULL.</p>
<p> </p>
<p>Any suggestions or assistance would be greatly appreciated. </p>
<p>Thanks</p>
<p>Rob</p>
