Table transformer with Page Properties Report

Question

I have several tables in different pages using the Page Property macro and I want to see an aggregated result using Page Properties Report.

The problem is that within the Page Property, I am calculating several fields using the Table Transformer macro. When I save, the calculations are shown in the Page Property but not in the Page Property Report (in here, the columns are blank). Is there a way to fix this? I am missing something?

P.S. I want to use the Page Property Report and not the Table Excerpt Insert to show the overall view since I need some functionalities that are not possible with Table Excerpt Insert.

Page Property:

Page Property Report:

Thank you!

Stiltsoft support · Answer

Hi @Cecilia Ramirez ,

You may go to the Table Excerpt Include macro settings and check the Transpose Table option: it may be set as "Never", so you may put the "Auto" or "Always" option if your tables are mostly organized in a horizontal way.

What concerns your workaround with the Table Transformer macro, you may wrap each horizontal table in the Table Transformer macro and then in the Table Excerpt macro on top.

So, your original table is horizontal, you transpose it via the Table Transformer macro and then collect it via the Table Excerpt macro.

The Table Excerpt Include macro combines the already transposed vertical tables.

But the first option with the Table Excerpt Include macro and the Transpose Table option should help.

Cecilia Ramirez_mx5v6q · Answer

Hello, I am trying to implement this option but I am not able to show the overall table.

My problem is with the Page metadata. 
My Table Excerpt is a vertical table, but I need to show the overall view in a horizontal table. I also need to include the page metadata at the beginning of the table, when I add the page metada in the Table Excerpt, the Table Excerpt Insert gives me two tables instead of one:

I tried creating a Table Transporter to transpose the Table Excerpt Include but the result is weirder.

Am I missing something? Thanks!

Stiltsoft support · Answer

What concerns the first point, you may wrap your Table Excerpt Include macro in the Table Transformer macro and rename each column as you wish.

What concerns the second point, in the same Table Transformer macro you'll be able to list only that columns that you want to be shown on the page. The order of listing in the query defines the column order in your result report.

What concerns the third point when, for example, one table has 'Column 1' and 'Column 2' columns and the second table has 'Column 1', 'Column 2' and 'Column 3' columns, you may indeed collect these tables as two separate tables using the Table Excerpt Include macro. And then use the Table Transformer macro on top with the standard Merge preset: your table will be combined into one table. You'll get 'Column 1', 'Column 2' and 'Column 3' but for the part coming from the first table the 'Column 3' cells will be empty.

Then on top of this Table Transformer macro you place another Table Transformer macro for renaming and hiding unwanted columns (points one and two).

The Page Properties Report doesn't support other macros, your case isn't possible as it is.