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…

Question “How do I detect the last detail printed in a group?” Solution Create a separate dataset that counts the values present for each group based on the grouping field.  You can then use this information to determine when the detail band has reached its final record for that group and you can make alterations  Full Article…