Tririga - Birt - unable to display records from mutiple queries

ashu451

<p>Hello,</p><p> </p><p>I am developing a Tririga report in Birt.</p><p> </p><p> I have query report in which all the details of the work task are retrieved.</p><p> </p><p>In my 1st subreport within main report i retrieved all the procedure and procedure steps or the task.</p><p> </p><p>In my 2nd sub report i retrieved all the assests requested for in work task.</p><p> </p><p>Luckily i am able to bind 1st subreport using edit dataset parameter binding property,</p><p> </p><p>Unfortunately my 2nd report doesnt show up any record when i bind it to the parent work tasks' record_ID</p><p> </p><p>Please guide !!</p><p>Thank you</p><p> </p>

BRM

<p>A few of things I would check:</p><p>1. Does the 2nd query retrieve records correctly when you run it with a default parameter for the work task record ID?</p><p>2. Are you including the 2nd subreport in a detail item of the 1st table so that you can bind the work task record ID to the work task record ID for the current record?</p><p>3. Do you have any data type issues here.  i.e. does your first query convert the record ID to a string and the 2nd query expects a number?</p><p> </p><p>Hope that helps</p>