Hi..it was by me only!!!

I tried but its not working for the string types mentioned above.

yes

here based on pop_typr if it is "s" then need to get the str_val

"d" then date_val

"B" then bin_val

for taht comment

can we use cursor ? if so how?

Example tbale T1 has id 1 , 2, 3, 4

and T2 has id 3,4,5,6

so i want 1,2,3,4,5,6 as ID in result table

I have to do something in report using this table.

Did you do simple select to test if there is data in Database??? or run the query you used to generate the report in managemnt studio and see if it...

Thank you for all responses...I got it!!!

I got query to get month order and year but not getting month names.

SELECT [year], [month]

FROM (

SELECT 2005 AS [year] UNION ALL

SELECT 2006 UNION ALL...

If there are 4-5 drop down list into my report then on selecting any values from drop down list whole report get refresh and slow down the process.I dont want...

hey...I am not using any cascading paramters!!!

I used other split function.But still not working.Is there any way to pass multiple values in dropdown..and get data for the selected values in paramter??

I tried Remving Join () and pass multile values to paramter.It is still not working.

My Splitfunction :

ALTER FUNCTION [dbo].[SplitParameterValues]

(

@RowData NVARCHAR(MAX),

...

I achieved this by adding an expression in report and also added group by Cname and Lofcoverage.I think it will be helpfull to others too.

My expression to achieve last...

My expression is :

= CASE WHEN Fields!PremuimMonth.Value >= DATEADD("mm",-3,NOW())THEN Fields!PremiumAmount.Value ELSE " " END As "AVERAGE AMOUNT"

Case is not working in SSRS...It is just showing #error