عرض مشاركة واحدة
قديم 26-Oct-2014, 09:45 AM   #1
as_radwan
عضو مميز
 
تاريخ التسجيل: Nov 2007
المشاركات: 256
من مواضيعي  
افتراضي 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
as_radwan غير متواجد حالياً   رد مع اقتباس