Dynamics Community Forum Thread Details

Hello,

In my electronic reporting based on the excel template I'll have 3 grids. These 3 grids will have its own headers.

Each grid can be so long that it'll be printed on several pages and I need to repeat only the header of those grid that will jump to the next page. What is the best approach to achieve this? Also if there are no records in any grid this grid shouldn't be shown at all.

Found this approach MS suggests

https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/analytics/er-paginate-excel-reports

On the Format designer page, in the format tree in the left pane, select the Intrastat root component.
Select Add.
In the Add dialog box, select the Page component in the Excel group of components.
In the Component properties dialog box, in the Name field, enter Report page. Then select OK.
To use the Report page header component as a page header on every generated page, follow these steps:
1. Select the Report page header component, and then select Cut.
2. Select the Report page component, and then select Paste.
3. Expand Report page.
4. To force the Page component to consider this range a page header, select Report page header, and then, on the Format tab, in the Replication direction field, select No replication.
To paginate a generated document so that the content on report lines is considered, follow these steps:
1. Select the Report lines component, and then select Cut.
2. Select the Report page component, and then select Paste.
To include the report footer after report lines but before the final page footer, follow these steps:
1. Select the Report footer component, and then select Cut.
2. Select the Report page component, and then select Paste.
To use the Report page footer component as a page footer on every generated page, follow these steps:
1. Select the Report page footer component, and then select Cut.
2. Select the Report page component, and then select Paste.
3. To force the Page component to consider this range a page footer, select Report page footer, and then, on the Format tab, in the Replication direction field, select No replication.

Did somone use it for the multiple tables pagination described by me above? Also I wonder why they paginate report lines. For me only report page header shoudld be paginated.

Thanks.

Categories:

Dynamics 365 Finance

Community site session details

Electronic reporting several grids header repeating on the multiple pages

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Congratulations to our 2025 Community Spotlights

Congratulations to the December Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates