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?
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?
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
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>
Ok thanks Calvin!
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.
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
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)
Thanks, that’s definitely the way I’ll look to go the next time this comes up except… for today.