Forum Discussion

petersi's avatar
petersi
Icon for Helper II rankHelper II
9 years ago

Applying Submitted Paramter to Report

I have a question related to the ability to specify a means where a paramter is to be supplied to a report. I am currnelty integrating Power BI via a web application. We have the necessity to restric...
Need Help
Ashwinikhole's avatar
Ashwinikhole
Regular Visitor
8 years ago

Hi team,

 

I am trying to create parameter which will act as user defined filter and which will pass to the SQL query as a parameter.

 

MEMBER

PaidAmt

740007651

50000

740007651

70000

740007653

55000

740007653

60000

 

I want to create Paidamt as a parameter and need to pass it to SQL query so that whenever a user select any value it will filter the sql query.

 

I have created what if parameter and trying to pass the SQL code but it giving error like Expression. Error: The name 'Paidamt1' wasn't recognized. I am using below code:

(having sum(clf.PAID_AMOUNT)>'"& (Paidamt1) &"'#(lf)#(lf)#(tab)"]).

 

Could you help me to find out how i can apply parametrized filter into SQL code.

 

Thanks,

Ashwini