# BAQ Report Filter with Multiple Values

**URL:** <https://www.epiusers.help/t/baq-report-filter-with-multiple-values/80712>\
**Category:** Epicor ERP 10\
**Tags:** e10\
**Created:** [July 19, 2021, 3:29pm UTC](https://www.epiusers.help/t/baq-report-filter-with-multiple-values/80712 "2021-07-19T15:29:34Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![jhecker](https://www.epiusers.help/user_avatar/www.epiusers.help/jhecker/32/55571_2.png) [@jhecker](https://www.epiusers.help/u/jhecker)\
**Post date:** [July 19, 2021, 3:29pm UTC](https://www.epiusers.help/t/baq-report-filter-with-multiple-values/80712/1 "2021-07-19T15:29:34Z")

</div>

I am working on a BAQ Report, and have created the BAQ, the BAQ Report (in turn creating the RDL on the SSRS Server) and the report style…all is good(ish). As you can see in the screenshots below, I have the filter set up in the BAQ Report Designer, and it appears in the report menu:

 ![image](https://www.epiusers.help/uploads/default/original/3X/e/0/e0447d9fa175da37413e993349ce7642a0313d0b.png)

![image](https://www.epiusers.help/uploads/default/original/3X/9/4/9428d2acc7070030370216525b9bd6bf1d2afa15.png)

The issue is with the filter…I am forced to click the “Job Number” button and search for the job, rather than having the option to type in the JobNum, or right click and Paste Update to enter many at once.

I am sure there is a simple option I am overlooking, but I can’t seem to figure out what it is.

I am looking to have it like what is shown here:  
 ![image](https://www.epiusers.help/uploads/default/original/3X/8/5/852d7e47e03b6658e9c3edc9f6a6e3805e2a9a7d.png)

---

<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:** [July 19, 2021, 5:17pm UTC](https://www.epiusers.help/t/baq-report-filter-with-multiple-values/80712/2 "2021-07-19T17:17:09Z")

</div>

If you select the “New” toolbar icon,

 ![image](https://www.epiusers.help/uploads/default/original/3X/b/2/b2b2b644e3c565cd7ac83d50cf71ee0e52f0a36b.png)

it will add a blank row to the Grid. Then you can type or paste the job number

And FWIW - you should make the JobNum column first. That way you could use Paste Insert to enter a pre-existing list of jobs.

# Edit:

If using Paste Insert, don’t make that blank row first.

---

<div class="post-metadata">

**Author:** ![jhecker](https://www.epiusers.help/user_avatar/www.epiusers.help/jhecker/32/55571_2.png) [@jhecker](https://www.epiusers.help/u/jhecker)\
**Post date:** [July 19, 2021, 5:32pm UTC](https://www.epiusers.help/t/baq-report-filter-with-multiple-values/80712/3 "2021-07-19T17:32:12Z")

</div>

I almost responded with “C’mon now, I aint a flippin moron…I clicked the new button!”…then I realized I am a flippin moron…while I _did_ click the new button, I failed to scroll to the right to see that there was a Job Number field waiting to be typed in.  
Is there a way for me to force that field to be the 1st one when someone else opens this menu? I know that I can change it via the personalization menu for me, but that doesn’t flow to other users, right?

---

<div class="post-metadata">

**Author:** ![cfinley](https://www.epiusers.help/letter_avatar_proxy/v4/letter/c/3e96dc/32.png) [@cfinley](https://www.epiusers.help/u/cfinley)\
**Post date:** [July 19, 2021, 5:36pm UTC](https://www.epiusers.help/t/baq-report-filter-with-multiple-values/80712/4 "2021-07-19T17:36:25Z")

</div>

I believe you can save a “personalization” feature while making a customization for a screen.

---

<div class="post-metadata">

**Author:** ![jhecker](https://www.epiusers.help/user_avatar/www.epiusers.help/jhecker/32/55571_2.png) [@jhecker](https://www.epiusers.help/u/jhecker)\
**Post date:** [July 19, 2021, 6:14pm UTC](https://www.epiusers.help/t/baq-report-filter-with-multiple-values/80712/5 "2021-07-19T18:14:32Z")

</div>

Yeah, so that did it. I have no idea why that never crossed my mind. I’ll sheepishly accept my blonde moment.  
 ![image](https://www.epiusers.help/uploads/default/original/3X/5/2/52ba8fbd91b05ddd494c7c7d38336bf20eb3a6c1.jpeg)

---

<div class="post-metadata">

**Author:** ![cfinley](https://www.epiusers.help/letter_avatar_proxy/v4/letter/c/3e96dc/32.png) [@cfinley](https://www.epiusers.help/u/cfinley)\
**Post date:** [July 19, 2021, 7:41pm UTC](https://www.epiusers.help/t/baq-report-filter-with-multiple-values/80712/6 "2021-07-19T19:41:38Z")

</div>

We have all been stupid users at some point. Rarely happens to me 🙂
