Hi guys. I have a report with two data source joined by a relation (LedgerTable and LedgerTrans) and I need to do something in the fetch method like:
public boolean fetch() { QueryRun qr; LedgerTrans lTrans; qr = new QueryRun(this.query()); while (qr.next()) { lTrans = qr.getNo(2); while (lTrans.AccountNum) { info(lTrans.AccountNum); //for example next lTrans; } } } But the problem is that 'next lTrans' is not allowed in joined cursor, the question is how can I access the second datasource (lTrans)? In other words, is it possible replace the below code with queries?: while select LedgerTable { ... while select LedgerTrans where LedgerTrans.AccountNum == LedgerTable.AccountNum { ... } } I wonder if somebody knows... thanks. __________________________________________________ Correo Yahoo! Espacio para todos tus mensajes, antivirus y antispam ¡gratis! Regístrate ya - http://correo.espanol.yahoo.com/ Sharing the knowledge on Axapta. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/