Hi,

Thanks a lot for the reply.

Am already checking with profiler..very poor performance as there was along string for that parameter..which works well with passing 'ALL' .But our user dont want...

Hi,

very useful code..

can u please let me know how to call this custom code function from SSRS ?

Hi ,

Tried using the above code

Am getting the error in report as

UNABLE TO CAST object of type 'system.object[]' to type 'microsoft.reporting services.reporting processes.ReportobjectModel.parameter'

Could you please explain how to use these...

Hi,

Thank you for the reply..

Actually,in SSRS parameter data set,we have added 'ALL' string using Union

say..

Select distinct colmn name as Param from table

union

select 'ALL'

in SQL Procedure implemented as..

...

Where Column name in...

Am getting the below error in Report when i used the above functions:

UNABLE TO CAST object of type 'system.object[]' to type 'microsoft.reporting services.reporting processes.ReportobjectModel.parameter'

Hi,

Please let me know how to use this function in report.