# BAQ Report Designer "Adapter" **URL:** \ **Category:** Epicor ERP 10\ **Tags:** baq, reports\ **Created:** [May 24, 2019, 5:21pm UTC](https://www.epiusers.help/t/baq-report-designer-adapter/56122 "2019-05-24T17:21:56Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![PaulKile](https://www.epiusers.help/user_avatar/www.epiusers.help/paulkile/32/33206_2.png) [@PaulKile](https://www.epiusers.help/u/PaulKile)\ **Post date:** [May 24, 2019, 5:21pm UTC](https://www.epiusers.help/t/baq-report-designer-adapter/56122/1 "2019-05-24T17:21:56Z")
I have a BAQ that generates the output I want (select fields for all AP Invoices), and I want the output to be available in Excel easily to non-technical users. For this I can use BAQ Report Designer to create an SSRS report, then select Excel or CSV (or whatever) as the output. I want to be able to filter on Invoice Date, and the BAQ Report Designer supports filters, but only for “Adapter” fields; naturally date isn’t one of those fields. Here are my questions: 1. What is an Adapter field? 2. How can I convert a data element to an Adapter? Here is an Epicor KB article on the topic, but the article is rather cryptic for me: [KB0030073 - BAQR Report Filter not showing a field](https://epicorcs.service-now.com/epiccare?id=epiccare_kb_article&sys_id=7571b280db2b6a04b3227e09af961975) Final note: My company is hosted in Epicor’s Multi-Tenant SaaS cloud. As such, I must use Epicor’s tools to manipulate the system. ---
**Author:** ![Banderson](https://www.epiusers.help/user_avatar/www.epiusers.help/banderson/32/50875_2.png) [@Banderson](https://www.epiusers.help/u/Banderson)\ **Post date:** [May 24, 2019, 6:10pm UTC](https://www.epiusers.help/t/baq-report-designer-adapter/56122/2 "2019-05-24T18:10:48Z")
Wouldn’t it be easier to just do a dashboard and have them copy from the grid there? ---
**Author:** ![PaulKile](https://www.epiusers.help/user_avatar/www.epiusers.help/paulkile/32/33206_2.png) [@PaulKile](https://www.epiusers.help/u/PaulKile)\ **Post date:** [May 24, 2019, 6:18pm UTC](https://www.epiusers.help/t/baq-report-designer-adapter/56122/3 "2019-05-24T18:18:06Z")
Hi @Banderson, The solution I implemented is exactly what you recommended, namely Dashboard + grid copy/paste. But there is also the principle of the thing, namely that Epicor has built a tool and due to a limitation I don’t understand, I can’t get the expected value out of it. Here’s to hoping there is a solution or at least an explanation! ---
**Author:** ![saturnsjazz](https://www.epiusers.help/letter_avatar_proxy/v4/letter/s/7cd45c/32.png) [@saturnsjazz](https://www.epiusers.help/u/saturnsjazz)\ **Post date:** [May 24, 2019, 6:22pm UTC](https://www.epiusers.help/t/baq-report-designer-adapter/56122/4 "2019-05-24T18:22:08Z")
I would teach them out to use the BAQ Export process instead of building a actual report. It will generate the BAQ to a csv file automatically for them. ---
**Author:** ![Banderson](https://www.epiusers.help/user_avatar/www.epiusers.help/banderson/32/50875_2.png) [@Banderson](https://www.epiusers.help/u/Banderson)\ **Post date:** [May 24, 2019, 6:47pm UTC](https://www.epiusers.help/t/baq-report-designer-adapter/56122/5 "2019-05-24T18:47:32Z")
interesting, the adapter has a the APInvoice head date in there… ![image](https://epiusers.help/uploads/default/original/3X/1/5/157e71639ef42467c0e022add0ec100ad9ce544f.png) ---
**Author:** ![josecgomez](https://www.epiusers.help/user_avatar/www.epiusers.help/josecgomez/32/55731_2.png) [@josecgomez](https://www.epiusers.help/u/josecgomez)\ **Post date:** [May 24, 2019, 7:32pm UTC](https://www.epiusers.help/t/baq-report-designer-adapter/56122/6 "2019-05-24T19:32:38Z")
BAQReportDesigner will let you add an option field for the data for filtering. What am I missing here? ---
**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:** [May 25, 2019, 7:10pm UTC](https://www.epiusers.help/t/baq-report-designer-adapter/56122/7 "2019-05-25T19:10:31Z")
I think it has to do with not all columns of a BAQ appearing in the list to choose from when adding an Option to the BAQ Report. Like … > **[BAQ Report Filter field](https://www.epiusers.help/t/baq-report-filter-field/36881/17)** > > Hello, Does anyone got the answer for this question? According Epicor definition : Only columns from the BAQ that have an adapter are displayed in the list. This property lets this column link to other columns to restrict the data that appears ... ---
**Author:** ![josecgomez](https://www.epiusers.help/user_avatar/www.epiusers.help/josecgomez/32/55731_2.png) [@josecgomez](https://www.epiusers.help/u/josecgomez)\ **Post date:** [May 25, 2019, 10:14pm UTC](https://www.epiusers.help/t/baq-report-designer-adapter/56122/8 "2019-05-25T22:14:42Z")
Option fields will show for all columns Filters will show only for primary columns If an option field isn’t showing add it to the like lost on the BAQ ---
**Author:** ![MCStanhope](https://www.epiusers.help/user_avatar/www.epiusers.help/mcstanhope/32/33739_2.png) [@MCStanhope](https://www.epiusers.help/u/MCStanhope)\ **Post date:** [June 22, 2021, 9:40am UTC](https://www.epiusers.help/t/baq-report-designer-adapter/56122/9 "2021-06-22T09:40:39Z")
Unfortunately Option fields are free text entry so the user has to know exactly the value to enter and be accurate, rather than offering a choice from a list, like a Filter does. Might there be another way to make a field available as a list choice (Filter) rather than a free text (Option)?