# Table field for Default Report Style?

**Category:** [Epicor ERP 9](https://www.epiusers.help/c/e9/7)
**Created:** 2016-10-24 19:36 UTC
**Views:** 1222
**Replies:** 2
**URL:** https://www.epiusers.help/t/table-field-for-default-report-style/35938

---

## Post #1 by @bordway

Wonder if anyone knows the physical location for Report Style fields "Valid" and "Default"?

I've haven't had luck locating from the trace or the Data Dictionary. Just references to a temp table "ReportCompany".

Table: ReportStyle
Field: CompanyList (this does update when "valid" is selected but where to look for "default")?
Delimited list of company id's that can use this ReportStyle.
Blank = All Companies. This field will not be overlaid during release upgrades.
This field is not intended to be directly updatable. Instead it is exposed to the UI in a separate table (ReportCompany) which is not a physical db table. All Companies are created in ReportCompany. If in the CompanyList, then ReportCompany.ValidStyle = Yes
Delimeter character is global LIST-DELIM value  (~)
 

Thanks

---

## Post #2 by @Krosell

There is a table named: Ice.ReportDefaultStyle.. 
There is a record for each Report Style and Company with these fields:
SELECT [ReportID]
      ,[Company]
      ,[StyleNum]
      ,[SystemFlag]
      ,[SysRevID]
      ,[SysRowID]
  FROM Ice].[ReportDefaultStyle]

---

## Post #3 by @bordway

>>ReportDefaultStyle
I was seeing that in the data dictionary but.. it wasn't being listing it in the BAQ designer? (E9)

I finally got to it by looking directly at the database.


Thanks.

---


**Canonical:** https://www.epiusers.help/t/table-field-for-default-report-style/35938
**Original content:** https://www.epiusers.help/t/table-field-for-default-report-style/35938