Re: Crystal Preview (.show) is very slow

From: Mike Gorgone (m_gorgone_at_hotmail.com)
Date: 11/30/04 

Date: 30 Nov 2004 14:20:24 -0800

Hi Brian,

I am using ado.net and I've discovered that the xml file generated by
the SQL statement is over 5 meg so we think that because there are 15
subreports that all connect to the main report's dataset CR has to
look through that XML file to find the data for the report. Does that
sound accurate?

Mike

"Brian Bischof" <Brian@NoSpamBischofSystems.com> wrote in message news:<#MHzW9w1EHA.164@TK2MSFTNGP10.phx.gbl>...
> Are you using ADO.NET as the datasource? If so, there is a problem that this
> is the first generation of CR that uses datasets and they are notoriously
> slow. CR rewrote the ADO.NET connectivity libraries for v10 and now they are
> tremendously faster. However, the only way to get the new libraries is to
> upgrade to v10 or wait for VS.NET 2005 to come out next year.
>
> HTH,
>
> Brian Bischof
> www.CrystalReportsBook.com
>
>
> "Mike Gorgone" <m_gorgone@hotmail.com> wrote in message
> news:9af1e7ae.0411300826.2023271b@posting.google.com...
> > Hi All,
> >
> > Here's the problem I'm previewing a report in Crystal that only
> > returns 1300 rows or so. I tested the SQL statement and it runs very
> > quickly through Query Analyzer. Here's my specs.
> >
> > VB.Net (1.1)
> > Crystal Reports V 9.1.5000.0
> > SQLServer 2000
> > Windows XP
> >
> > The code runs fine right up until I open the report in the report
> > viewer...
> >
> > oRptForm.Show()
> >
> > ...the load takes about 10 minutes. All of setup code (constructors
> > and setup functions) for the RptViewer run fine it's only the .Show()
> > that the delay shows up.
> >
> > Any ideas? Any Suggestions?
> >
> > Thanks in advance for any help.
> >
> > Mike Gorgone
> > Software Engineer
> > m_gorgone@hotmail.com

Relevant Pages

  • Multi Site/Web Serverhosted XML Report loader
    ... I have a WAN network w/ Multi Web server hosting "Internal XML files" ... I would like to have the XML file hosted at ... reporting app and low responsibility and lag of transferring the XML ... report file to the main server. ...
    (microsoft.public.dotnet.xml)
  • Batch Printing Crystal reports from VB.Net application
    ... Each xml file ... a crystal report, and prints the report to the specified printer. ... as some printers only printed garbage. ... everyone used the same high performance printers, ...
    (microsoft.public.vb.crystal)
  • Data field
    ... I have a report project that is linked to an xml file. ... has a picture on witch data field has been inserted. ... The xml element will always have 4 records with 3 childs and one of these ...
    (microsoft.public.vb.crystal)
  • Re: GDI+ on Windows Forms
    ... elements in the report once it has been drawn, so I don't need to handle any ... Also if I invalidate the listbox, ... reprocess the XML file again to re-draw everything. ... > If you only need to draw the items as a list, ...
    (microsoft.public.dotnet.framework.windowsforms)
  • SAX/Python : read an xml from the end to the top
    ... I currently have an xml input file containing lots of data. ... However, the other xml file ... Everytime we run the script, we track the new elements in the input ... _ report all the new events. ...
    (comp.lang.python)