Solved

Query a crystal report

Posted on 2011-02-27
2
233 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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

I think the Typed DataTable and Typed DataSet are very good options when working with data, but I don't like auto-generated code. First, I create an Abstract Class for my DataTables Common Code.  This class Inherits from DataTable. Also, it can …
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

831 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