Display the number of rows based on the field value

You can use a t-sql query as below for your report dataset and display the Dept_total_Cnt field in your report

SELECT Emp_No,
Emp_Name,
Emp_Dept,
COUNT(1) OVER (PARTITION BY EMp_Dept) AS Depr_Total_Cnt
FROM YourTable

---

Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs