Hello Nilay here,
How to display the coulumn list of the reports to the end user
Thanks,
How to get the Columns list to the end user?
Hot Topic
- job failed (SSIS). Executed as user: SRVDESASQL2005\SYSTEM.
- connecting to database
- Job To Execute A SSIS Package Fails - The Command Line Parameters Are Invalid
- Adding/Previewing custom table style
- Switch / choose / IIf in expression
- Complex SQL Query
- Import Export Wizard - ODBC to SQL
- making the shift from Access SQL to 'Real' SQL ;-)
- SQL Server Destination Error when running multiple packages
- SQL Server 2005 Trigger fires per statement or per Record
SQL Server
- Syntax Error when using variables in SQL Statement
- Locating idle sessions using dm_exec_... DMV's
- Server Time Dimension - Reference Dimension issue
- Variable Mapping in SSIS
- DataMining on Chart
- TSQL Question - Datetime conversion
- Report Viewer/Explorer-WebPart missing under SharePoint v3+SQL Server 2005
- 2005 SQL Reporting Service XML Data Source (WebService)
- Replication for Full-Text Index
- Unable to cast object of type Microsoft.SqlServer.Management.UI.ConnectionDlg.Personalization to type Microsoft.SqlServer.Manage
How to get the Columns list to the end user?
.blogspot.com
a) How to prompt the user for the columns he/she wants to display, or
b) How to display a column containing a list of reports
svn
In SQL Server 2005, you can use a multi-value parameter to prompt the user. Then you can write an expression/custom function to parse the output of the parameter. Call that expression/custom function in the visibility expression for the column in your table/matrix.
You'll need to make sure the choices in your parameter list are are kept in sync with your fields list, that's something that we don't provide by default.
-Lukasz
---
This posting is provided "AS IS" with no warranties, and confers no rights.
Rajesh Basa
Regards,
Nilay