Answer / Sachin Yadav

To perform a conditional sum in SSRS, you can use the IIF function along with the Sum function. Here's an example expression for calculating the sum of sales based on a condition:nn=Sum(IIF(Fields!ConditionField.Value = "Specific Value", Fields!Sales.Value, 0))

In which sql server version report builder introduced?

1 Answers  

---

How to make conditional sum in ssrs?

1 Answers  

---

What is report subscription?

1 Answers  

---

How to change parameter value inside the report?

1 Answers  

---

What is snapshot report?

1 Answers  

---

In how many ways you can invoke ssrs reports?

1 Answers  

---

What are cascading parameters in ssrs reports?

1 Answers  

---

What are click through reports?

1 Answers  

---

What are the three different part of rdl file explain them?

1 Answers  

---

Difference between Logical Page and Physical Page in SSRS.

1 Answers  

---

You want to use a perspective in an mdx query. How do you select the perspective?

1 Answers  

---

Name and describe few console utilities for ssrs?

1 Answers  

---