[AccessD] Access and Crystal Reports

Drew Wutka DWUTKA at marlow.com
Mon Mar 10 10:41:00 CST 2003


Interesting.  The multithreading is taking place within the reporting
engine, not the interpretted User code.  Same with Access.  Access is
multi-threaded, VBA is not.  

Drew

-----Original Message-----
From: Shamil Salakhetdinov [mailto:shamil at smsconsulting.spb.ru]
Sent: Monday, March 10, 2003 3:15 AM
To: AccessD
Subject: Re: [AccessD] Access and Crystal Reports


<<<
Though CR doesn't allow for
> multi-threaded programming in the background...does it?
>>>
Drew,

I didn't try to do that but it might be possible based on the info in P.S of
this message.

> As far as VBA is concerned,
> it would be a little difficult to create a
> multi-threaded interpretted language.
I would say this is MS who made it that way - DELPHI supports
multi-threading since its first versions AFAIK - and the level of
programming on DELPHI is higher than on VB/VBA IMO(well DELPHI is compiled
language).
What is the problem to make multi-threaded interpreted language? - the core
of interpreter can easily control different threads - I don't see any
technocal  problems here - and you? What am I missing? (of course there
should be more limitations with 'edit and continue' debugging mode but just
limitations...)

> VBA is still a very powerful tool in the Access arsenal.
> (why would you want to multi-thread code behind a report anyways?
See P.S. for the reasons...

> There's something I couldn't come up with a scenario
> for....at least not for a report...a form
> would be something completely different.)
As I noted ONE CR's drill-down 'live' report can well substitute several MS
Access forms and reports - this is just a different reporting ideology,
another almost parallel universe with higher level of technological
evolution :) and with the gap from MS Access becoming more and more
perceptible with every new release...

Well, what was really bad in CR v.8.x - these are subreports(when you need a
lot of them for one report) - and this is a known fact - and CR application
developers managed to make advanced reports WITHOUT subreports - imagine
that! - as in all areas in this life when you gain in one area you loose in
another - so of course CR isn't 100% perfect...

With MS Access forever!

Shamil

P.S. Some facts about CR:

<<<+ quoting CR online line +>>>>
Optimized, multithreaded Report Engine
The Crystal Report Engine's enhanced multithreading capabilities and
thread-safe database drivers allow you to continue working on your important
tasks, while many other operations are processed simultaneously in the
background. The Report Engine also minimizes the number of passes made
through the data, speeds up processing with improved memory management, and
handles subreports and parameters as efficiently as possible.

<<<- quoting CR online line ->>>>

AND...

<<<+ quoting CR online line +>>>>
Page-on-demand technology
Page-on-demand report access lets users download only the specific report
pages they need to see, thus improving response times and reducing web
traffic. Further, placeholders and partial page technology allow you to view
report pages and data over the Web immediately, without having to wait for
the processing of large objects, such as graphics and subreports.

<<<- quoting CR online line ->>>>

FURTHER...

<<<+ quoting CR online line +>>>>
Scale with Crystal Enterprise Reports
Crystal Enterprise extends the value and scalability of Crystal Reports. It
provides eBusiness with a scalable, web-based solution for managing the
access and delivery of hundreds or thousands of Crystal reports to every
decision-maker-across the enterprise and beyond.

Crystal Enterprise provides a flexible, managed reporting solution. It gives
you the ability to deliver the report-design power of Crystal Reports, atop
a scalable, web-based infrastructure for managing a central report
repository, user security, and report scheduling and processing.

<<<- quoting CR online line ->>>>

And this isn't marketing hype or something like that - I've a colleague who
because of his using C++ and of Crystal reports (and of course he is a very
smart programmer) upsized to the IIS his very advanced payroll/HRM system
system in SEVERAL weeks (less than a month) and he did all that ALONE.

Short info is here - http://www.fincomplex.com/ - with real screenshots -
and this software works in both modes: desktop or web-server based - one
have to just load another saved configuration settings pointing to the URL
of the WEB server...

BTW, this his CR-based technology/framework of desktop/LAN/WAN/Web reporting
can be reused...

----- Original Message -----
From: "Drew Wutka" <DWUTKA at marlow.com>
To: <accessd at databaseadvisors.com>
Sent: Monday, March 10, 2003 2:40 AM
Subject: RE: [AccessD] Access and Crystal Reports


> I agree on all of your statements.  (Though CR doesn't allow for
> multi-threaded programming in the background...does it?)
>
> As far as VBA is concerned, it would be a little difficult to create a
> multi-threaded interpretted language.  You can make a VB multi-thread
.exe,
> but you can't run it in debug mode.
>
> VBA is still a very powerful tool in the Access arsenal.  (why would you
> want to multi-thread code behind a report anyways?  There's something I
> couldn't come up with a scenario for....at least not for a report...a form
> would be something completely different.)
>
> Drew
>


<<< tail skipped for brevity >>>


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list