Sql-server – Change value of SSRS report parameter based on the input of another parameter

parametersreporting-servicesreportingservices-2005sql serversql-server-2005

I have a SSRS 2005 report with three parameters: @FromDate, @ToDate and @Period. @FromDate and @ToDate default to the first day and the last day of last month, respectively.

The @Period parameter is a multi-value parameter. So if I choose for instance "Current quarter", I want the @FromDate and @ToDate to change to the corresponding values based on the input in @Period.

My problem is not getting the correct datetime expressions, but rather how to make the parameters interact with each other as desired.

Best Answer

To achieve your requirement, we need use cascading parameters in SSRS.

In your scenario, you need create the parameter @FromDate that get values from a dataset which select FromDate based on the @Period parameter. Then create parameter @ToDate that get values from a dataset which select ToDate based on the @FromDate parameter.

The following document is for your reference: https://technet.microsoft.com/en-us/library/aa337498(v=sql.105).aspx

Related Solutions

What’s the difference between an argument and a parameter

A parameter is a variable in a method definition. When a method is called, the arguments are the data you pass into the method's parameters.

public void MyMethod(string myParam) { }

...

string myArg1 = "this is my argument";
myClass.MyMethod(myArg1);

SQL update from one Table to another based on a ID match

I believe an UPDATE FROM with a JOIN will help:

MS SQL

UPDATE
    Sales_Import
SET
    Sales_Import.AccountNumber = RAN.AccountNumber
FROM
    Sales_Import SI
INNER JOIN
    RetrieveAccountNumber RAN
ON 
    SI.LeadID = RAN.LeadID;

MySQL and MariaDB

UPDATE
    Sales_Import SI,
    RetrieveAccountNumber RAN
SET
    SI.AccountNumber = RAN.AccountNumber
WHERE
    SI.LeadID = RAN.LeadID;