Solved

How to id reports / queries that use specific tables

Posted on 2011-02-21
2
424 Views
Last Modified: 2012-05-11
What can I use to identify crystal report and sql server views and stored procedures that use specific tables in our databases.  Can this be done using profiler or is there a way to search all crystal reports in boe by what tables they select from (i.e. the syntax in 'view sql')?
0
Comment
Question by:conardb
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 101

Accepted Solution

by:
mlmcc earned 500 total points
ID: 34947710
There are no Crystal tools available to do what you want directly.

You can "export" a report in Report Definition Format which gives you a text file showing all about the report.  As I recall it does list the tables/views/SPs

There are 3rd-party tools that give the information.  Look at the cross reference tools
http://www.kenhamady.com/bookmarks.html#doc

mlmcc
0
 

Author Closing Comment

by:conardb
ID: 34951696
thanks
0

Featured Post

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …

724 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question