• 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 – report’s 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: (642 kb)

    ©2023 Point International Limited.  All rights reserved. Privacy Statement