User should be able to see the updated report header based on, the value selected for the field in filter criteria of report. For e.g.<\/p>\n
Suppose, there are multiple opportunity records in Dynamics 365 and each of the opportunity record contains \u201cLost \/Open\/Won\u201d options in \u201cStatus<\/strong>\u201d field. And there is a custom report created which shows the opportunities created with \u201cLost \/Open\/Won\u201d status in last 7 days.<\/p>\n Now user usually run the report and in report header, it shows \u201cLost – Opportunities created in last 7 days<\/em><\/strong>\u201d which was a static label.<\/p>\n And client requirement is when the user made modification in filter criteria and run report at that time user should be able to see the dynamic label.<\/p>\n If the user selects Status = \u201cWon<\/strong>\u201d in filter criteria and Run Report.<\/p>\n Then in the report, the header needs to be changed to \u201cWon – Opportunities created in last 7 days\u201d i.e. dynamics report header.<\/p>\n To achieve this we have made following changes in expression of header text box:<\/p>\n Note: Here we have used the \u201cCRM_FilterText\u201d OOB parameter to get the filter criteria in report.<\/em><\/strong><\/p><\/blockquote>\n By using the above expression in header text we can set dynamics status for the report.<\/p>\n Note: This code will only work for status options without spaces.<\/em><\/strong><\/p><\/blockquote>\n We can get the specific text used in filter criteria to filter report and set it in the report as text in Dynamics 365 CRM.<\/p>\n <\/p>\n","protected":false},"excerpt":{"rendered":" Recently, we had a business requirement in which one of our clients needed some modifications in report. So as we all know, SSRS reporting tool is most widely used to make customizations in the report. Requirement: User should be able to see the updated report header based on, the value selected for the field in\u2026 Read More: Get Specific Filter Parameter Value in SSRS Report \u2013 Dynamics\u2026 »<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":12682,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16,18,19,58],"tags":[581,695,1664],"class_list":["post-12678","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dynamics-365","category-dynamics-365-v9-2","category-dynamics-crm","category-ssrs-reports","tag-dynamics-365-ssrs-report","tag-dynamics-crm-ssrs-report","tag-ssrs-report"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t![\"Get](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/08\/1Get-Specific-Filter-Parameter-Value-in-SSRS-Report.png\")
<\/p>\n![\"Get](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/08\/2Get-Specific-Filter-Parameter-Value-in-SSRS-Report.png\")
<\/p>\nFor e.g. <\/strong><\/h2>\n
Solution:<\/strong><\/h2>\n
\n
So we have used the following code in the expression:<\/h2>\n
=Replace(Split(Mid(Parameters!CRM_Fi\nlterText.Value.ToString().Trim,(InStrRev(Parameters!CRM_FilterText.Value.ToString().Trim(),\"Status\n \u201c)),Parameters!CRM_FilterText.Value.ToString().Trim().Length),\" \").GetValue(2),\";\",\", \") + \" - \nOpportunities created in last 7 days\"<\/pre>\n
![\"Get](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/08\/3Get-Specific-Filter-Parameter-Value-in-SSRS-Report.png\")
<\/p>\nConclusion:<\/strong><\/h2>\n
![\"Export](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2017\/12\/Click2Export-banner.png\")
<\/a><\/p>\n