SmartReports - Configuring the Report Template
1. Editing report properties
Use the Edit command in the ribbon to open the Edit Report dialog. Here you configure the report name, naming rule, data source, filters, and sorting:
| Tab | Setting |
|---|---|
| General | Report name, sheet naming logic (naming rule for worksheets) |
| Data Source | Change the report category after the fact |
| Filter | Restrict which elements are included |
| Sort | Define the order of generated worksheets |
2. Customising the sheet naming logic
Click the three dots (…) next to the Page Name Logic field. In the Name Logic Editor you can add parameters by double-click, combine them with a separator, and add custom static text:
- Maximum length: 31 characters
- Every sheet name must be unique
- Characters not allowed:
? / \ [ ] * :
3. Connecting project information
Add project-level data (project name, number, client) via Project / Element Info. Tables inserts placeholder demo values - real Revit values appear in the generated report:
Each connection creates a Named Range called PX_SingleField_N. Never rename it - doing so breaks the Revit connection.
4. Connecting category parameters
The actual report content (e.g. room name, area, number) is also added via Project / Element Info. Use the Select available fields from filter to locate parameters quickly:
5. Editing parameters retroactively
- Click the desired cell in the report template.
- Choose Edit in the context-sensitive ribbon.
- The currently linked parameter is shown - select a different one if needed.
6. Formatting the template
Once all parameters are defined, format the report using standard Excel / Tables tools (ribbon Home tab):
Or via right-click on selected cells:
7. Column widths & spacer columns
Because sub-tables share column widths with the rest of the sheet, layout conflicts can arise. As a workaround, insert spacer columns in sub-tables via Table Properties - Insert Empty Column. These appear blank on report pages and act as layout spacers:
Plan your parameter grid with spacer columns in mind before you start - this saves significant formatting time later.
Comments
0 comments
Please sign in to leave a comment.