I would like to have only 2 parameter dropdowns in my Reporting services Report. The second parameter dropdown Values would be based on the first one. the first parameter dropdown would cointain the columns that are in my stored proc. So lets say I have the following columns, column1 has values a, b, c column2 has values Male, Female and column3 has values east, west, south, north. So that means that if I select parameter dropdown 1 Column1 the 2nd parameter dropdown will only show a, b, c etc. my report is based on a stored proc and I would like to use a udf in my stored proc so that I can be able to pull the information the way I want. So how do I create such a udf? Note I am using ssrs 2008OJMP

Hi OJMP2001, Can you paste your stored proc / query here. -Nitin Pawar

Hello NitinPawar, Here is my stored proc create procedure [dbo].[uspTransactionDetails] @prmTransDate as Datetime AS SELECT [TRANSDATE] ,[FEATURETYPE] ,[FEATURE] ,[PROGRAM] ,[GENDER] ,[LOCATION] ,[APPLICATIONCODE] FROM dbo.tblTransaction where TRANSDATE = @prmTransDate OJMP

Hi ojmp2001, You could utilize cascading parameter to this report, for more information about How to: Add Cascading Parameters to a Report (Reporting Services), pleas see: http://msdn.microsoft.com/en-us/library/aa337169.aspx For the UDF, it will be better if you could post the issue in T-SQL forum at this link http://social.technet.microsoft.com/Forums/en-US/transactsql/threads There are many professional engineers there, you will receive more replies. Thanks, Challen FuChallen Fu [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.