Re: Subreport slows down

From: Bob Holmes (rholmes_at_REMOVEmmwec.org)
Date: 03/30/04 

Date: Tue, 30 Mar 2004 16:38:35 -0500

Paul,
    I'm going to try your method. Until now, all of my reports have been
accessed by users though Crystal Enterprise. This is why I have been
talking about sp's and views rather than any of the methods using code from
a front-end. I have not needed to create any front-ends. We are in the
process of replacing some of our legacy systems and there will be a need for
some reporting within the application. I need to experiment with a number
of things, including the RDC, to find out what method might be best for this
circumstance. Thank you for reminding me of one more way to work with my
reports. 

--
Bob Holmes MCNGP #31
<pjm@see_my_sig_for_address.com> wrote in message
news:hsmj609v2378h5qiqdb0kg7dphm114inap@4ax.com...
> On Tue, 30 Mar 2004 15:04:44 -0500, "Bob Holmes"
> <rholmes@REMOVEmmwec.org> wrote:
>
> >Paul,
> >    I agree with all of your posts.  When I first started working with
CR, I
> >was doing everything within the report.  When I got to some fairly
complex
> >reports I found that they were taking hours to process.  I kept reading
> >about using stored procedures, but didn't know what they were.  I did
some
> >research and found out that they were a database tool and not part of CR.
> >Once I moved my query from one of the complicated reports to the
database,
> >whether a sp or a view, my report took seconds instead of hours.  I also
> >like the fact that I can manipulate the data (cast as different data
types,
> >perform calculations, etc.) within the database, so that by the time CR
sees
> >my 'data' it doesn't need to do much beyond displaying.
>
> Yep.  I think it does a nice job of that, but I think it's not
> a very good data processing engine.
>
> >  I don't have to
> >create a lot of formulas in CR or do a lot of sorting, etc.  Your method
of
> >using a recordset seems to be a similar process whereby you remove the
> >processing from CR and use it only for displaying the data.
>
> Yes.  It can also be combined very nicely, of course, with
> SP's and Views, etc.  View + View + View into ( SP called from SP )
> into SP, into VB, repeat as needed, then into CR.
>
> It's all about 'what is most effective' (within ' what is
> needed ?' ), and 'where does this processing actually happen ?  Server
> ?  Client ?  MS-SQL ?  Other app ?
>
> >  This is what
> >makes it so much faster.  Put the tools available to their best use.
>
> I do let CR ' just do its thing' for some reports, generally
> the simple 'show me all of this table' ones.
>
> Anything more than that, I really feel more comfortable
> building the complex datasets in the environment I'm familiar with,
> VB, using things I'm familiar with like ADO, Views, Queries, etc.  I'm
> not much for SP's just because I don't know them, and I don't like the
> design environment.
>
> I would point out to the OP here that just because something
> runs fast in Enterprise Manager, that doesn't mean it runs fast from a
> client app ( CR, VB, Access, etc ).  EM is cool, I love it, I live in
> it sometimes, but keep in mind that EM processes always happen on
> server, whereas other interfaces may cause the same process to happen
> on client, which can mean transmitting massive amounts of data over
> the LAN, etc, or less efficient processing within the client tool as
> opposed to SQL.
>
>
>
> Paul ( pjm @ pobox . com ) - remove spaces to email me
> 'Some days, it's just not worth chewing through the restraints.'
>
> HVAC/R program for Palm PDA's
> Free demo now available online !!  http://pmilligan.net/palm/
> Free superheat charts for 38 Ref's online at http://pmilligan.net/pmtherm/

Relevant Pages

  • Re: Convert Access application to .NET?
    ... I am learning as I go and the client does not want to ... I had assumed that the instability came from the UI, not the database. ... do you know how Crystal Reports compares to the reports in Access. ... We decided to convert the whole app to .Net. ...
    (microsoft.public.dotnet.framework.windowsforms)
  • need some help with this solution...
    ... I have a new client (an ag pesticide sprayer) and he has a piece of software that generates reports about all the chemicals that he sprays on any particular day. ... f) as a side note, if someone could explain a little about cron jobs, as i would want the database backed up nightly and have the db file emailed to my inbox. ...
    (alt.php)
  • Re: excel sheet creation??
    ... I still think you should add thise functionality in your database. ... Otherwise you have to store all the information in Excel also. ... > gets talks to the database - but the custom reports don't have all ... > client per hour - which is determined by the total fee we invoice to ...
    (microsoft.public.excel.misc)
  • Identifying Tables And Queries Used in Reporting Code
    ... I have developed a large system for a client based on ... reports that have been coded. ... It is a single user database and my clients ... documentation on which reports rely on which tables and queries. ...
    (microsoft.public.access.reports)
  • Re: Copying reports from one database to another
    ... you can EXPORT most any object to another database. ... REPORTS section and highlight a report. ... PLAN C: Copy and rename the entire database using windows explorer, ... We prepare 4-5 reports for each client. ...
    (microsoft.public.access.reports)