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 |
|
tccooper01
Starting Member
4 Posts |
 Posted - 2010-08-12 : 03:50:52
|
| Help!I am attempting to create some report on a report server model. I need to create a text type DataSet, using sql. Once I have written the SQL and click on OK it attempt to load back into Design>>Data view, but fall over. It show the below error A connection cannot be made to the database. Set and test the connection string. Additional Information The semantic query is not valid. Details: Data at the root level is invalid. Line 1, post 1. The Data source work, because if I do not place an SQL script the view load correctly. I have attempted a Simple SQL SELECT * and the name of the table within the model. Still no Luck. Does anyone know what I am doing wrong or can someone point me to a tutorial etc? Thanks |
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2010-08-12 : 16:04:45
|
| can you post your query, table stucture and the error you are getting?did you try to run the error in Management studio? |
 |
|
|
|
|
|
Using SQL Script as a DataSet, using Model