Wednesday, 21 March 2007

Finding which Crystal Reports use a PeopleSoft Query

When you modify a query that is used by one or more Crystal Reports, you need to ensure that all Crystal Reports are updated so that they run correctly when submitted via the client session. However, PeopleSoft doesn't provide a way to search the relationship between its Query object and Crystal reports i.e. it is not possible to find out which crystal reports use a specific PeopleSoft query.

The only way I have found is to do a file search on the crystal folder (usually PS_HOME\crw), and search for all .rpt files containing the query name. However, one important thing to note is that though this works on Windows 2000 server, I have not been able to do this on an XP professional machine.

1 comment:

Bren Murphy said...

Using Crystal but disappointed with lack of support - thank you for your tips!

crystal water bottle benefits