Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
stevenc49
Starting Member
14 Posts |
 Posted - 2008-06-06 : 14:28:29
|
| Hi, I am trying to generate a report and I am using the query builder feature in SQL Server Reporting Services.I just entered a simple query (actually the query builder generated it for me):SELECT ID, pnameFROM jira393.projectand it seems to run fine but when I click "OK" to go to the next step, I keep getting an invalid object name error: 'jira393.project'I don't know what is wrong right now since when I run it, it seems to display the correct information but trying to go to the next step displays that invalid object error.Does anyone have any idea what is wrong? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-07 : 00:27:39
|
| Try followings:SELECT ID, pname FROM projectSELECT ID, pname FROM dbo.project |
 |
|
|
|
|
|
Query Builder - Invalid Object Name