Reporting Services Data Source Types

Could someone explain to me the difference between the types of data sources available to reporting services, and the advantages and disadvantages of each please.

Shared

Private

Dynamic

Can you store a data source connection string in a configuration file to be used by a report?

Thank you

Hi,

shared -- can be used with other reports
private -- is only used by this report
dynamic -- never heard of that, I guess that means that the data source can be defined by an expression which will evaluate at runtime how the connection string has to look like.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Thanks, but can you store a connectionstring in a config file and use it as the data source?

|||No, never saw that implemented. You could access the connectionstring programmatically in the datasource, but not in the regular GUI.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de