Post reply

Adventureworks SSRS problem

  • August 26, 2012 at 7:01 am

    #393026

    Hi

    I installed Adventureworks SR4 in SQL 2008 R2. When i open a report in the report manager am getting the following error

    Everything going perfectly design,build,deploy but in report manager 🙁

  • August 26, 2012 at 9:38 am

    #1530116

    It says "Invalid object name: Sales.CreditCard".

    I suspect, Data Source is pointing to wrong database.

    Check the Data Source or use three part object name in the query as follows:

    select * from AdventureWorks2008.Sales.CreditCard

  • August 26, 2012 at 1:20 pm

    #1530142

    Thanks for the reply. i gave different database in the datasource now everything fine.:-)

  • August 26, 2012 at 11:59 pm

    #1530194

    Happy to know that everything fine now.

    Thanks for updating.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply