Hi, I created few reports with CR2008, using a connection to a table of an MDF database, attached to an instance of SQL Server 2005 Express Edition (.\SQLEXPRESS).
During the creation of the report everything seems to run smootly but when I want to preview it I get the message "Database table "tablename" cannot be found. Proceed to remove this table from the report?".
If I choose YES all the report disappears, if I choose NO the report shows correctly. I thought it was a minor problem, but when I try to use it in an .aspx page with a reportviewer control it says "The table 'tablename' cannot be found. Error in file reportname.rpt: the table could not be found." and I cant see the reports.
I tried to re-create the connections to the database using OLE DB (ADO) with a SQL Native Client Provider but the problem is still there.
In the past I used CR2008 with an MDB (Access 2003) database file for the data and an MDF database file for users and roles (ASPNETDB.MDF). All the reports I created against the Access database file are working fine and show in .aspx files without problem. This time, for a new application, I wanted to upgrade to a SQL Server database, but I encountered several new problems, like this one with CR2008.
Thanks for any help.