Fetch method in report

Finance and Operations/AX Developer Forum
21

Hi sorry for very delayed reply… I was struck with other tasks… now I am back to this…

reg design I have developed the report in report wizard… in the design I used auto design…

reg Arun’s suggestion what is “your data source name” means?

22

How the datasources are added the relations between them.

Try to use the Generated Design

23

I tried in generated deisng also… both are getting same only… any way I will try one more time and update you today EOD…

24

Hi,

Data source name is the name for the table in report->query->data sources->name for the table

or you can simply use datasourcetable(tablenum(table name));

The reason for your problem is you had created a new queryrun so you have to process the query run to get the desired result.

So I’m suggesting you not to create a new query run and directly add the range to “this.query( )” like

this.query().datasourcetable(tablenum(RBOTransactionTable)).addrange(fieldnum(RBOTransactionTable,TransDate)).value(queryrange(fromDate,toDate));

and use super();

instead of

while(qr.next())
{
RBOStoreTable = qr.get(tablenum(RBOStoreTable ));
RBOTransactionTable = qr.get(tablenum(RBOTransactionTable ));
RBOTransactionSalesTrans = qr.get(tablenum(RBOTransactionSalesTrans ));
element.send(RBOStoreTable);
element.send(RBOTransactionTable);
element.send(RBOTransactionSalesTrans);
}