DoCmd.OpenReport "FinalReport", acViewPreview, "", "", acNormal ?
the syntax is OpenReport(ReportName, View, FilterName, WhereCondition, WindowMode, OpenArgs)
I've never seen empty strings ("") passed as parameters, plus acNormal is not a valid window mode argument. Surprised there are no error messages.
I'm assuming you have tested the query underlying the report (and for any sub reports as well) and they work OK.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.