Limit number of records in axapta reports

This question is not answered

I have developed a report on axapta report designer and i need to limit the number of records upto 30 records per page can anyone know how to do it ?

All Replies
  • Hi,

    You can do this by customizing the fetch() method of your report.

    basically you loop through your query and add this piece of code :

    int cpt = 0; 
    ;
    While (queryrun.next())
    {
        if (cpt && cpt mod 30 == 0)
        {
            element.newPage();
        }
        // your custom code with element.send(queryrun.get(tablenum(YourTable)) ...
        
        cpt++;
    }