Solved

How to id reports / queries that use specific tables

Posted on 2011-02-21
2
387 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
2 Comments
 
LVL 100

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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

744 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now