News:

BB code in posts seems to be working again!
I haven't turned on every single tag, so please let me know if there are any that are used/needed but not activated.

Main Menu

Generating Report in Visio 2016 fails but works in Visio 2010

Started by tverbeke, May 15, 2018, 08:36:25 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

tverbeke

Dear Forum,

I'm posting my first post because of this strange issue i'm experiencing in Visio 2016 (O365).

If we run the code below we get an error message 'report definition invalid' but if we run the exact code in Visio 2010 it works perfectly.

Any thoughts ?

I've tried the following actions:


  • putting a space between .vrd/rptOutput
  • deleteting rptOutput
  • checking the references in VBA

Public Sub RapportViso_PowerBus()
    Select Case MsgBox("Export Only this worksheet?", vbYesNoCancel, "Export Visio PowerBus Data")
        Case 6
            'YES
            Visio.Application.Addons("VisRpt").Run ("/rptDefName=\\fileserver\PRIVATE\ENG\ELEC\13-Visio\DataShapes_Stencils\Powerbus_on_page.vrd")
        Case 7
            'NO
            Visio.Application.Addons("VisRpt").Run ("/rptDefName=Q:\ENG\ELEC\13-Visio\DataShapes_Stencils\Powerbus_on_page_TotalProject.vrd")
        Case 2
            'CANCEL
    End Select
End Sub

Public Sub RapportViso_AsiData()
    Select Case MsgBox("Export Only this worksheet?", vbYesNoCancel, "Export Visio Asi Data")
        Case 6
            'YES
            Visio.Application.Addons("VisRpt").Run ("/rptDefName=Q:\ENG\ELEC\13-Visio\DataShapes_Stencils\All devices full on page.vrd")
        Case 7
            'NO
            Visio.Application.Addons("VisRpt").Run ("/rptDefName=Q:\ENG\ELEC\13-Visio\DataShapes_Stencils\All devices full on page_TotalProject.vrd/rptOutput=EXCEL")
        Case 2
            'CANCEL
    End Select
End Sub

Croc

1. Try to run the report through the wizard (Run addon / Report... / ... vrd)
2. Publish the .vrd file here.

Browser ID: smf (possibly_robot)
Templates: 4: index (default), Display (default), GenericControls (default), GenericControls (default).
Sub templates: 6: init, html_above, body_above, main, body_below, html_below.
Language files: 4: index+Modifications.english (default), Post.english (default), Editor.english (default), Drafts.english (default).
Style sheets: 4: index.css, attachments.css, jquery.sceditor.css, responsive.css.
Hooks called: 166 (show)
Files included: 34 - 1306KB. (show)
Memory used: 1056KB.
Tokens: post-login.
Cache hits: 13: 0.00177s for 26,715 bytes (show)
Cache misses: 3: (show)
Queries used: 17.

[Show Queries]