BAQ Report Designer / Filtering & Options

Kinetic ERP
,
1

Hello!

I am trying to create a report in BAQ Report Designer. I have the following set up:

image
image1711Ă—134 3.76 KB

image
image715Ă—103 2.33 KB

image
image561Ă—513 13.8 KB

image
image555Ă—515 12.2 KB

When I try to test it and search for a specific sales order (meaning I select a specific one) it returns with an error about no records. Even though I was able to pull up and select it.

Any advice?

Thank you.

2

Stupid question… you have parameters for start & end dates tied to POHeader_OrderDate.

In the screen shots above, your dates are defaulting to today… and the order you’re showing in your screen show has a date of yesterday. (outside of your start/end parameters).

Are those screen shots from your testing? Or just general screen shots, not related to actual performance.

3

Check your compare operators, they look backwards to me

4

Good eye!

5

It is working, thank you! I flipped the operators and I also noticed I had them set up in the actual BAQ, so I deleted those for good measure. Additionally, set up the SSRS report itself. I am not sure why it didn’t occur to me to do that earlier, but I think in the past I’ve generated a report with zero information just to see if it could. Oh well. Solved, thank you!