How can you see a hidden Datasource?

[Former Member]

Using Crystal Reports v.11.0.0.1282 I have written a report, which is running through a C++ program. I recently had to change Datasources, and now, the report will only run on the c++ program if the data is in the old datasource and not the new one. When I look at the datasource location expert, I only see the one I had just changed to. However, when I look at the dependancies I see this problem:

Error Data Source: Verify for table Command failed. Possible report corruption. C:\acclaim\reports\Invoice Support.rpt

Warning Data Source: There are unlinked tables in your report. In some cases this could lead to an excessive quantity of records. C:\acclaim\reports\Invoice Support.rpt

Also when looking at or trying to change the links, I see this error:

More than one datasource or a stored procedure has been used in this report. Please make sure that no SQL Expressoin is added and no server side group-by is performed.

How on earth can I see where the problem is. I believe as the writer of the c++ program does, that it is still referencing the old Database, but I can't see it.

PLEASE HELP!

thanks you in advance!

[Former Member]

Once you change the datasource in the crystal reports via the database expert, is it at all possible that it would look at a previously used datasource?

[Former Member]

A complicated report may have more than one datasource. Check if the report has subreports.

[Former Member]

I wrote the report, and know it does not contain subreports. It's a large report, but not complicated.

[Former Member]

If you wrote the report, you know the datasource. It must be only one then.

[Former Member]

Thanks I just wanted to be sure that there was no confusion.

[Former Member]

I have found it necessary to update each table within the datasource after changing OLE DB connections. In the Ser Data Source locations, expand the tables & that should show the linked table

[Former Member]

I am using a command with this:

SELECT * FROM BillingDetails, BillingReport, BillingTrunkDetails

WHERE BillingDetails.ReportID = {?REPORT_ID}

AND BillingReport.ReportID = {?REPORT_ID}

AND BillingTrunkDetails.ReportID = {?REPORT_ID}

[Former Member]

Hi,

You may try to clear the table as this first:

SELECT * FROM BillingDetails T0

WHERE T0.ReportID = {?REPORT_ID}

If it works, then add the other 2 tables.

Thanks,

Gordon

[Former Member]

I don't entirely understand how this will help, The comman query will execute with no problem. Are you saying you think it's the query?

[Former Member]

You need to clear up the hidden datasource. Change the Command query first. Just try it.

[Former Member]

ok I will give it a shot. But what does the 'T0.' mean? I'm not fully literate in this language.

[Former Member]

that did not work at all.

[Former Member]

Have you tried to redo connection to the database through OLEDB?

[Former Member]

this is an ODBC connection, but yes I have tried a redo of the connection.

I also can run the same query though my SQL manager, and get the results which I see in my report. There does not really seem to be a problem with my report. The problem seems to be with the program which is using it. The man which had written is, is adamant it is not his program, and I am adamant that it is not my report. However, the above errors may indicate that there is in face an error with my report. I haven't been using crystal reports for very long so it's very frustrating when there is no documentation helpful to the errors.

[Former Member]

Also, there is no reference to the previous DB/DSN in the ODBC Datasource administrator. So It wouldn't be connecting to it in any case would it?

[Former Member]

In this case, the simplest solution is recreating the report.

[Former Member]

I appreciate your sentiment, but the enormity of the report would take entirely to long.

[Former Member]

To find a hidden problem without any documentation may take even longer time.