Question “The report engine seems to become occationally confused when I try to keep nested groups together.  How do I work around this?” Solution Separate your nested groups into subreports. -Main Report –Group 1 –Subreport 1 —Group 2 —Subreport 2 —-Group 3 etc… This will require you to rethink your data as you will now  Full Article…

Question “How do I group on the first letter of a field?” Solution The easiest way to accomplish this is to taylor your original SQL code to your grouping needs.  If you add a field that only selects the first letter of another field, grouping on that field is very easy from ReportBuilder.  In most  Full Article…

Question “How do I ensure that the group footer will display on every page of my report?” Solution This can be helpful if you need a page summary band, similar to the page footer band but snaps to the last detail band. Use the DetailBand.BeforePrint event to determine if the group will break before space  Full Article…