SQL Report Service 2005 Auto Filter
-
Hi all, this is my first post here. I want to know if there is any chance to create a report using SQL 2005 Report Service to mimic the Data-Auto Filter tool in Ms Excel. In this case, i want to create in matrix report.Let's say I have a dataset using this query : select p.Proj_ID, p.Division_ID, p.Division_Desc, p.Department_ID, p.Department_Desc, p.Type from project p left join Mill m on p.mill = m.org_area I have create a matric report, with P.Type in Row Area, Division_Desc in Column area and below Division_Desc I have group base on Departemen_Desc. Proj_ID in Data Area. I want to create something like combo box in the report column header to choose witch Division to shown. Is there any possible way to create such thing? Thanx for any information.