Form filtered data sent to report with gantt chart for printing - Not Working

[sah]

Hi,
I have some 5 fields in a form and the same in a report. Report has an additional gantt chart kind of thing.
2 fields are start date and end date. Based on these 2 fields number of days is calculated and the chart is populated dynamically by detail_format event of report.
when i filter the form and say preview report based on Me.Filter in where condition of opening report, it shows the filtered report but while printing the same it shows all records irrespective of the form filters.

[June7]

The embedded macro must not be passing filter criteria to the report, although looks like it should. I don't use macros, only VBA. Try VBA with:
DoCmd.OpenReport "rptProjectSchedule", acViewNormal, , Me.Filter

[sah]

Tried the same but it displays a blank page. I dont have an actual printer only a virtual one using pdflite.

[June7]

Okay, this is weird. I tried printing to a real printer and didn't work either.

However, this did work:

Private Sub cmdPrintReportButton_Click()
    DoCmd.OpenReport "rptProjectSchedule", acViewPreview, , Me.Filter
    DoCmd.PrintOut
    DoCmd.Close acReport, "rptProjectSchedule"
End Sub

The report printout is cut off on the left side.

[sah]

Thanks June7,
This really solved my problem.