Can Crystal Reports be integrated in an Access97 runtime environment?

[Tony Ciconte]

We are evaluating the prospect of integrating and/or using Crystal
Reports with some of our current products. Some of these are still in
Access 97 and are running well. Since we cannot include the report
wizard in a runtime environment, we are looking at ad hoc report
writers like Crystal.

Can we include Crystal with our runtimes and/or is there another
report writer that we should be looking at? Any and all help is
greatly appreciated.

TC

 

[Larry Linson]

We are evaluating the prospect of integrating and/or using Crystal
Reports with some of our current products. Some of these are still in
Access 97 and are running well. Since we cannot include the report
wizard in a runtime environment, we are looking at ad hoc report
writers like Crystal.

Can we include Crystal with our runtimes and/or is there another
report writer that we should be looking at? Any and all help is
greatly appreciated.

Especially as you are still deciding on a Report Writer, this seems an
excellent question to ask the manufacturer of Crystal Reports. It may depend
on how you have your runtimes set up, security, etc., but the Crystal
Reports folks would be the ones who should have the information.

Larry Linson
Microsoft Access MVP

 

[aaron.kempf]

honestly; access has the best reporting anywhere; i dont know why in
the hell you would want to do that.

don't you wish you could subreport like me?
don't you?
don't you?

-Aaron

 

[Mr B]

Actually there are some quite valid reasons for doing what this question is
asking. I can think of at least one very good reason.

Tony,

I have had an occasion to talk to Crystal about this and they assure me that
it is possible to use the reference to the Crystal library and use the
predefined Crystal reports.

Also, it is possible to allow users of your application to modify reports,
provided that they have a copy of Crystal Reports, Standard edition (the
least expensive version)

 

[Larry Linson]

honestly; access has the best reporting
anywhere; i dont know why in
the hell you would want to do that.

I agree with you that Access has the best reporting I have found in any
software product. But, that was not the question that the O.P. asked.

don't you wish you could subreport like me?
don't you?
don't you?

I don't know because I haven't seen any of your Subreports, but because the
only reporting mechanism I use is Access Reports, I do use Subreports when
appropriate.

Larry Linson
Microsoft Access MVP

 

[aaron.kempf]

crystal can only subreport one level deep

or something ridiculous like that

i ran into it a ton; when i was converting mdb-> crystal reports; about
100 reports in a month about 4 years ago

-aaron

 

[SusanV]

How do you allow users to create reports (create = design new) when
deploying MDE's? IIRC, that was the OP's original problem, and I'd love to
get around it myself...

SusanV

 

[SusanV]

Wow, excellent response! That's what I thought - no way around it for MDE,
and they are NOT getting an MDB - too many problems in the past with things
being altered or deleted. Your other suggestions sound interesting, but are
far too labor intensive for the minimal advantages returned, at least in
this case. Being as I'm in-house, when users need new reports I do the
design for them, then redistribute the MDE frontend, and that's working for
us.

Thanks, Rick, for taking the time to lay that all out so clearly

SusanV

 

[aaron.kempf]

Rick

you're a paranoid fucking retard and you should learn how to use access
before talking shit.

wait a second.

I agree with what you're saying for data warehouses.

What you say here though:

That's a good thing, bacause you should never, ever let users create objects
in any live application object or have direct access to data stores.

I spit on you and your mothers grave; because you are just flat-out
wrong.

-Aaron

 

[Tim Marshall]

I spit on you and your mothers grave; because

Ummm, I must be missing something. What did this guy do to provoke such
a reaction?

Do you swat flies with an artillery barrage instead of a flyswatter?

Good heavens...

 

[Larry Linson]

you're a paranoid f***ing retard and you
should learn how to use access before
talking s**t.

wait a second.

I agree with what you're saying for data warehouses.

And, if it made Rick what you describe, what does that make you?

What you say here though:

I spit on you and your mothers grave; because
you are just flat-out wrong.

The drive-by poster strikes again, assuring that whatever he's aiming for,
he'll be _spitting into the wind_ with whatever he may have to offer here.

Larry Linson
Microsoft Access MVP