Displaying Dynamic Columns in SSRS Report Displaying Dynamic Columns in SSRS Report Problem: How to display selected columns dynamically in SSRS reports. Example: A report contains more than 30 fields. Some users want to see only 5 fields, some users 10 fields, and other may want to see 20 fields. Solution: Add a Report Parameter having the values as the name of all the fields of dataset. Now set hidden expression for each column of the tabular report. Here is the solution with an example : http://sql-bi-dev.blogspot.com/2010/...s-in-ssrs.html __________________ هذا الموضوع عبارة عن بذرة تحتاج للنمو والتحسين؛ فساهم في إثرائه بالمشاركة فيه [LEFT]Best Regards Ahmed Ibrahim I.T Manager http://ahmedibrahim.net Mobile: +2 010-3438385 Microsoft Certified Business Management Solutions Specialist for Microsoft Dynamics AX 2009,Dynamics CRM4,GP10 Microsoft Certified Business Management Solutions Professional Applications for Microsoft Dynamics GP10 MCTS: SQL Server 2005,Windows SharePoint Services 3.0 ITIL Foundation V3 |