Designing Dynamic Reports
When designing dynamic reports:
-
Use expanded data segments for optimal performance:
-
Use functions on expanded data segments that are not placed on separate rows or columns.
-
Use multiple member selections on expanded data segments that are not placed in separate rows or columns.
-
Use single data segments only when required for formatting or calculations.
-
-
Write efficient formulas:
-
Use row or column formulas rather than cell formulas, when possible.
-
Use reference properties.
-
Use a cell reference instead of cross-axis references.
-
Remove unnecessary parenthesis from formulas.
-
-
Do not limit your report to the Grid object:
-
Add functions in text boxes that highlight specific areas.
-
Hide a grid of data in a report to highlight just the graphics.
-
-
Create report templates:
-
Leverage the power of POVs and prompting functions.
-
Design once using the Current POV and prompting functions.
-
Learn the power of Grid, User, Book, and Batch POVs.
-
-
Create reusable objects and row and column templates.
You can use Text, Image, Grid, Chart objects, and row and column templates in multiple reports.