BAQ Report using RDD Criteria Prompt doesn't work after converting to Kinetic

Kinetic ERP
1

I have a BAQ report that was setup using an RDD due to needing multiple BAQs. There are two parameters which are in all the BAQs and in the RDD Report Criteria - Job Num and Assembly Seq. Assembly Seq is an Int format. BAQ parameter and RDD Criteria Mapping are setup to “Skip if Empty” so that the user can enter a Job Number and leave the Assembly Seq blank which should pull all assemblies for the job.
This works great on the Classic Report Menu

image
image853×369 71.3 KB

However, the Kinetic Report Menu is auto populating this parameter with a 0 and even if I remove the 0 when the report runs it only pulls the Assembly 0. Has anyone experienced this? Any idea how to get this to work in Kinetic?
image
image853×300 40.4 KB

Including screen shots of the RDD that has been working great for the past 3 years in Classic.
image
image1646×377 127 KB

image
image1666×495 200 KB

2

Can you use that cool nullif(value,0) expression somehow here? I think this returns a null if the value is 0.

3

The RDD has a default value of “0” for the @AssySeqBlank.

Can you delete that and see if an empty value will stick?

4

I have tried deleting & backspacing to remove the 0 that defaults and when I click Print Preview it just puts the 0 back and only prints the 0 assembly.

5

Don’t believe this will work as users need option to run for just Asm 0.