Repeat data in SSRS Report AX 2012

Finance and Operations/AX Technical Forum
1

Hi,

I need help. I would like to ask if is it possible to repeat the data to a new page (not the header) since i only have 2 record from t table1 which prints 3 pages because the other table(table1) has many records. the(table1) prints only in one page then the following pages it didn’t print anymore.

Here is the code:

select count(RecId)

from LedgerTmp

where LedgerTmp.FootPrimaryAccountCode;

totalDetailRows = LedgerTmp.RecId;

shouldBeDetailRows = roundUp((totalDetaiLRows/4),1);

totalLackingDetailRows = (shouldBeDetailRows * 4) - totalDetailRows;

if (totalLackingDetailRows)

{

for (RowCtr = 1; RowCtr <= totalLackingDetailRows; RowCtr++)

{

LedgerTmp.clear();

LedgerTmp.PageNumber = shouldBeDetailRows;

LedgerTmp.RowType = 2;

LedgerTmp.insert();

}

}

select count(RecId)

from LedgerTmp

where !LedgerTmp.FootPrimaryAccountCode;

totalDetailRows= LedgerTmp.RecId;

shouldBeDetailRows = roundUp((totalDetaiLRows/10),1);

totalLackingDetailRows = (shouldBeDetailRows * 10) - totalDetailRows;

if (totalLackingDetailRows)

{

for (RowCtr = 1; RowCtr <= totalLackingDetailRows; RowCtr++)

{

LedgerTmp.clear();

LedgerTmp.PageNumber = shouldBeDetailRows;

LedgerTmp.RowType =2;

LedgerTmp.insert();

}

}

I tried the repeat on new page in VS. but it throws an error. I guess this can be used only in row header.