How to pass a database name as a parameter in SSRS report

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

Hello Everyone,

Could anyone explain, how to pass different database names as a parameter in SSRS report. I need to use 4 database names in my SSRS report to select appropriate database and fetch the desired report.

Posted 23-Nov-14 22:45pm

Pratik Prakash

Add a Solution

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Praneet Nadkar · Accepted Answer · 2014-11-23T22:52:00

Solution 1

Hi,

Check this out :http://www.keepitsimpleandfast.com/2012/08/how-to-use-dynamic-data-sources-in-your.html[^]

Posted 23-Nov-14 22:52pm

Praneet Nadkar

Shweta N Mishra · Accepted Answer · 2014-11-23T22:54:00

set a parameter with multiple values and those values would be name of database.

based on the name of database you get from your parameter, connect to each of your table to that DB, your SP will be a dynamic SP

e.g.

SQL

Create Proc GetValies(@DB as Nvarchar(50))
As
BEGIN
	Declare @SQL Nvarchar(max)
	set @SQL='select * from '+@DB+'.dbo.TableName'

	exec Sp_Execute @SQL
END

How to pass a database name as a parameter in SSRS report

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

How to pass a database name as a parameter in SSRS report

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us