Optional Parameters on RDD Based BAQ Report?

Kinetic ERP
,
1

I was asked to have the option to filter a BAQ report by either a Job Start Date range OR an Order Ship By date range. I’m going at this BAQ report from a BAQ-based RDD.

My BAQ parameters have “skip if empty” selected and are working as desired when just testing the BAQ. However, the Kinetic print screen for the BAQ report auto-populates a date into each of the option fields. If I delete one set of them (see image below), I get an error that I’m trying to feed a string into a date field. I don’t see an option to leave these fields “blank.”

image

Any thoughts? Are optional parameters/BAQ report options possible?

Thanks!

2

I have done some dashboards where I have a data filter BAQ using UD11 to as a place to hold data. It’s updatable and Key1 defaults to the userID.

The BAQ then has a subquery that has UD11 and the rest of the query is filtered by the various date, number or character values that I have placed in it.

Using the “add process” to the Dashboard, I launch the BAQ report or BAQ export that will run based on what I am seeing on the dashboard.

3

That’s an interesting approach! I’ll look into that option. Thanks for the input, Bruce!