Is there a way to supply query parameters to a SQL Server Reporting Services Report at deployment time rather than at design time

views:

149

answers:

Is there a way to supply query parameters to a SQL Server Reporting Services Report at deployment time rather than at design time

Hello,

SUMMARY: I have created a SSRS Report. I want to be able to supply parameters for the report at DEPLOYMENT time rather than just design time or runtime.

DETAILS: I want to create ONE report and deploy it multiple times with the only difference being that I want to change one of the query parameters. I do not want to prompt the user for the value.

Can this be done?

Seth

+2 A:

If you link the additional reports to the parent report you can supply different parameters. This is easier than deploying multiples of the same exact report(.rdl).

MSDN Linked Reports

Dustin Scaggs 2009-08-25 16:26:30

Exactly what I was looking for. I have a book I am using for reference on ssrs but since I didn't know what this featue was called I didn't know how to look it up. There is a whole section on Linked Reports and now I am rolling. Seth

Seth Spearman 2009-08-25 17:30:11

Yeah, linked reports are pretty cool. I actually just discovered them a few weeks ago.

Dustin Scaggs 2009-08-26 19:48:55

+1 A:

Change/modify the 'default' value for a given parameter within the Report Designer and deploy with the change.

You could also create/setup Linked Reports on the report server, assigning a different default value to each Linked Report.

John Sansom 2009-08-25 16:41:22

ansaurus

tags:

views:

answers:

Is there a way to supply query parameters to a SQL Server Reporting Services Report at deployment time rather than at design time

related questions