Problem creating BAQ Reports

It has been a while since I created a BAQ report. Am I missing a step? Because whenever I do this I only get one row of results, regardless of which BAQ I use. I must be doing something wrong and its driving me nuts since I have repeated these steps several times now with the same result:

  1. Open BAQ, verify it runs and generates several rows of results
  2. launch BAQ Report Designer and create new report using this BAQ
  3. while still in BAQ Report Designer, click on Actions → Download SSRS Report
  4. open this .RDL file in Report Builder and add fields
  5. go back to BAQ Report Designer and click on Actions → Upload SSRS Report
  6. in BAQ Report Designer, go to Actions → Test Report Form

Whenever I do this, regardless of the BAQ that I use, only the first row of the BAQ results is showing up. What am I doing wrong?

When you add fields make sure you do it with a table wizard. If you just click and drag fields onto your report, you will only get the first row of results.

3 Likes

Wow! Definitely not expected behavior. I was dragging and dropping. You just saved me another hour of banging my head on my desk trying to figure this out.