The Continuous Page Layout (CPL) report is the most interactive type of report that we offer. Controls can grow and shrink, you can set up interactive sorting, you can set up drill-down reports in which detail data is initially hidden, and can be toggled by other items, and you can add drill-through links to other reports and to bookmark links within reports.
When you add a Page report to a project, it is an FPL report by default. To change to a CPL report, drop down the Report menu and select Convert to CPL report. The OverflowPlaceholder control disappears from the toolbox, and the page tabs disappear from below the report design surface.
Master Reports
One way in which CPL reports differ from FPL reports is the ability to create and use master reports. A master report is one that you use to add common report functionality like data, company logos, and page headers or footers, while using the ContentPlaceHolder control to designate areas where content reports can add data. In this way, you can quickly change the data source or company address and logo for an entire suite of reports in one convenient place. For more information, see Master Reports.
Themes
Both FPL and CPL reports can use themes to apply standard formatting to a range of report controls. Like using a master report, this allows you to change the look of a whole suite of reports in one place. You can specify colors for text and background, hyperlink colors, major and minor fonts, images, and constants, and then specify theme values in report control properties. When you want to change the look, you can do it all in the *.rdlx-theme file and it will apply to each report when it runs. For more information, see Create and Add Themes.
Data
CPL reports are ideal when you need to show data from different data sets, and when you do not need to control where the data appears on the page. Use data regions to display data in the report, and after the controls grow to accommodate your data, ActiveReports breaks it down into pages. For more information, see Data Sources and Datasets.
Shared Data Sources
Page reports allow you to create and use shared data sources, so that you need not enter the same connection string every time you create a report. For more information, see Shared Data Source (RDSX).
Custom Resource Locators
You can create a custom resource locator for items to use in your reports. In this way, you can locate images for reports, or even reports to use in subreports or in drill-through links. For more information, see Custom Resource Locator.
Data Regions and Report Controls
All page reports have controls that can display data differently than in section reports. You can use Sparkline and Bullet report controls for dashboard reports, plus there is a Calendar report control, and List, Table, and Matrix data regions to display your data. You can use expressions in many of the properties to determine what to display and how to display it. For more information on these and other report controls, see Page Report Toolbox.
Data Visualizers
The Image and TextBox report controls have a Data Visualizer feature that allows you to display data in small, easy-to-comprehend graphs. This is a powerful tool to really make your data pop. For more information, see Data Visualizers.
Grouping
You can group data within data regions by fields or expressions, control the scope of aggregates, and even create recursive hierarchies in data with parent-child relationships. The Level function allows you to indent by level to show these relationships visually. For more information, see Grouping Data (Page Layout).
Interactivity
Interactive Sorting
You can allow users to sort data in List, BandedList, Table, or Matrix data regions using the Interactive Sort properties of a TextBox report control. For more information, see Allow Users to Sort Data in the Viewer.
Parameters
You can add parameters to reports that allow users to select which values to display in the report. These are also useful in creating drill-through reports. For more information, see Add Parameters in a Page report .
Drill Down
You can use the Visibility settings available on report controls, data regions, table rows, and matrix row and column groups to create drill-down reports. With these settings, you can initially hide items and set a toggle item that users can click to drill into more detailed data. For more information, see Create a Drill-Down Report.
Drill Through
You can use the Action property in the Navigation settings available on text boxes, images, and chart data values to create drill-through reports that let users click links to more detailed reports with parameters. Although you can create drill-through links to reports without parameters, this may leave users searching a huge detailed report for relevant information.
Bookmark Links
You can also use the Action property in the Navigation settings to jump to a bookmark or URL.
Pagination
You can control where pages break in CPL reports using PageSize settings, as well as PageBreakBefore and PageBreakAfter properties on data regions, groups, and rectangles.