Odd behavior. Report Maintenance takes minutes to load (V8.03)

I'm not sure with regards to your questions regarding the fields but we have experienced issues opening the Report Style screen.  We had issues where it wouldn't open at all and we received a 'fix' from Epicor which now means it can take around 5 minutes but does open.  The fix was SCR61234.

We're on V 8.03, and when I use Report Maintenance (aka Report Style), it takes a couple ,minutes to populate the search window.


I'm using the basic search - not a BAQ or any other customized search.


Is this a sign of something run amuck with the one or more of the Report Tables (ReportStyle, RptDefault, etc...)?


Weird thing is, it usually just does it the first time I use Report Maintenance.  Subsequent searches from within Report Maintenance run just fine - at least for the rest of that day.


Any way to run a check on the tables to make sure there isn't something funky in there?


Calvin

 

More info ...

Doing an ODBC query of the ReportStyle table has something that doesn't make sense.

The field CompanyList, seems to be one of 
"MC"
"MC~CC"
"CC"
"CC~MC"
"none"
"" (blank)

1. What's the difference between "MC~CC" and "CC~MC"?  Just the order they were check off on in the Report Maint?

2. What's the diff between "none" and "" (a blank value) ?

Calvin