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
and this is my query:
,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
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!