Crystal SQLQueryString

I am writing some code that analyses the 700+ Crystal reports we have within our business. I am aiming to have this code evalaute the data access code for each report. I have managed to determine whether the report is using a Command, Stored Procedure or Table access to obtain the data. However, when I am retrieving the SQLQueryString property of the Report I seem to be having an adverse affect on the msdb database on our SQL Server. It appears to be causing some locking issues. Is there any other method of obtaining the SQL Command code from the Crystal Objects?In your Front End application, check if there is any property to get query
Something like

CR.GetQuery

Crystal Reports driver for SQL Server 2005

I use Crystal Reports with SQL Server 2005. Which driver (ODBC or OLEDB) should be used when connecting Crystal Reports to SQL Server 2005. Business Object support forum has an article (which is old) says to use ODBC. That it is faster than OLEDB. They have a more recent article which state to also use ODBC when upgrading Crystal Reports 8.5 to XI and connecting to SQL Server.

But then I read the OLEDB is the new interface and should be used instead of ODBC which is going away.

Which is preferred for Crystal Reports XI?

ODBC is not going away.

In general, there is no preferred interface - though 3rd party suppliers may have their own good reasons for making recommendations for users of their applications. Both APIs have their strong points. ODBC is the most widely used, but there are places where OLE DB can be a better choice. The choice depends on the needs of the application

crystal reports and business objects

Hi,

This may be a dumb question, but I haven't really been able to find an answer to it. Are Crystal Reports and Business Objects the same thing?

Also, does anyone know of any tutorials for Business Objects software online anywhere? When I google for it, I only find links on the concept of business objects and not on the software...

Thanks,
RanthalionRefer this
www.BusinessObjects.com

Cross tabs with Drill downs

Hi Guys
I need to generate a report where I need to have drill downs in a matrix(cross tab query) in Business Intelligence.
When I try to build a report using the report wizard, I can either select matrix or Drill downs and subtotals.
Can I have both of these options?

Thanks
Mita

Moving to AS forum.