SQL Execution error - Creating report

• Sql Student-446896

  Default port

  Points: 1425

  More actions

  October 7, 2010 at 1:41 pm

  #227748

  Hi,

  I am a newbie and just now configured Reporting services in my laptop. However, i was trying to create a simple report with one table with 2 values using the "SQL Server Business Intellugence Development Studio" and in the step "Query Builder" i enetered this simple query

  - Select * from Customer

  This gave me the error:

  SQL Execution Error

  Executed SQL statement: Select * from cutomer

  Error cource: .net sqlclient data provider invalid object name

  Error Message: Invalid Object name 'Customer'

  I created the table Customer in the Reports DB and did a test connection and it worked.

  What do i need to do to fix this? Kindly help.

• Raunak Jhawar

  SSCoach

  Points: 15701

  More actions

  October 11, 2010 at 11:44 pm

  #1235303

  Try using a multi part identifier...such as [database_name].[schema].[table_name]

  Raunak J