Solved

Query a crystal report

Posted on 2011-02-27
2
211 Views
Last Modified: 2012-05-11
Hi,

I don't know if this is possible so I thought that I should ask the question first.
We have various crystal reports that have been created by contractors over a period of a couple of years. We have found that the indexes have not been used properly on a number of them and have caused problems with the database. Running slow etc. Is it possible to write a vb. Net application to run through each of the reports and list the tables ans the joins between each of the tables? And if so how can I do this? We have a small IT team and don't have the resource available to go through each of them.

Regards,

Ross
0
Comment
Question by:ross13
2 Comments
 
LVL 22

Accepted Solution

by:
Ido Millet earned 500 total points
ID: 34991617
There are several 3rd-party Crystal Report Documentation utilities listed at http://www.kenhamady.com/bookmarks.html
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 34992356
You can also export the report in Report Definition Format and get much of that information

mlmcc
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Well, all of us have seen the multiple EXCEL.EXE's in task manager that won't die even if you call the .close, .dispose methods. Try this method to kill any excels in memory. You can copy the kill function to create a check function and replace the …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
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…

757 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

19 Experts available now in Live!

Get 1:1 Help Now