I'm not a WindChill Admin nor am I a user however I was asked to create a SSRS reports in SQL. The issue I'm having is figuring out what tables have the fields I'm looking for. Even with help from our seasoned WindChill Admin we are unable to trace the data viewed on the front end to the back. For example I am looking for a field the front end refers to as "Process Status" and contains text called "Running" and "Executed". I'm concerned it could be some front end calculation where it may "Interpolates" those values rather then actually storing them...which makes it even harder for me. Going forward how can we find this data ourselfves...is there a HELP menu you can activate that shows the SQL location when you hoover above the data on the front end?
In this document you can find many information on how to build a query builder report.
There are also many report ready to use (some are about Change) and link to some article that explain the name of the various table and how to join them.
You can also look at this article that collect many, but not all, the report in the document that I wrote.
Articles are divided in some logical way.