Answer / Nirpendra Rai

SSRS does not have a built-in Percentile function. However, you can calculate it by sorting the dataset in ascending order and then finding the nth value based on the number of records.nnHere's an example expression that calculates the 50th percentile (median) for a numeric field named Sales:n=IIF(CountDistinct(Fields!ProductID.Value,"DataSet1") MOD 2 = 1, Fields!Sales.Value(RowNumber("DataSet1", CountDistinct(Fields!ProductID.Value,"DataSet1") / 2)), Fields!Sales.Value(CountDistinct(Fields!ProductID.Value,"DataSet1") / 2))

what are the new features in SSRS?

1 Answers  

---

What is the name of reporting services config file and what’s it’s used for?

1 Answers  

---

Can You Use A Stored Procedure To Provide Data To An Ssrs Report?

1 Answers  

---

What are drillthrough reports?

1 Answers  

---

what are the different types of SSRS reports?

1 Answers  

---

You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?

1 Answers  

---

What are advantages of ssrs or why we should use ssrs?

1 Answers  

---

What is data set in report?

1 Answers  

---

In case you have filters in your report, when filters will be applied in cached report instance?

1 Answers  

---

how you can deploy an ssrs report?

1 Answers  

---

How can I add Reporting Services reports to my application?

1 Answers  

---

What are cascading parameters in ssrs reports?

1 Answers  

---