473,405 Members | 2,282 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,405 software developers and data experts.

SHould I use Crystal Reports or Active Reports?

VMI
I know this may not be the best NG for this, but I feel you guys know more
about this than any of the other NGs.

I need to build several simple reports (over 50 of them and they get their
data from sql server) and I was wondering whish of these is the better tool
.. We're still not sure if they'll be loaded from an existing VB6 application
or if I'll have to make a separate module for them (in .Net).
In general, which is the better tool? Since they'll be part of another
application (the VB6 module or the .Net module), we don't want the client to
spend more money on licencing fees (except the $$$ I spend on the copy of
Crystal or Active Reports to develop the reports).

Any help is appreciated.
Feb 10 '06 #1
3 8899
On Fri, 10 Feb 2006 13:54:29 -0500, "VMI" <vonchi_m AT yahoo DOT com>
wrote:
I know this may not be the best NG for this, but I feel you guys know more
about this than any of the other NGs.

I need to build several simple reports (over 50 of them and they get their
data from sql server) and I was wondering whish of these is the better tool
. We're still not sure if they'll be loaded from an existing VB6 application
or if I'll have to make a separate module for them (in .Net).
In general, which is the better tool? Since they'll be part of another
application (the VB6 module or the .Net module), we don't want the client to
spend more money on licencing fees (except the $$$ I spend on the copy of
Crystal or Active Reports to develop the reports).

Any help is appreciated.

In my opinion the answer to your question depends on how you intend to
create the reports:

1. Crystal Reports is primarily designed to be used by a person who
creates reports without calling them from a program. Using Crystal
Reports from this developer's point of view isn't a good solution if
you must populate and display the reports from an application.

2. On the other hand Active Reports is designed primarily to be used
from within an application. It has events that can be triggered, etc.
to let you do some decision making while generating the output. The
last time I used Crystal Reports it was not capable of doing that.

Otis Mukinfus
http://www.otismukinfus.com
http://www.tomchilders.com
Feb 11 '06 #2
> 1. Crystal Reports is primarily designed to be used by a person who
creates reports without calling them from a program. Using Crystal
Reports from this developer's point of view isn't a good solution if
you must populate and display the reports from an application.


We are doing exactly this, but you are right: Crystal isn't too bright
when it comes to the "push" model, although it's not bad for simple
requirements.

Crystal basically lets you build a report from an XSD file (which you
can generate from an ADO.NET DataSet. Then at run time you can build
data into that same "shape" of DataSet and then push the data to
Crystal, along with the report (rpt) file you built in the designer.

It works just fine, but the Crystal .NET objects don't allow you a lot
of control at run time. You basically design the report and then push
data at it.

If you have more complex requirements then maybe something else would
be better.

Otis: Could you provide a link to Active Reports? I've never heard of
it, and we would love to have an alternative to Crystal.

Feb 11 '06 #3
On 11 Feb 2006 10:25:46 -0800, "Bruce Wood" <br*******@canada.com>
wrote:
1. Crystal Reports is primarily designed to be used by a person who
creates reports without calling them from a program. Using Crystal
Reports from this developer's point of view isn't a good solution if
you must populate and display the reports from an application.


We are doing exactly this, but you are right: Crystal isn't too bright
when it comes to the "push" model, although it's not bad for simple
requirements.

Crystal basically lets you build a report from an XSD file (which you
can generate from an ADO.NET DataSet. Then at run time you can build
data into that same "shape" of DataSet and then push the data to
Crystal, along with the report (rpt) file you built in the designer.

It works just fine, but the Crystal .NET objects don't allow you a lot
of control at run time. You basically design the report and then push
data at it.

If you have more complex requirements then maybe something else would
be better.

Otis: Could you provide a link to Active Reports? I've never heard of
it, and we would love to have an alternative to Crystal.


I sure can.

http://www.datadynamics.com/forums/64/ShowForum.aspx

The nice thing about Active Reports is that you can build reports in
code from "boilerplate" sub reports.

I did a gig with an orphanage a few years ago that needed to keep
reports on the care of their children that matched up with state and
fed laws, so as you can imagine they were complex and many of them had
the same wording from one form to another.

To make things easier we were able to do a lot of "design" on the fly
design based on the content of the variables in the report.

By the way, I don't work for them. I just think they have a product
that is superior to Crystal Reports.

As for Crystal Reports, it has it's place. I once worked at a place
with a dedicated report designer who worked only with Crystal using
SQL queries. In that environment Crystal Reports does well.

Otis Mukinfus
http://www.otismukinfus.com
http://www.tomchilders.com
Feb 12 '06 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Raghuraman | last post by:
Hai , Please forgive me for asking about Crystal reports in Database groups (I also sent a post to cLIENT SERVER) My clients have system with the windows 95 & 95.If i install the crystal...
2
by: MyD0j0 | last post by:
Hello, Hoping someone can point me in the direction of using the crystal reports controls provided for MS Access 2000. Accross our business, we have a common web reporting tool for our $8Billion...
7
by: Sink | last post by:
Hi, Looking at reporting tools and was wondering if anyone else has gone thru this. Crystal seems rediculously expensive once you take into account licensing, while Active is runtime-free meaning...
7
by: p | last post by:
WE had a Crystal 8 WebApp using vs 2002 which we upgraded to VS2003. I also have Crystal 9 pro on my development machine. The web app runs fine on my dev machine but am having problems deploying....
3
by: Rod | last post by:
I've got a Crystal Reports for Visual Studio.NET 2003 that I wrote. Up until now, I have been able to run it just fine, however, I had to change the access method to use Active Directory. (It...
1
by: Manny | last post by:
I'm having a problem constructing an ASP.NET page that displays a Crystal Reports .rpt file using the CrystalReportViewer Control. Everytime I execute it from VS.NET 2003 it never loads and "hangs"...
3
by: Radman | last post by:
I have installed VS 2005 and dowloaded VS2005 Walkthroughs for Crystal Reports. I was not able to complete the walkthrough. The VB Code appears to be incomplete in fact when I tried to build the...
0
by: PughDR | last post by:
As the subject of this topic suggestions I am trying to find a way to use ASP, SQL Server, Com+ and Crystal Reports 8.5 to Create Dynamic PDF Reports Over The Web, but the only article I found that...
4
by: =?Utf-8?B?Z2lkZHk=?= | last post by:
hi, I posted here earlier with a great reply:...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.