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 (qrun.next())
{
// Get the BankAccountTable fields from the query record.
bankAccountTableRec = qrun.get(TableNum(ReportValidation));

if (counter && counter mod 1 == 0)
{
element.newPage();
}
// your custom code with
element.send(bankAccountTableRec);

counter++;
}
element.printJobSettings().setTarget(Printmedium::Screen);
retCode = true;

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

}

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s