Table(s) not available in BAQ

Epicor ERP 10
1

I noticed the ReportDefaultStyle table is not available in the BAQ designer.

Why is this?

And is there anyway around this - like manually adding text as a sub-query criteria?

2

Did you find away around this? I’m creating a rest service and want to find the default style without doing a direct database connection

3

No I didn’t. And FWIW a trace shows that a change to a style’s Default checkbox, hits DB table “ReportComp”

<changedValue tableName="ReportComp" rowState="Modified" rowNum="3" colName="IsDefault">
  <![CDATA[True]]>
</changedValue>
4

Ok thanks Calvin!

5

Can anyone tell me which table stores the default settings for report styles?
Thanks in advance…

Grrr… these dead ends with field help and traces are one of my pet peeves.
I’m pretty sure I’ve tracked this one down several times but today… my memory seems to be on holiday.

6

default report style… where stored
Never mind… looks like it is here

ReportDefaultStyle

Contains the default ReportStyle for a specific Company/Report. A default does not have to exist.
Not directly maintainable by the UI. Instead, it is exposed a boolen field ReportComp.Default. ReportComp is a not a physical db table. It is created dynamicaly in the dataset only for use by the UI

7

FWIW, I wrote an External BAQ to get it against the Epicor DB:

select 
	[ReportDefaultStyle].[StyleNum] as [ReportDefaultStyle_StyleNum]
from Ice.ReportDefaultStyle as ReportDefaultStyle
where (ReportDefaultStyle.Company = @CurComp  and ReportDefaultStyle.ReportID = @ReportID)
1 Like
8

Thanks, that’s definitely the way I’ll look to go the next time this comes up except… for today.

  • I happened to be working at a worst case site - V8 / Progress.
  • so I ended up creating a view and using that in an ODBC report.
  • ugly but it works.