What is the Property to set the Drillthrough or Linked SSRS Report ?

Drillthrough SSRS Report
Right Click on the field -> Choose Series Properties -> Action -> Go To Report -> Specify a Report -> Provide the necessary parameter input below

What is the Property to set the Drillthrough or Linked SSRS Report ? was last modified: October 1st, 2017 by Justin Antony

How to create a simple report ?

simple SSRS report
New -> Project -> Report Server Project -> Right click on Shared DataSet -> Add New Data Source
Right click on Report Folder -> Add New Item
In the Report Data Tool Bar -> Right Click on the Data Sources -> Select the shared Data Source which we created already
Right Click on the Data Set -> Add DataSet -> Define your query here
Drag and Drop a table
Pick the Data fields from dataset and place it on the table.
Align and format the Table Accordingly
Add header to your Report.
Save and Run the Report.

How to create a simple report ? was last modified: October 1st, 2017 by Justin Antony

Specify color for each group in SSRS Report

Specify color group SSRS Report
Highlight the row on the table of the report – > properties -> Background -> expression -> paste the following code.

=IIF(RunningValue(Fields!GROUP_DESC.Value,CountDistinct, Nothing) MOD 2 = 1, "WhiteSmoke", "White")

 

 

 

Specify color for each group in SSRS Report was last modified: October 1st, 2017 by Justin Antony

Passing dynamic date value based on day of the week to SSRS report.

Dynamic date

IN SSRS We can pass the last week Friday and current week Thursday dynamically as input parameter. You can also change the day of the week by changing the DATEADD value in the following query.

 SELECT DATEADD(DAY, -3, DATEADD(WEEK, DATEDIFF(WEEK, 0, GETDATE()), 0))
SELECT DATEADD(DAY, 3, DATEADD(WEEK, DATEDIFF(WEEK, 0, GETDATE()), 0))
Passing dynamic date value based on day of the week to SSRS report. was last modified: October 1st, 2017 by Justin Antony