score:0
The problem is that you are using the [Status] field value to pass to the drill down report but the way you built your first report means that this will not be available.
You have 2 ways of fixing this I think.
The quick fix:
Simply change the Status
parameter value from [Status]
to a static text value that your drill down report will accept, such as Failed
.
The longer but possibly better way...
Change the first report to be a Matrix,
Have a row group by Period
and Column group by Status
. This will save you having to setup specific expressions for each column. The other advantage is that if other Status
value where added to the data in the future such as 'In progress', 'Cancelled' etc... then these would automatically appear in the report.
The drill down Action would then be setup exactly as you have done now (in your screen shot) and only needs to be setup once.
Obviously it's your decision but if it was me, I would spend the time getting this done properly
More questions
- DrillThrough in SSRS
- SSRS DrillThrough Report to Excel From Main Report
- SSRS the definition of the report is invalid
- SSRS report definition is newer than Server
- SSRS 2008: error message saying my parameter doesn't exist but it clearly does?
- SSRS Query execution failed for dataset
- Download all SSRS reports
- SSRS 2016 - cannot see parameter
- SSRS 2012: "The report execution has expired or cannot be found. (rsExecutionNotFound)"
- Comments in SSRS Report Expressions
- What are the rules for using "Internal" parameters in SSRS
- Positioning tables and charts in BIDS SSRS
- Make hidden table column take no space in SSRS 2008 R2
- SSRS - Determine report permissions via ReportServer database tables?
- SQL Server - SSRS - Where to find query generating the report
- How to automate report delivery in SSRS
- "An item with the same key has already been added" Error on SSRS When Trying to Set Dataset
- Caching vs Report Snapshot in SSRS
- No fields for dynamic SQL stored procedure in SSRS with SET FMTONLY
- SSRS Update Data Sources always reports "The password is not valid. Please retype the password."
- SSRS Count Distinct Fields!B.value Where Fields!A.value =
- SSRS report subscription ended with an error
- Examples of great looking SSRS pdf reports
- Custom Authentication (Security Extension) with SSRS 2016
- SSRS report not displaying data
- Display date in MM-dd-yyyy format SSRS report
- SSRS report files (.rdl) how to upgrade to latest?
- How to configure/Enable the form based authentication in SSRS 2008 RS
- In SSRS is there a way to copy formatting between cells?
- converting date from mm/dd/yyyy to dd/mm/yyyy in SSRS
More questions with similar tag
- SQL Server : DATEDIFF Start and End date
- Splitting a massive table into 10+ 1 to 1 tables
- Calculate the Last Day in the CURRENT quarter
- MS SQL Server: Best Practice to run the same code on multiple tables with identical structure
- Liquibase error when changeset uses runWith=sqlcmd
- Can't insert HOST_NAME as default
- How to insert values into two SQL Server tables updating primary key and foreign key simultaneously, using a procedure?
- 1:1 Foreign Key Constraints
- Searching the existance of one column or another gives me an error
- Understanding Classic ASP
- My login function not working
- How to execute a "INSERT INTO" query to a remote database with linux command line?
- Connecting jQuery with the SQL Server Database
- Insert from java into SQL Server appends 'null'
- SQL ERROR : Column already has a DEFAULT bound to it
- How can I make this query sargable?
- Making remote database backup into local folder
- Join two columns in one table to a column in another reference table
- Pass XML from C# to SQL Server
- python pandas read_csv boolean as string
- hash a SQL row?
- How does a large transaction log affect performance?
- Inserting a row in identity column of table variable
- Move Child Rows to new Parent FK ID?
- Set table based on stored procedure parameter
- Creating SQL Database Table in C# using the existing Model class
- SQL convert compatibility matrix into mapping table (columns into rows)
- SQL Server 2012 query blocked with LCK_M_IS
- How can I use the values Selected in a While Exists statement inside the While loop?
- Insert into Select does not insert the same data order correctly