Problem uploading DataSet - SQL Server Forums

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.

All Forums

Development Tools

Reporting Services Development

Problem uploading DataSet

Author

Topic

cjpsx
Starting Member

34 Posts

Posted - 2006-05-30 : 15:20:49

When I upload my report to the report server I get this error stating that there is a problem an object? What can I do to fix this???

An error has occurred during report processing. (rsProcessingAborted) Get Online Help
Query execution failed for data set 'dsPremBillInd'. (rsErrorExecutingCommand) Get Online Help
Invalid object name 'premDetail'. Invalid object name 'premDetail'. Invalid object name 'premDetail'.

Please save my sanity,
cj

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-05-30 : 15:28:19

The report is unable to get to a database object.

Go to http://ReportServerName/Reports

Check out the configuration of the data source.

Tara Kizer
aka tduggan

cjpsx
Starting Member

34 Posts

Posted - 2006-05-30 : 21:56:11

The data source appears to be the same but when I upload the report, I do have to change it to the shared data source created on the server. Both sources point to the same database. What is the difference?

Is there a difference between how data sources must be handled between uploading from the server and uploading from visual studio?

I do notice that out of the three reports with the same data source, the one report with parameters works. What does that mean? They appear to be set up the same.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources