I wish to be able to open the report designer and already have the data source with credentials pointing to a SQL server database when the report designer appears on the screen. The user can then create the dataset based on the tables already available.
Thanks