Hello!
I am trying to create a report in BAQ Report Designer. I have the following set up:
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.
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.
Check your compare operators, they look backwards to me
Good eye!
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!
