Let user choose DataSource at runtime

[snoopyf]

Hi everybody,

I'm searching for a possibility to let the user choose the DataSource for a report when he runs it. This should be done by presenting him a drop down list of available DataSources as a Parameter.

How could this be achieved?

Thx for any hint!

Snoopy

[netti royala]

May be its not possible up to now versions what we have.future it will be possible.

[oscar16071987]

Hi guys, Maybe is too late, but maybe some dude get this trouble in a future xD

 

Finally I've found a different solution, Is quite strange. I'm sending a DataSourceID parameter...

 

And In SQL Editor something like this

  DECLARE @cDBName VARCHAR(100)

  DECLARE @iDSNumber INTEGER

 

 SET @iDSNumber = $P{DataSourceNumber}

 

IF @iDSNumber = 1 

  SET @cDBName = 'Contoso'

ELSE

  SET @cDBName = 'Fabrikam'

 

EXEC (@cDBName + '.dbo.Procedure ' + '[' + @cCustName + '], ' + @iCountry)