SQL Server Performance

Can I change the datasource for a Report model I h

Discussion in 'SQL Server 2005 Reporting Services' started by girija45701, Nov 23, 2006.

  1. girija45701 New Member

    I have created a report model (.smdl) on SQL server 2005 datasource. now i want to change the datasource to sql server 2000. The database structure in SQL server 2005 and SQL server 2000 are the same .After changing the datasource in the Report Manager I get an error while i try to run the report in the report builder. The details of the error is as follows:

    Semantic query execution failed. Invalid object name 'DBO.ADDRESSTABLEWITHUSERIDS'.
    Query execution failed for data set 'dataSet'.
    An error has occurred during report processing.

    Can anybody help me in this.

    Thanks in Advance.....
  2. Madhivanan Moderator

    In Crystal Reports, there is feature known as Verify Database which will prompt you to match the columns if there are mismatches from old and new tables. See if you find the same feature in SSRS


    Failing to plan is Planning to fail

Share This Page