SSRS - Dynamically changing parameters in the linked report

1
votes

I want to know how to change the parameters of the linked report and still they are dynamic. Here is an example, the actual report has a date parameter that is set to populate first day of the month dynamically. I create a linked report and now I want that date parameter to populate first day of the week dynamically.Can you please help me on how to do this in SSRS.

Thanks.

1
reporting-services

1 Answers

0
votes

In the Parameter's Properties' Default Value tab, 

=DATEADD("d", 1 - DATEPART("w", TODAY), TODAY)

The DatePart function for Day of the Week("w") is system dependent - it relies on the setting in your computer to determine what the first day of the week is. I believe the default is Sunday. If you want Monday to be the first day for your report, change the 1 to 2 in the expression.