sub make_all_reports {

  # connect to the database
  my $dbh = &_get_dbh;

  &make_summary_report($dbh);
  &make_report1($dbh);
  &make_report1($dbh);

  ...

  # close the database connection
  $dbh->disconnect;

  # return happy and healthy
  return (1);

}