why only first page?

[madEG]

Hello,

I am modifying a report on a system that I inherited and am having a problem with the print preview.

The query that the report draws its data from returns six records... but the report only shows the first page of data, and I don't know why...

thoughts?

On Error GoTo Err_Preview_Click

    Dim DocName As String
    Dim f As Form
    Dim xctr As Integer

    If IsNull(Me![report name]) Then
        MsgBox "A Report must be selected"
        Exit Sub
    End If
    
    Set f = Me
    DocName = Me![report name]
    'DoCmd.OpenReport DocName, A_PREVIEW
    DoCmd.OpenReport DocName, acViewPreview
    DoCmd.SelectObject A_REPORT, DocName

Is there some property or setting in a preview or report that calls only the first page of the report to be rendered?

Help!

Thanks,
-Matt G.

 

[madEG]

...ok - the report has a picture associated with each record. When I remove the picture, so all records would fit on the first page of the report, it does happen... So the data is being returned to the report, able to be used...

...so I guess there is some setting (maybe?) that only displays the first page in a preview? Is there some way to turn that off so all the records will display, allowing me to page through them, and more importantly, so that the user can print the whole record set as laid out in the report?

Thanks,

-Matt G.

 

[madEG]

...and further, if I set the acViewNormal on the DoCMD.OpenReport, it only prints the first page - which is only as many of the records as will fit on a single page.

beginning to lose it...

This makes me think it is something with the report itself.

Thoughts?

 

[madEG]

bump.

Does anyone know why a report would only render/preview/allow to print the first page of records?

Thanks,
-Matt G.

 

[thatlem]

I'm not much for code, but if you put a button on the form where you select to print the report, you can define the report as a print preview. When you run this you can page through all the pages of the report using the page buttons located on the bottom left of the screen. I've never had a problem with it even with embeded logo's etc. Then you can print after you preview the report if you desire.

 

[madEG]

Thatlem,

Yea, that is the behavior that I expected - and I do see for the rest of the zillion reports for the app, yet, this report seems to only want to render the first page.

I know the report has access to the balance of the data (greater than the first page's data) since I can see it when I run the query that the report uses as the data source.

Further, if I flip the query (order by [fields] desc(ending)) then I see the other end of the report's records...

Totally weird.

I am confounded...

 

[thatlem]

what happens if you substitute: acCurrentViewPreview

or acCurrentView

again, just guessing - not much with code

 

[gemma-the-husky]

how does the picture get in there - perhaps the report only includes pages where it finds the picture