How do I solve pass parameters by users

ali_a — Wed, 16 Oct 2019 08:15:14 GMT

Hi there,

I have been trying many of way to let users enter value in the parameter by using power bi server report for my organization.

Please, I need to solve this problme by any way. An addition, it's only work by this way -> Home -> Edite Queries -> Edit parameters.

 select sum (db.fun_gt.g_m_c ( a.branchoff, 
                               a.cntno ,
                               db.fun_date (db.dte_pkg.g2h (TO_DATE ('31122018','ddmmyyyy')))))  as sum
  from db.Test a;

/*With parameter*/
 select sum (db.fun_gt.g_m_c ( a.branchoff, a.cntno , db.fun_date 
(db.dte_pkg.g2h (TO_DATE ('"&Pass_Date&"','ddmmyyyy'))))) as sum 
from db.Test a;

Thanks :)

topic How do I solve pass parameters by users in Report Server

How do I solve pass parameters by users