I have some problems and don't know how to resolve.
1. I use dbr.report and link to sp_DBR_report_02(inCom varchar(20), inBU varchar(20)); and two parameters are optional. First I can run with:
select 'dbr.report', 'sp_DBR_report_02', 'inCom=Company';
But after I add one more paramter, this make store is (inCom varchar(20), inBU varchar(20), inStatus varchar(50)) (all are optional), when click in the report link, it always require inBU and inStatus.
2. I try with:
select 'dbr.report', 'sp_DBR_report_02', 'inCom=Company', 'inBU=""', 'inStatus=""';
And now when I click in the report link, it shows the box with only "Run Report" button and 2 columns title: "Parameter" and "Input" without any field to input, and can click the button to run Report without do anything else.
Please help, I have a lots of report link that use this store and must I add 'inBU=""' into all of this?