I have created a RDD BAQ Report. The RDD has a few Report Criteria Prompts. I have default the value to Empty string for CustID and ProjectID. In the BAQ, CustID and ProjectID has the check box ticked for “Skip if Empty” so that I get results when they are Empty.
However, I get no results when I leave the CustID and ProjectID empty. To get results, I have to enter a CustID and ProjectID.
Am I using the Skip if Empty in a wrong way?
Hi @TobyLai, Please follow the below mention link.
The report can run, if I type in a ProjectID and CustID, there will be result, but when ProjectID and CustID are empty, no results are returned, I thought the Skip if empty condition will come into play, but unfortunately not when the information is passed into the BAQ.
At the moment, I have made ProjectID and CustID to become Criteria Filter instead.
Could you please share your baq and report?
I think the “Skip if empty” setting only affects the BAQ when it’s run from the BAQ designer or a dashboard.
Do you even see the prompt for BAQ Paramters when you run the RDD Report? I’d guess you don’t.
Yes, the Skip if empty works well in the BAQ.
I thought the Criteria Mapping pass the prompt from the report submission dialog to the BAQ parameters. I guess between the two, there is some issue converting the empty string and end up getting no result.
Maybe try making the CustID a Criteria Filter instead Criteria Prompt.
Yes, changing to Criteria Filter works, but the original requirement was to allow user to enter a CustID in the textbox rather than going to the 2nd tab for the Filter. Maybe I have to persuade them to change the requirement. 
Another workaround would be to make the BAQ’s table criteria use LIKE instead of =, and set a default value of * (I think that works, if not try %). If they do nothing to the field, it finds all matches. Or they can type in the specific CustID .
Convince them it’s even more powerful as you could use wild cards like AC% to include ACME Explosives, and ACME Jet Products 
