I built a system that runs large reports in seconds instead of hours. It uses linked servers (progress to SQL Server) and the reports are built in crystal from the SQL data instead of XML.
Anyone interested, I'd give them a good price.
I also have software that builds a NACHA file for direct deposits from Epicor data that works.
Stuart Mayhew
251 689 1725
Anyone interested, I'd give them a good price.
I also have software that builds a NACHA file for direct deposits from Epicor data that works.
Stuart Mayhew
251 689 1725
--- In vantage@yahoogroups.com, John Driggers <waffqle@...> wrote:
>
> We don't have anything as large as Chris's stuff, but we routinely run
> reports of several hundred MB. We have network compression enabled for most
> users, but it's a recent change and we didn't have any trouble before.
>
> Where does your report fail? Does it just not appear or does it fail to
> load in Crystal? Depending on how your report is designed, it could be that
> Crystal just can't parse the data in a reasonable amount of time. If you
> setup subreports in certain ways you can get situations where the
> performance degrades exponentially rather than linearly.
>
>
> *John Driggers*
> **
> *Chief Data Wrangler*
> *
> *
> *I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
> *
> *:: 904.404.9233
> :: waffqle@...
> :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
>
> *
>
> *
>
>
>
> On Tue, Aug 7, 2012 at 11:20 AM, cubcrafters_it <
> jason.navarrete@...> wrote:
>
> > **
> >
> >
> > Now that's a big report... :)
> >
> > By chance do you have compression enabled? I turned it on yesterday for my
> > user to see if that helped, and it didn't bomb out for the full month of
> > June!
> >
> > What's strange is that finance would be able to run the 1st half of a
> > month and the 2nd half, but then it would error when running the whole
> > month. If it was actually a bad character, doesn't it seem like it would
> > crop up when running the halves?
> >
> > Anyone else run a really big report like this?
> >
> >
> > --- In vantage@yahoogroups.com, Chris Thompson <chriselectrix@> wrote:
> > >
> > > Our inventory WIP reconciliation is usually around 5-6GB for the XML.
> > >
> > > We just run it, but it takes about 5 hours to preview and is 1500 pages.
> > >
> > > There is a noticable slow down on the system.
> > >
> > > I sounds like it could be something to do with an 'illegal' character of
> > something rather than the size of your xml.
> > >
> > >
> > >
> > > ________________________________
> > > From: cubcrafters_it <jason.navarrete@>
> >
> > > To: vantage@yahoogroups.com
> > > Sent: Tuesday, 7 August 2012, 0:46
> > > Subject: [Vantage] Large Report Issue?
> > >
> > >
> > > Â
> > > So this appears like it might be an issue with the size of the XML. If I
> > run the report for June 1st - June 28th, it's successful, with an XML size
> > of 60.2MB and 1513 page, but if i run it through June 29th, it fails, and
> > the XML data is 63.4MB.
> > >
> > > How do you larger companies run the really really big reports?
> > >
> > > --- In vantage@yahoogroups.com, Tim <tim@> wrote:
> > > >
> > > > We fixed the same thing by deleting a non alphanumeric character in
> > the customer comment field. You may have a similar thing.
> > > > ... my best guess
> > > >
> > > > -----Original Message-----
> > > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > Behalf Of cubcrafters_it
> > > > Sent: Wednesday, July 25, 2012 7:15 PM
> > > > To: vantage@yahoogroups.com
> > > > Subject: [Vantage] "Invalid character in a base-64 string" error
> > running Inventory WIP Recon Report
> > > >
> > > > How do all y'all run your Inventory WIP Reconciliation Report? If we
> > want to run it for an entire month, showing both posted and unposted
> > detail, it'll bomb out with an "Invalid character in a Base-64 string"
> > error.
> > > >
> > > > Finance has gotten around this by running it for half of the month and
> > then the other half of the month, but there's gotta be a better way.
> > > >
> > > > We've gotta be small potatoes in the manufacturing world, so other
> > people must have huge WIP reports...how do you make it work?
> > > >
> > > > The XML appears to be intact, and opening it up in Crystal Reports
> > Designer shows the report okay, but I have a feeling it's hitting some sort
> > of limit inside of Epicor that makes it bomb out.
> > > >
> > > >
> > > >
> > > > ------------------------------------
> > > >
> > > > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> > have already linked your email address to a yahoo id to enable access. )
> > > > (1) To access the Files Section of our Yahoo!Group for Report Builder
> > and Crystal Reports and other 'goodies', please goto:
> > http://groups.yahoo.com/group/vantage/files/.
> > > > (2) To search through old msg's goto:
> > http://groups.yahoo.com/group/vantage/messages
> > > > (3) To view links to Vendors that provide Vantage services goto:
> > http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> > > >
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>