I have a very simple BAQ that works perfectly in the designer and analyze but when I run the BAQ from the menu as a report it just returns no data and the SSRS guid tables where the data is suppose to be are all empty. At first I though that the .rdl file was messed up but I checked our server and the GUID tables are getting created, they just contain no rows.
All I’m doing is selecting all rows that are greater than a certain date.
What would cause this?
If your BAQ includes a parameter, it could cause this issue. In this case you would have to remove the parameter from the BAQ and add it to the BAQ report as an option.
So then don’t use parameters and RDDs but use the BAQ report designer options?
Right. Anytime you take your BAQ and try to use it in a BAQ Report (the RDL report builder kind) then your BAQ parameters won’t work. You can get the same results by using the BAQ report designer options.
Ok, I did what you said and that worked. Thank you.
Side note: I find it utterly frustrating that you have the options of completely setting up parameters, fields, the RDD, etc. with the BAQ and everything and it does not work. What’s the point of that even being there?
I would highly suggest not using BAQ reports and just create report data definitions from your BAQs and then use the RDD as the basis for your report style. A little more work, but BAQ reports are dumb
I really only use BAQ reports when the BAQ is pretty much already correct, and I just want to make it a little prettier. They are so much easier to get going with, but so much more limiting than RDD.
That’s why I was having a problem, I don’t do it this way normally. I just had to do something super simple and thought I was going about it in a quick and dirty way. Little did I know, it doesn’t work like that.
I feel your pain, I was banging my head against the wall this past week trying to figure out this same issue. I was reading on these forums that BAQ reports are no longer going to be supported/deprecated? I’m not sure how true that actually is, thus why I suggested the RDD option.
I love it when I can just quote people and make my replies 
It won’t help you now, but I’m doing the same thing for work, (The “Advanced BAQ Report” kind)
and should be sharing a library when done that makes a lot of this trivial.