Preview on last page of report

[svines]

I have an incredibly large report that users view and print daily (thousands of pages). They need to view the last page of the report first before printing it to verify the summary info. For non-technical reasons I'm unable to change the report layout (ie. how info is displayed, amount of info, etc.). Is there a way using OpenArgs or report properties to display the last page of the report when it is previewed?

I don't want to use the On Open() event to move to the last page, because it will first take X minutes to open the report, and then another X minutes to move to the last page. I want to start on the last page of the report so user only has to wait X minutes, not 2X minutes.

I suspect the answer is that it's not possible, but thought I'd ask the experts.

TIA,
Steve.

 

[batteam]

Don't know if this will help much, but, if you know the last page number of the report, you can do a Ctrl + P once the report is displayed on the user's monitor. This will open up a dialogue box that will let you enter the last page of the report so you can PRINT that page only. This way you can view it before you have to print the whole thing. But, again, this would only work if you know the page number of the last page or two (or three, etc).

Don't the scroll selector buttons at the bottom of the page report on the monitor let you 'Jump' back to the last page so you can view it?

Good Luck.

 

[GingerR]

Could you make a separate report which has just the summary info on it, and open that one first? Then if the user likes it, they hit maybe a custom menu item to open the 'real' report.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[ElSteveO]

You can copy and rename the report, then make the detail section invisible, so it prints only the footer, assuming the footer has summarys that they're looking for. If the report looks good then they just print the whole thing.
Steve

 

[svines]

Appreciate all your suggestions, but unfortunately I can't use them...

1) batteam - using the scroll buttons or goto page features misses the point - the problem with it is that it's a long report, so it takes a long time to open the report, and the same amount of time to go to the last page. This is the reason why the users are PO'ed in the first place.

2) GingerR & ElSteveO - long story but the licencing of the "application" doesn't permit adding reports (don't ask why) - I can only modify existing.

However this leads me to ask: Is it possible to programmatically hide/unhide detail section of a report while it's being previewed?

 

[GingerR]

is it that ADP thing? if it is, or is something similar, i have to say I'm SORRY up front.

Anyhow, try this: In the REport's code sheet, put this right after the Option Compare Database line:

Public ViewDetailSection As Boolean


Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    Cancel = Not (ViewDetailSection)
End Sub

Private Sub Report_Open(Cancel As Integer)
    If MsgBox("Do you want to see the entire report?", vbYesNo, "Status") = vbYes Then
        ViewDetailSection = True
    Else
        ViewDetailSection = False
    End If
    
End Sub

This asks the user if they wanna see the whole thing or not, and based on their decision, it cancels the detail section or not.


Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[svines]

Hey, we're getting close! Will this dialog box display before the report can be viewed, or after? Ie. is it modal or does it allow the user to review the summary figures then click Yes?? Will test later today or tomorrow, thanks!

 

[GingerR]

try it out and see

it pops up OnOpen of the report. If they click yes, it shows the whole report. If they click no, it rips out the detail section.

So if they first say NO, so the detail section isn't visible, they'd have to then close the report, and open it again saying YES.

Maybe this isn't exactly what you are looking for, but should send you in the right direction.

g

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[svines]

Thanks GingerR. I think I'll go ahead and implement this, it should at least decrease the complaints. Hopefully.

 

[PaulBricker]

I wrote an FAQ on this that is right here in the Access Reports forum. I really didn't think many people would have a need for it but I posted it anyway.

faq703-3270


Hope this helps.

Paul