I have this Query that is connected in my RDP
All data is related correctly, and i think the code is fine ( i use Queryrun)
but when i run it in my report, im only getting the first record, which is supposed to be 2 records.
FirstOnly is set to No, Query is Okay, Relations are Okay.
please see the picture for better understanding.
in coding the RDP, im using this:
query = this.parmQuery();
queryRun = new QueryRun(query);
ttsBegin;
while (queryRun.next())
{
temptable.data = Table1.name
temptable.insert();
}
ttsCommit;
please help, thanks.