Limit the number of rows loading in Ax 2009 AOT Report according to some condition

Write code on Report Fetch method

public boolean fetch()
boolean retCode = false;
ReportValidation bankAccountTableRec;
QueryRun qrun;
int a=1;
int counter = 0;

// Use the queryRun object that is associated with the
// report; element refers to the report.
qrun = new QueryRun(element);

// Verify that the report dialog works.
if (! qrun.prompt())
return retCode;

// Loop through each record from the data source query of the report.
while (
// Get the BankAccountTable fields from the query record.
bankAccountTableRec = qrun.get(TableNum(ReportValidation));

if (counter && counter mod 1 == 0)
// your custom code with

retCode = true;

// retCode = super(); // Do not call super() when you override the fetch method.
return retCode;



Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s