Report Runs in Visual Studio 2005, but Get Errors on the Server

slattbr
slattbr used Ask the Experts™
on
Have a report that runs great in the Visual Studio 2005 preview.  However when I load the rdl file on the server, and run the report from our application, I get the error below. Any ideas?

Stack Trace:
   at Microsoft.Reporting.WinForms.LocalReport.SetParameters(IEnumerable`1 parameters)
   at Ajera.RSReportViewer.SetParams()
   at Ajera.RSReportViewer.RunReport()
   at Ajera.RSReportForm.RefreshClicked(Object sender, EventArgs e)
   at System.Windows.Forms.Control.OnClick(EventArgs e)
   at DevExpress.XtraEditors.BaseButton.OnClick(EventArgs e)
   at DevExpress.XtraEditors.BaseButton.OnMouseUp(MouseEventArgs e)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at DevExpress.XtraEditors.BaseControl.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Author

Commented:
Unchecked the hidden box for the paramters and now am getting the error 'Invalid object name 'dbo.tbl_work_month'.  Have admin rights, not sure why I am getting error.

Stack Trace:
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at AjeraServer.ServerMethods.RunQuery(SessionCookie cookie, String queryText, String tableName, SqlTransaction tran, Int32 commandTimeout)
   at AjeraServer.ServerMethods.RunQuery(SessionCookie cookie, String queryText, String tableName)
   at Ajera.ClientGlobals.RunQuery(String queryText, String tableName)
On the report server click on the report > Properties > Datasource and make sure the datasource is set properly.  

Author

Commented:
Everything is fine there.  I think it has something to do with creating temp tables and passing parameters through the temp table.
Success in ‘20 With a Profitable Pricing Strategy

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
How did you install the application and the report?

mlmcc

Author

Commented:
App is on SQL Server 2008.  Report resides on same server within a folder app references.  Have other reports that work referencing the same table, that is why I think it has to do with creating a temp table in the sql and then passing parameters.
well dbo.tbl_work_month isn't a temp table?

Author

Commented:
the temp table is created by referencing dbo.tbl_work_month.

Author

Commented:
Forgot to include, also getting error:

"A data source instance has not been supplied for the data source "DataSource1"
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
When you installed the application did you use an installation file or just simply copy the files?
If you just copied the files there a several that need to be registered.

mlmcc

Author

Commented:
Used installation file.
Commented:
Spoke with company that we are running the application through.  Turns out that the table must exist within their database when pulling a datasourse.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial