Open Report with Parameters

Lesson 11 Chapter 4

This video is part of the video course:
FREE Professional & Paginated Excel Reports without Power BI

In the previous video, you have learned how to show Paginated Report in Excel to the user without VBA code, just by using the Main Menu from FREE Virtual Forms control.
But when we need to show Paginated Reports with parameters to the user we need to pass the parameters to the Report Viewer control so that it can filter the data in the Report.

In this video, I will show you how you use just 4 lines of VBA code to pass the parameters to the report.