Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Use column Names as Parameters

  Asked By: Parvesh    Date: May 06    Category: Sharepoint    Views: 2181

I need to create a report with column names as parameters and depending on what columns are chosen it should show the values.

1. Let us assume that there is a table with the following column names

Employeename
Phone Mumber
Area
Sales

2.Employee ,Phone Number and Area should be showin the drop down based on what columns the user choses .It should show the respective columns in the report.

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Ali Javed     Answered On: May 06

This can be achieved in SQL Server 2005 Reporting Services. There is a good document which can help you add cascading parameters  to your report.
http://msdn.microsoft.com/en-us/library/aa337426(SQL.90).aspx

 
Didn't find what you were looking for? Find more on Use column Names as Parameters Or get search suggestion and latest updates.




Tagged: