I'm keen to try this out but cannot create the data source. An error message stating that "expressions cannot be used in a shared data source" appears. How do I create a data source that is not a shared data source? The Solution only has Shared Data Sources.

Even the Report Wizard stalled at this, there was a warning messages saying "that a connection can not be made to the database" and that "connection string expressions cannot be tested at design time" which is fine but the "next" button would not respond and I could only go back or cancel.

How did you get around this?