I have an SSRS report with 3 parameters.

composed of 2 dataset. dataset 1 is okey i did not encounter any problem but in dataset 2 which i have a problem.

@ExcRate data type Float : sample 61.41 

@FromDate

@ToDate

and this is my query:

;With Cte

as

(

select .

.

.

 ,Case When pur.CURRENCYCODE='PHP' Then Round((pur.QTYORDERED*pur.PURCHPRICE)/@ExcRate,5)
         When pur.CURRENCYCODE='USD' Then Round(pur.QTYORDERED*pur.PURCHPRICE,2)
     End As SPENDUSD     

From xxxx

where trandate between (@fromdate) and (@Todate)

)

Select * from CTE


My problem when i went  to SSRS query designer for dataset # 2 and run the script  i just encounter an error.

Parameter 3 ([Dynamics].[].[unknown]): CLR type does not exist or you do not have epermission to access

when i try to remove the @Excrate, i did not encounter an error and the processing went pass through.

my objective is to have a parameter of exchange rate to multiply the value of qtyordered * purchprice.

any idea guys about this issue or option. thank you!