• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

bVisual

  • Home
  • Services
    • How Visio smartness can help your business
    • Visio visual in Power BI
    • Visio Consulting Services
    • Visio Bureau Services
    • Visio Training and Support Services
  • Products
    • LayerManager
    • visViewer
    • Metro Icons
    • Rules Tools for Visio
    • The Visio 2010 Sessions App
    • Multi-Language Text for Visio
    • Document Imager for Visio
    • multiSelect for Visio
    • pdSelect for Visio
  • Case Studies
    • Case studies overview
    • Visualizing Construction Project Schedules
    • Visio Online Business Process Mapping
    • Nexans Visio Template
    • VRA makes the case for Prudential
    • CNEE Projects, WorldCom
    • Chase Manhattan Bank
  • News
    • Recent news
    • News archive
  • Resources
    • My session and other Visio sessions at MSIgnite 2019
    • Innovative uses of Visio Lists
    • Vision up your Visio diagrams
    • Power up your Visio diagrams
    • Mastering Data Visualization with Microsoft Visio
    • Microsoft Visio Business Process Diagramming and Validation
    • The Visio 2010 MVP Sessions
    • Visualizing Information with Microsoft Visio
    • Visio Web Learning Resources
  • Blog
    • Browse blog articles
    • Visio Power BI articles
    • Visio for Web articles
    • Visio blog on Orbus website
    • A history of messaging and encryption
  • About us
    • About bVisual
    • Testimonials
    • Bio of David Parker
    • Contact Us
    • Ariba Network
You are here: Home / Shape Design / Shape Reports / Changing Embedded Visio Report Column Headers

Published on July 31, 2011 by David Parker

Changing Embedded Visio Report Column Headers

