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