[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

How to id reports / queries that use specific tables

Posted on 2011-02-21
2
Medium Priority
?
433 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 2000 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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

656 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