BAQ Report Designer issue

[DermotN (Dermot Nolan)]

Good Afternoon All,

Hope you are all keeping well? - I have a BAQ that has four Sub-Queries within it… The Top Level holds the AR Invoice Date, I have to design an SSRS Report using BAQ Report Designer.

The BAQ Works perfectly - The issue is when I am in the BAQ Report Designer and looking to add “Option Fields” been the dates the report should run between.

Using the “InvcHead_InvoiceDate” as the option to run it, I am getting a System Monitor Error with “No Records Selected”

Any ideas?

[Banderson (Brandon Anderson)]

Can you screen shot the dates you are putting in? You have the options order To: From: which is probably backwards of what most people would intuitively put, so I’m wondering if you’re putting your From date in teh To field and vice versa.

[DermotN (Dermot Nolan)]

Thank you for getting back to me…

After I read your post - I did the dates in reverse and it worked…

[DermotN (Dermot Nolan)]

Thank you…