Hi,

1.       Report1.rpt using dbo.table1

2.       Report2.rpt using {schema}.table2

I have to show this report in a CR Viewer. So I simply followed the MSDN documentation (http://msdn.microsoft.com/en-us/library/ms225270(VS.80).aspx) and compiled and run the reports.

Report 1.rpt shown up as expected. But, while showing Report2.rpt it throws an exception, which is given below:

The table 'table2' could not be found. Error in File C:\DOCUME~1\daniel\LOCALS~1\Temp\sample1 {97D268F4-890F-45D2-8DC8-C862D3E77E90}.rpt: The table could not be found.

When I took the preview of report2 it showed me an alert:

---------------------------

Remove Table

---------------------------

The database table "table2" cannot be found. Proceed to remove this table from the report?

---------------------------

Yes   No  

---------------------------

If I choose ‘Yes’, that’s it, all fields would be removed from the report. Rather, if I choose ‘No’, it shows up the data. However, report1 doesn’t give me any issues.

The database connection details are setting during run time.

I have searched the internet and wasted 2 days, but didn’t get a solution yet. Since ‘table2’ is owned by a schema I must admit that the issue is bound to this. Can you help me? I appreciate any help on this.