Solved

Query a crystal report

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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Microsoft Reports are based on a report definition, which is an XML file that describes data and layout for the report, with a different extension. You can create a client-side report definition language (*.rdlc) file with Visual Studio, and build g…
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 …
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

791 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