Solved When saving a report to file it is saving more than one report instead of just the one i want filed (1 Viewer)

[Sam Summers]

When saving a report to file it is saving more than one report instead of just the one i want filed:-

I am using this code:

    DoCmd.OutputTo acOutputReport, "SafetyInformationCard", "", "", False, "", 0

I am using the same for another two reports which works fine and does not create additional reports within the same pdf?

Thank you in advance

Sam

 

[theDBguy]

Hi. Not sure I understand. When you say "additional reports," are you talking about multiple pages or actual reports from your database. You know, like saving Report1 and Report2 and Report3 also get saved?

 

[Sam Summers]

Hi. Not sure I understand. When you say "additional reports," are you talking about multiple pages or actual reports from your database. You know, like saving Report1 and Report2 and Report3 also get saved?

Hi there,
So i have just tested how it prints and it prints the two pages fine using this code:

DoCmd.OpenReport "SafetyInformationCard", , , ("[RiskAssessmentID] = " & Forms!ViewAllRiskAssessments![RiskAssessmentID])

But when i save to file i get this - as attached?

 

[bastanu]

It is because OutputTo method doesn't have the Where condition like OpenReport. You will have to modify the report's record source to return only one record (RiskAssessmentID) or open the report hidden then call the OutputTo with an empty report name argument (it will save the current open report):

DoCmd.OpenReport "SafetyInformationCard", , , ("[RiskAssessmentID] = " & Forms!ViewAllRiskAssessments![RiskAssessmentID]), acHidden

DoCmd.OutputTo acOutputReport, , "", "", False, "", 0

Cheers,
Vlad

 

[arnelgp]

is ok if i put the "criteria" directly to the Recordsource of the report?

 

[Sam Summers]

Thank you guys!