Daily Dynamic Learnings

Search This Blog

How to change label based on condition in a report?

IIF(First(Fields!FieldName.Value = "YourValue",

"DataSetName"),Labels!@Label1,Labels!@Label2)

Example: IIF(First(Fields!JournalType.Value = "Subcontract", "ClaimReportHeaderDS"),Labels!@SYS397,Labels!@SYS851)

About IIF : SQL Server IIF() Function (w3schools.com)

Enum’s in reports: https://robscode.onl/ssrs-use-enum-values-in-filter-expressions/

Comments

How to clear cache in VM

Clearing cache could help in some cases. Close Visual studio and other applications before attempting to clear the cache for them. In a VM navigate to the mentioned paths and clear the contents. C:\Users\Administrator\AppData\Local\Temp Below are the paths to clear cache related to Visual studio and Team foundation/VSTS C:\Users\Administrator\AppData\Local\Microsoft\VisualStudio\14.0\ComponentModelCache C:\Users\Administrator\AppData\Local\Microsoft\VisualStudio Services\7.0\Cache C:\Users\Administrator\AppData\Local\Microsoft\Team Foundation\6.0\Cache Note : The admin user would be named differently in each VM but it would start with Admin****** Depending on the version of VS the folder numbers could be as 15.0_eff6c803 or 16.0_e0fab5b4 Don't clear any other content apart from mentioned cache folders. Similarly, to clear cache corresponding to SQL is C:\Users\AdministratorAppData\Local\Microsoft\SQL Server Management Studio\18.0_IsoShell\ComponentModelCache I...

Different ways to Restart IIS

1. From Visual Studio You can quickly restart IIS express on a development environment of D365 Finance from within Visual Studio. This comes handy when you’re doing development instead of restarting the service from LCS. 2. Restart a service from LCS You can use the Restart services functionality in Microsoft Dynamics Lifecycle Services (LCS) to restart individual services that are associated with a Tier 2, Tier 3, Tier 4, or Tier 5 standard acceptance test (sandbox) environment that is deployed in a Microsoft subscription. You can use this functionality to restart the following services: · IIS · DIXF · LCS Diagnostics · Batch · Reporting Server Any user who has been added as a project owner, organization admin, or environment manager in an LCS...

Powered by Blogger

How to change label based on condition in a report?

Comments

Post a Comment