I am creating BAQ Reports using SSRS. I need a summary report by date range showing total supplier payments. The BAQ works fine, but when I try to generate a report where the dollar value returned is zero, the system monitor tells me there are no records returned. I can put the same date range as criteria in the BAQ and see the results returned. I don’t care if the dollar value is zero, I want to see the records anyway. Does anyone know of a way to get around this behavior?
your BAQR filtering must be off somehow. (maybe you have two conflicting filters in place)
i can’t really tell without more detail (BAQR parameter screen shots)
however, i would try to REMOVE all filters from the baqreport and run it to see what you get.