Author Topic: Shape Page location in reports  (Read 1441 times)

0 Members and 1 Guest are viewing this topic.

deg286@gmail.com

  • Newbie
  • *
  • Posts: 1
Shape Page location in reports
« on: February 16, 2019, 10:29:08 PM »
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

  • Sr. Member
  • ****
  • Posts: 329
    • Visioport
Re: Shape Page location in reports
« Reply #1 on: February 17, 2019, 01:47:46 PM »
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

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 3301
    • Paul Herber's website
Re: Shape Page location in reports
« Reply #2 on: February 17, 2019, 03:37:49 PM »
Is the Shapes on Page report of any use to you in my Visio Utilities:
https://www.paulherber.co.uk/visio-utilities/

« Last Edit: March 22, 2022, 08:58:07 AM by Paul Herber »
Electronic and Electrical engineering, business and software stencils and applications for Visio -

https://www.paulherber.co.uk/

tomscrace@gmail.com

  • Jr. Member
  • **
  • Posts: 10
Re: Shape Page location in reports
« Reply #3 on: March 22, 2022, 08:06:14 AM »
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?
« Last Edit: March 22, 2022, 04:00:42 PM by tomscrace@gmail.com »