• Access
  • Access 97
  • SQL Server
  • Visual Basic
  • Report Grouping Sample

    MS Access97 and Access 2000/XP/2003 MDB file with source code showing technique how to dynamically change report group level in compiled application. Based on following idea reports record source query have one of a fields, you want to group, aliased as GroupOn. Report has group level on this GroupOn alias. If you set alias GroupOn to other field and restart report it will be grouped by this field. To remove grouping you can set alias GroupOn to Null. Using this technique you can manipulate several group levels, add/remove group levels, change sort order.
    Furthermore the sample shows how to open MS Access report and make it window size match access main window, while window is not maximized actually.

    Download: ReportGrouping.zip (642 kb)

    2022 Point International Limited.  .