CODEWITHSUNDEEP
sqlsql-servercrystal-reportscrystal-reports-2008
Chris Halcrow
Chris Halcrow

Reputation: 32020

Crystal Reports - how do I find which reports are being used?

I need to find out which of our Crystal Reports users are actually running, so we can get rid of those that are no longer being used. I can do some kind of query of the latest jobs run on the SQL server as described here:

How to get the last run job details in SQL

However I'm not sure how I could tie that back to the actual reports. I've tried opening a Crystal Report in Crystal Reports 2008 while running a trace on the SQL server using SQL Profiler, however I don't see any database calls in the tracethat would allow me to determine the name of the report being run.

How could I find out which Crystal Reports are actually in use?

Upvotes: 0

Views: 2513

Answers (1)

craig
craig

Reputation: 26272

I usually embed a unique identifier (the report's name or ID) in either a sql-expression field or the command's query.

If the DBA finds an issue with a given query (e.g. non-performant), this approach easily identifies the source.

SQL-expression:

//{%report_name}
(
  'Daily Obstetrics Review [OB003]'
)

In the command:

SELECT  'Daily Obstetrics Review [OB003]' AS REPORT_NAME
        ...

FROM    ...

Upvotes: 1

Related Questions