Shape Page location in reports

[deg286@gmail.com]

Is there a way to add shape page locations to the shape reports? eg I have an 8 page drawing and when the client is reading the shape report (Equipment List), they would like to know which page of the drawing to refer to for each shape?
Thanks

[Croc]

As I understand, it is impossible to directly output the page name to the report. But there are many workarounds:
1. You can change the shapes, add the Shape Data row with the PAGENAME() function. The Shape Data value can be included in the report. Maybe you can use for this some of the available existing fields.
2. You can make paginal reports, then merge them into one file. In this case, there is no need to modify the shapes. You can write a macro to automate the output and merge reports.
3. You can make a report using your own macro without using VisRpt Add-On. The macro should go through all the pages, all the shapes on each page, select the necessary fields and place them in the Excel file.
Option 1 would be the most logical and so it was necessary to do from the very beginning.
Option 3 may be the easiest to program. (If it does not require complex filters to select the desired shapes).

[Paul Herber]

Is the Shapes on Page report of any use to you in my Visio Utilities:
https://www.paulherber.co.uk/visio-utilities/

[tomscrace@gmail.com]

Can you add the PAGENAME() function in a Data Set then apply it to the shape or does this have to be added via the Shape Sheet?