Report Issue

[Suresh_Murugan]

Hi dears,
I am create one report. I have a 71 records. But I want 20 records one page. 1 to 20 first page. 2 page also 20 records but showing serial no same first page 1 to 20 any idea please help.

 

[The_Doc_Man]

1. This should have been posted in "Reports"

2. Your description of the 2nd page (which seems to be something different than you wanted) is not clear. Are you saying that the serial numbers on page 2 match the serial numbers on page 1? And at the same time, are the contents of the records on the two pages different? Or the same? That is what is unclear from your statement.

 

[Suresh_Murugan]

Limit of Row in report

I am trying to limit of row in report successfully. 1st page showing serial no 1 to 20, 2nd page showing serial no 21 to 40. But I want 1st page serial no 1 to 20. 2nd page serial no 1 to 20. (different records).

 

[stopher]

Re: Limit of Row in report

Here's one way:

- Create a text box in the detail section of your report and call it SeqTxtBox.

- Enter the following code into the report's Detail Format event:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    seqNo = seqNo + 1

    Me.SeqTxtBox = seqNo
    
    If seqNo = 20 Then
        Detail.ForceNewPage = 2
        seqNo = 0
    Else
        Detail.ForceNewPage = 0
    End If
    
End Sub

- Above this code, enter the line:

Private seqNo As Integer

Run the report in Print Preview mode.

See attached

 

[stopher]

I think this has now been cross posted here.

 

[Suresh_Murugan]

Re: Limit of Row in report

Thanks stopher
It's working

 

[pbaldy]

Threads merged since both had replies.