Question “How do I create a table of contents sorted by page at the beginning of my report?” Solution Use a group to separate out each topic in the table of contents.  During the first pass of the report, keep track of the current page inside the OnGroupBreak event for each group, then build the  Full Article…

Question “My report columns will not all fit on one page.  How do I extend them to the next page similar to a spread sheet?” Solution This can be done using multiple subreports connected to a single dataset.  Each subreport will contain different columns of data, the second and so on containing the overflow columns.   Full Article…

TECH TIP: Creating a SubReport in Code A subreport is comprised of two objects: SubReport Control The subreport control is added to a band of the ‘parent’ report. It has properties such as ShiftRelativeTo, PrintBehavior, etc. In the Report Designer, the subreport is drawn as a rectangle. ChildReport The child report is a descendant of CustomReport and has most of  Full Article…