Skip to main content
dwilliams1-Visitor
1-Visitor
September 16, 2009
Question

Using Crystal Reports with Windchill??

  • September 16, 2009
  • 2 replies
  • 1057 views
Our IT group is standardizing on the Crystal reporting tool and has asked me to look into the best method for retrieving Windchill Data.

Is anyone currently using crystal reports to pull Windchill data?

What options do we have for querying Windchill from a crystal report?

Are there any concerns we should be aware of before heading down this path?

I read somewhere that you can output the SQL commands from a query builder report but I cannot find any further detail about this direction.

Thank you for your advice,
Dax Williams
Business Administrator, Windchill
Lifetime Products, Inc.
-<">mailto:->

[cid:image001.jpg@01CA36D5.B06BCFF0]

2 replies

pyalavarthi1-Visitor
1-Visitor
September 16, 2009
Some of the popular reporting or BI tools take xml files as input data
set for reports. If crystal reports supports that option, using Info Engine
tasks to get the data out of Windchill is one option.
Regards,
Prathap





wneuman1-Visitor
1-Visitor
September 18, 2009
Dax, when we initially made the BI tool selection for OEM use with
Windchill Business Reporting we evaluated Business Objects (the server
product, not Crystal Reports). The server product was able to consume
Query Builder output with some additional XSL manipulation through an
I*E task using the webject to execute reports. You might consider that
route, although it would be a lot easier to just use Windchill Business
Reporting.



Some customers have also gone directly at the Windchill database with
reporting tools.



Best Regards,

Bill Neuman

Director, Windchill Infrastructure and Integrations


Terms & ConditionsAccessibility statement