# BAQ Report Designer - No Rows Being Displayed

**URL:** <https://www.epiusers.help/t/baq-report-designer-no-rows-being-displayed/68472>\
**Category:** Epicor ERP 10\
**Tags:** baq, reports\
**Created:** [June 26, 2020, 12:59pm UTC](https://www.epiusers.help/t/baq-report-designer-no-rows-being-displayed/68472 "2020-06-26T12:59:17Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![markamiller](https://www.epiusers.help/letter_avatar_proxy/v4/letter/m/9f8e36/32.png) [@markamiller](https://www.epiusers.help/u/markamiller)\
**Post date:** [June 26, 2020, 12:59pm UTC](https://www.epiusers.help/t/baq-report-designer-no-rows-being-displayed/68472/1 "2020-06-26T12:59:17Z")

</div>

I have been working on a BAQ SSRS Report. The BAQ runs fine. I download the SSRS report and it doesn’t show any rows.

I have done this successfully on a couple of other reports. I thought I was doing something wrong(Still a strong possibility) so I open a call with Epicor. After 4 weeks of asking for uploads and logins and asking general questions, they told me to pound salt. They wont support a custom report.

Walk in today and the reports that have been running fine for months are now not returning any rows.

We are in the public cloud. Is this possibly an upgrade issue? Anyone ever seen this before? Any help would be greatly appreciated. Thanks

---

<div class="post-metadata">

**Author:** ![ckrusen](https://www.epiusers.help/user_avatar/www.epiusers.help/ckrusen/32/50584_2.png) [@ckrusen](https://www.epiusers.help/u/ckrusen)\
**Post date:** [June 26, 2020, 2:06pm UTC](https://www.epiusers.help/t/baq-report-designer-no-rows-being-displayed/68472/2 "2020-06-26T14:06:42Z")

</div>

> [@markamiller](#):
>
> are now not returning any rows.

You mean the report renders but is blank, or that the System Monitor shows the “No Records Selected” error?

---

<div class="post-metadata">

**Author:** ![ckrusen](https://www.epiusers.help/user_avatar/www.epiusers.help/ckrusen/32/50584_2.png) [@ckrusen](https://www.epiusers.help/u/ckrusen)\
**Post date:** [June 26, 2020, 2:09pm UTC](https://www.epiusers.help/t/baq-report-designer-no-rows-being-displayed/68472/3 "2020-06-26T14:09:00Z")

</div>

If you launch BAQ Report Designer, and then use Actions -\> Test Report Form, does it work?

---

<div class="post-metadata">

**Author:** ![markamiller](https://www.epiusers.help/letter_avatar_proxy/v4/letter/m/9f8e36/32.png) [@markamiller](https://www.epiusers.help/u/markamiller)\
**Post date:** [June 26, 2020, 2:12pm UTC](https://www.epiusers.help/t/baq-report-designer-no-rows-being-displayed/68472/4 "2020-06-26T14:12:23Z")

</div>

No…

---

<div class="post-metadata">

**Author:** ![markamiller](https://www.epiusers.help/letter_avatar_proxy/v4/letter/m/9f8e36/32.png) [@markamiller](https://www.epiusers.help/u/markamiller)\
**Post date:** [June 26, 2020, 2:21pm UTC](https://www.epiusers.help/t/baq-report-designer-no-rows-being-displayed/68472/5 "2020-06-26T14:21:39Z")

</div>

Well I have it reporting all rows now, but not sure why. Maybe you could explain it to me. If I add a table to the report then fields, all rows will display. If I add the fields without a table only 1 row will appear.

---

<div class="post-metadata">

**Author:** ![ckrusen](https://www.epiusers.help/user_avatar/www.epiusers.help/ckrusen/32/50584_2.png) [@ckrusen](https://www.epiusers.help/u/ckrusen)\
**Post date:** [June 26, 2020, 2:25pm UTC](https://www.epiusers.help/t/baq-report-designer-no-rows-being-displayed/68472/6 "2020-06-26T14:25:32Z")

</div>

Not sure I follow you. You referring to the RDL? And by “table”, you mean “tablix”?

Can you post a screen shot of the RDL in SSRS Report Builder?

You sure your fields are in the body section and not the page header (or footer)?

---

<div class="post-metadata">

**Author:** ![markamiller](https://www.epiusers.help/letter_avatar_proxy/v4/letter/m/9f8e36/32.png) [@markamiller](https://www.epiusers.help/u/markamiller)\
**Post date:** [June 26, 2020, 2:30pm UTC](https://www.epiusers.help/t/baq-report-designer-no-rows-being-displayed/68472/7 "2020-06-26T14:30:22Z")

</div>

Yes the RDL. Yes a Tablix. The fields were in the body when only one row was printing. I am just goin to make it work within the Tablix. Thanks

---

<div class="post-metadata">

**Author:** ![ckrusen](https://www.epiusers.help/user_avatar/www.epiusers.help/ckrusen/32/50584_2.png) [@ckrusen](https://www.epiusers.help/u/ckrusen)\
**Post date:** [June 26, 2020, 2:36pm UTC](https://www.epiusers.help/t/baq-report-designer-no-rows-being-displayed/68472/8 "2020-06-26T14:36:57Z")

</div>

Well … what about reports that used to work and now suddenly stopped? I assume there were no changes to the BAQ or RDL for those.

---

<div class="post-metadata">

**Author:** ![markamiller](https://www.epiusers.help/letter_avatar_proxy/v4/letter/m/9f8e36/32.png) [@markamiller](https://www.epiusers.help/u/markamiller)\
**Post date:** [June 26, 2020, 2:43pm UTC](https://www.epiusers.help/t/baq-report-designer-no-rows-being-displayed/68472/9 "2020-06-26T14:43:41Z")

</div>

Great question. Sorry I forgot to update the status… I tested them in our additional environment and they all worked. I uploaded them to Live and they started printing. I am stuck in a state of ignorant bliss. Thanks for your help. It is so comforting to have a site you can receive such export support.

![image002.jpg](https://www.epiusers.help/uploads/default/original/1X/f003192a1f3cbff81737c51a6c1ed5f5dd97394e.jpg)

---

<div class="post-metadata">

**Author:** ![Jason\_Woods](https://www.epiusers.help/user_avatar/www.epiusers.help/jason_woods/32/80101_2.png) [@Jason\_Woods](https://www.epiusers.help/u/Jason_Woods)\
**Post date:** [June 26, 2020, 3:51pm UTC](https://www.epiusers.help/t/baq-report-designer-no-rows-being-displayed/68472/10 "2020-06-26T15:51:58Z")

</div>

> [@markamiller](#):
>
> If I add the fields without a table only 1 row will appear.

A table is a great way to populate a bunch of data. If you only add a field, it is likely just showing you something like:  
=First(Fields!MyBAQ\_Field.Value)  
This will only show one record.