Most Visio users should know that there is a built-in basic report writer. I use it often, but I do get frustrated sometimes. I wrote a chapter about it in my 2007 book (see https://bvisual.net/resources/visualizing-information-with-microsoft-visio/ ), where I explained how you can edit the XML of an external report to change the column headers, but this can be a bit of a pain if the report is embedded in you document. Therefore, I have written some VBA code to provide the ability to edit embedded report column headers.

For example, here is a standard report for equipment within a rack:

As you can see, there are four columns:

  • <X Location>
  • <Y Location>
  • Height in U’s
  • <Master Name>

These are the default column headers that you can select using the Report Definition Wizard. The angle brackets, “<…>”, denote that these are not Shape Data or User-defined Cells, but are one of the selected other properties.

I also grouped by then <X Location>, which is the easiest way of grouping by each Rack:

Finally, I sorted by the <Y Location> descending, because it is easier to see the correlation with the Rack elevations.

However, the header text of each these columns do not suit my report, so I want to change them. You can

I have created a small VBA project in a Visio stencil, which you can download from https://1drv.ms/u/s!AoRdXTjKEAo1im91GIZT28KeEDZk

The VBA project within the stencil includes two modules from the Visio SDK Sample Code library (modFormulaToString and modStringToFormulaForString) but also has basic classes for a report definition and report fields:

The code required a reference to Microsoft XML (my latest version is v6.0):

The Report Definitions are stored as strings within User-defined cells in the document’s ShapeSheet:

The code parses the XML text to create objects for each field in each report, then presents them in a form for you to select display names to edit.

If you save this stencil to your “My Shapes” folder (or somewhere else where your Visio looks for stencils), then you can simply open the stencil when you want to use it.

The stencil has just one public sub function, ListReports, which can be easily run from the Macros dialog

This will present a list of all of the reports within the document.

Notice that there are three columns in the Fields list box. The first column is just the display order, and the second column is the internal Name of the column, followed by the DisplayName. So, for example, the X Location column is actually known as PINXINFO internally.

You can then edit the Display Name for each of the columns, as required, and then Save the changes.

Then, when you run the report again, you will see that the column headers have been changed accordingly.

Fortunately, these changes are persisted in the report definition text, so you can use both the built-in Reports Definition Wizard and this VBA Report Enhancer whenever you like.

Print Friendly, PDF & Email

Related

Filed Under: Shape Reports, VBA, Visio 2010

About David Parker

David Parker has 25 years' experience of providing data visualization solutions to companies around the globe. He is a Microsoft MVP and Visio expert.

Reader Interactions

Comments

  1. Al Edlund says

    August 7, 2011 at 12:20 pm

    Nicely done (as always)
    al

    Reply
  2. Jeanette says

    January 10, 2013 at 2:38 pm

    Is there a way to add page number and a hyperlink to these reports?that way you go have an index that could take you to a selected item.

    Reply
    • davidjpp says

      January 11, 2013 at 5:13 pm

      You can get yor reports to display the Page number and/or Page name, but you need to add either Shape Data or User-defined cells to hold this. I would normally do this on the master of the shapes … before Linking to Data.
      The formulas are
      =GUARD(PAGENUMBER())
      =GUARD(PAGENAME())

      I create a visual index by using the “Off-page reference” shape from the Basic FLowchart Shapes stencil.

      Reply
      • Jeanette says

        January 11, 2013 at 7:18 pm

        Can you show please me an example? Thanks!

        Reply
  3. Ana says

    October 28, 2013 at 6:06 pm

    Is there any way to include in the report the different hyperlinks in the shapes?

    Reply
    • davidjpp says

      November 28, 2013 at 10:26 am

      Unfortunately not. The Visio reporting tool does not include that feature. It is fairly trivial to do in code, for example:
      Public Sub ListHyperlinks()
      Dim shp As Visio.Shape
      Dim hyp As Visio.Hyperlink

      For Each shp In Visio.ActivePage.Shapes
      For Each hyp In shp.Hyperlinks
      Debug.Print shp.Name, hyp.Row, hyp.Address, hyp.SubAddress, hyp.Description
      Next
      Next
      End Sub

      Reply

Trackbacks

  1. Updating data sources from #Visio using #MSFlow … easily! | bVisual - for people interested in Microsoft Visio says:
    August 15, 2017 at 11:33 am

    […] and export a table of values of Shape Data, User-defined Cells, size, position, and more. See Changing Embedded Visio Report Column Headers for […]

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Sign up for our newsletter

No spam. Unsubscribe anytime. Get email updates whenever we publish new blog posts.

  • LinkedIn
  • Twitter

Recent Posts

  • Displaying Visio Number Shapes data clearly
  • Using Visio Org Chart Wizard to work with Exchange Online
  • Overcoming ‘We can’t open your file in Visio because it exceeds the shape count limit’ in Power BI
  • Visio news from MS Ignite 2019
  • Clarity Videos Re-boot

Categories

Tags

Accessibility Add-Ins Connectors Data Export Data Graphics Data Import DataRecordset Data Visualizer Educational Excel FM GraphDatabase Hyperlinks Icons Icon Sets JavaScript Layers Legend Link Data to Shapes Macros MSIgnite MVP Office365 Org Chart PowerApps PowerBI PowerQuery Processes Scales Shape Data ShapeSheet ShapeSheet Functions SharePoint 2013 SQL Validation VBA Video Visio Visio 2007 Visio 2013 Visio Pro for Office365 Visio Services Visio Viewer Web Webinar

Footer

bVisual Profile

The UK-based independent Visio consultancy with a worldwide reach. We have over 25 years experience of providing data visualization solutions to companies around the globe.

Learn more about bVisual

  • LinkedIn
  • Twitter

Search this website

Recent posts

  • Displaying Visio Number Shapes data clearly
  • Using Visio Org Chart Wizard to work with Exchange Online
  • Overcoming ‘We can’t open your file in Visio because it exceeds the shape count limit’ in Power BI
  • Visio news from MS Ignite 2019
  • Clarity Videos Re-boot

Sign up for our newsletter

No spam. Unsubscribe anytime. Get email updates whenever we publish new blog posts.

Copyright © 2019 bVisual Ltd. All rights reserved. · Privacy policy · Terms and conditions