Fix number of record per page.

[Edward]

Hi

Please show the result you would like to achieve.

Thank you.

[fkmfkm]

Hi

Please show the result you would like to achieve.

Thank you.

I have

DataBand1 (max 5 records)
HeaderBand2
DataBand2 (max 5 records)
HeaderBand3
DataBand3 (max 5 records)

I would like to limit the number of records for each databand to 5 for each page. If its more than 5 then then it will move to the next page and so on. I want all the bands to be on every page.

[fkmfkm]

Do you understand what I mean ?

[Jan]

Hello,

Add following code to AfterPrintEvent of each databand:

Code: Select all

if (mydatasource.Position > 5)mydatasource.Last();

Thank you.

[fkmfkm]

Hello,

Add following code to AfterPrintEvent of each databand:

Code: Select all

if (mydatasource.Position > 5)mydatasource.Last();

Thank you.

but this way...it stops printing immediately. I wants it to continue to the next page...5 each page till no more records...

[Jan]

Hello,

Try following:

1. Create integer variable in report dictionary;
2. In DataBand Rendering event add following script:

Code: Select all

myvariable++;
if (myvariable > 5)
{
  myvariable = 0;
  this.Engine.NewPage();
}

Thank you.

[fkmfkm]

Hello,

Try following:

1. Create integer variable in report dictionary;
2. In DataBand Rendering event add following script:

Code: Select all

myvariable++;
if (myvariable > 5)
{
  myvariable = 0;
  this.Engine.NewPage();
}

Thank you.

I have tested this method before....Edward has shown me this method before.

This method got problem..It will cause my subsequent Bands (Band2 and Band3) to be pushed away..

I want all my band1 band2 and band3 to be one every pages.....

[Jan]

Hello,

Band2 and Band3 have any joins to Band1?

Thank you.

[fkmfkm]

Hello,

Band2 and Band3 have any joins to Band1?

Thank you.

No there is no join to Band1.


I even tried without band2 and band3, the header2 and header2 also got pushed to next page.

Actually what does Engine.NewPage() actually do ? From the name of the method its doing exactly what my report does. ..Moves to New page...

[Edward]

Hi

Engine.NewPage() starts a new page, so after calling of that command next element of the report will be rendering on the new page.

Thank you.