Filtering in quick reports

Hi,

Either you can add to where clause if its fixed filtering on specific value , or else Report_SYS.Parse_Parameter in quick report where clause ..

/Wasana

this is the first input screen and when i click on view report, it will fetch whole table, but I want see paremeter window like in the first picture

@Ed22 as @wahelk mentioned, you need to edit the SQL statement and add some conditions in the Where clause → Report_SYS.Parse_Parameter

I’ll also leave below as reference the SQL code for a quick report I created a while back and it has quite a few params.

select pcm.company
       , company_api.get_name(pcm.company) as Company_Name
       , pcm.post_module
       , pcm.posting_type
       , pcm.posting_type_desc 
       , pcm.code_part
       , pcm.code_name 
       , pcm.pc_valid_from Master_Valid_From
       , pcm.control_type
       , pcm.control_type_desc
       , pcm.default_value 
       , pcd.control_type_value 
       , pcd.code_part_value 
       , pcd.valid_from Detail_Valid_From   
from POSTING_CTRL_MASTER pcm
     LEFT JOIN POSTING_CTRL_DETAIL pcd
     ON pcm.company = pcd.company
     AND pcm.posting_type = pcd.posting_type
     AND pcm.code_part = pcd.code_part
WHERE 1=1
and ifsapp.report_sys.parse_parameter(pcm.company,'&[-C--L]COMPANY_ID')='TRUE'
and ifsapp.report_sys.parse_parameter(pcm.post_module,'&[-C--L]MODULE')='TRUE'
and ifsapp.report_sys.parse_parameter(pcm.posting_type,'&[-C--L]POSTING_TYPE')='TRUE'
and ifsapp.report_sys.parse_parameter(pcm.posting_type_desc,'&[-C--L]POSTING_TYPE_DESC')='TRUE'
and ifsapp.report_sys.parse_parameter(pcm.code_part,'&[-C--L]CODE_PART')='TRUE'
and ifsapp.report_sys.parse_parameter(pcm.code_name,'&[-C--L]CODE_NAME')='TRUE'
and ifsapp.report_sys.parse_parameter(pcm.control_type,'&[-C--L]CONTROL_TYPE')='TRUE'
and (pcm.pc_valid_from >= to_date('&VALID_DATE_FROM','DD.MM.YYYY') or nvl('&VALID_DATE_FROM', '*') = '*')
and (pcm.pc_valid_from <= to_date('&VALID_DATE_TO','DD.MM.YYYY') or nvl('&VALID_DATE_TO', '*') = '*')