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: ReportGrouping.zip (642 kb)