I am attempting to create another dataset. I currently have two datasets under one data sources. DivisionNames, DatasetDivisions. I am now attempting to create another dataset "RollOffSummaryByWorkflow" using the following SQL statement and I keep getting error message stating: "Could not create a list of fields for the query. Verify that you can connect to the data source and that your query syntax is correct. Invalid object name 'WorkFlowCode'" The query ran successfully in SQL Server Management Studio. SELECT ServiceHistory.WorkOrderID, Route.CustType, DailyRouteEntry.Driver, Route.LineOfBusiness, ServiceHistory.Route, Worker.Worker, DailyRouteEntry.Vehicle, DailyRouteEntry.WorkDate, ServiceHistory.Status, WorkflowCode.WorkflowCode FROM WorkflowCode WorkflowCode LEFT OUTER JOIN DailyRouteEntry DailyRouteEntry LEFT OUTER JOIN ServiceHistory ServiceHistory ON DailyRouteEntry.Route=ServiceHistory.Route AND DailyRouteEntry.WorkDate=ServiceHistory.ServiceDate LEFT OUTER JOIN Route Route ON DailyRouteEntry.Route=Route.Route LEFT OUTER JOIN Worker Worker ON DailyRouteEntry.Driver=Worker.Worker ON WorkflowCode.WorkflowCode=ServiceHistory.WorkflowCode WHERE (DailyRouteEntry.WorkDate>={ts '2012-05-01 00:00:00'} AND DailyRouteEntry.WorkDate<={ts '2012-05-31 00:00:00'}) AND Route.LineOfBusiness='T' Thanks!

First dumb question -- are you using the same database in SSRS that you were using in SSMS? I've had problems in the past when I used the test server on one and the production server on the other...

I've verified that I am using the same database in SSRS as well as SSMS.

I was able to create the first two datasets without any issue.

Hi There Can you please try yourdatabasename.dbo.WorkflowCode Many thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

Hi There Can you please try yourdatabasename.dbo.WorkflowCode Many thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

Hi Syed, That was the solution! Thanks.