Skip to main content
1-Visitor
July 24, 2019
Question

how to define report template to publish the results using a customized excel template

  • July 24, 2019
  • 1 reply
  • 2763 views

Hi 

I need to export the attributes of a particular "BOM part", it's associated attachments (like specifications, guidelines...) and it's BOM (if it is as assembly).

 

The sample format that I am attaching herewith.

 

I know that Report builder can generate  a nice report with all info needed. But from there to bring to this format, I need to build macros inside Excel. 

 

But is there any document/method to take query report definitions and pass to some script to generate this report?

or directly (without going through query builder?). 

 

Thanks

Ravi

1 reply

Marco Tosin
21-Topaz I
21-Topaz I
July 24, 2019

Take a look at this article.

 

https://www.ptc.com/en/support/article?n=CS162869

 

Marco
rsingaram1-VisitorAuthor
1-Visitor
July 26, 2019

Thank you Marco.

 

But I want to Right Mouse Button menu click (of a BOM Part) from within Windchill UI and export. 

 

I am looking for this function example (if any available) .

 

Alternately, I have already have configured a Report template (through report building). The export is a generic one showing all rows and columns. Is there any way to customize here to generate to custom xl format.

 

Thank you,

-Ravi