Generate Multiple Reports

Multiple Reports - Slide Run Through

Multiple Reports

Video 1 (7:32)

Generating an invoice for each customer, using a "Main Form" to run a Record Set Loop (RSL) the record set loop loops through the SQL statement. The SQL statement is rendered unique by a value collected from the field. The SQL statement gets passed into the forms Public Custom Property. The code opens the Report. The reports Open Event extracts the SQL Statement from the Forms Public Custom Property. The SQL Statement is then passed into the Report's Record Source.

Video 1 (7:32)

More Info on Multiple Reports:-

... ...

Multiple Copies with different Criteria

Multiple - with different Criteria

Video 2 (3:41)

Generate multiple copies of the same report but with individual criteria for each report provided by an SQL statement. The requirement is for Reports with Ascending numbers in the Report Name.

Video 2 (3:41)

More Info on Multiple - with different Criteria:-

... ...

Change the Report's Recordsource

Change Recordsource

Video 3 (8:40)

More Info on Change Recordsource:-

Video 3 (8:40)

Generate multiple copies of a Report with individual Criteria for each Report. Demonstrates how to change the Record Source of each Report, on each iteration of the Recordset Loop.

Show how to use a Combo Box in the Report to display text from a related lookup table.

Show that the recordsource SQL statement has a different value.

Add a custom property to the form to hold the SQL Statement, the SQL Statement will be generated by a function in the Form.

The Report will then interrogate the form, grabbing the SQL Statement from the custom property.

Demonstrate how to insert Text straight into the Form Module. A Public Custom Property for holding the SQL Statement.

See how to insert text straight into the Report module, a Public Custom Property for holding the name of the Form that Opened the Report.

Shows how the Report On Open event extracts the Form name from OpenArgs.

Demonstrate how you can use the Reports Open Event to use the DoCmd.Close command to close the Form that Opened the Report.

... ...

Build the SQL Statement

SQL Statement "fSQL_ForRpt"

Video 4 (11:54)

Video 4 (11:54)

More Info on SQL Statement:-