cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

We are happy to announce the new Windchill Customization board! Learn more.

How to download query builder report automatically or sent to specific email ?

vkotra
4-Participant
4-Participant
‎Jun 20, 2017 10:16 AM
‎Jun 20, 2017 10:16 AM

How to download query builder report automatically or sent to specific email ?

We are trying to automate the process of CR/CN daily reports to download to a network folder. Is there any way – Windchill can automatically download as an excel report of a custom report from query builder  ?

Labels:
0 Kudos
Notify Moderator
1 REPLY 1
MikeLockwood
22-Sapphire I
22-Sapphire I
(To:vkotra)
‎Jun 20, 2017 11:14 AM
‎Jun 20, 2017 11:14 AM

Hey Venkata - how are you?

One approach to this - which we used extensively at Alcon and now starting to do similar at Edwards - is to set up Excel with the results of running the report once (e.g. nice column formatting, charts, pivot tables, etc.etc.then configure Excel to actually generate the report - which has the effect of simply refreshing the data.  Works very nicely.  I did a PTC conference presentation on this once.

Users love it - they simple click a link within the spreadsheet to get latest data at any time - with no needed formatting or other work after.

Here is one link on PTC: https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS162869&art_lang=en&posno=1&q=report%20from%20excel&ProductFamily=Windchill%7CWPA&source=search

0 Kudos
Notify Moderator
Top Tags