Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

MS SQL Server 2005 Reporting System-.NET versus Java reporting system.

Posted on 2007-04-05
6
247 Views
Last Modified: 2012-05-05
Hi experts,

I am needing some suggestions on choosing a robust reporting system. I am considering to use either MS SQL Server 2005 Reporting System-.NET or Java open-source reporting system such as JFreeChart, Jasper, etc. Based on your experiences, can you pls give me some insights as to which software is preferable compared to the other (i.e. what each can/can't do, robustness especially working with large volume of data, user-friendliness, stability, connectivity to different databases, query time) besides the fact that .NET can't run on UNIX server?
Your inputs are greatly appreciated.
0
Comment
Question by:indo81
  • 2
6 Comments
 
LVL 11

Accepted Solution

by:
MacNuttin earned 250 total points
ID: 18864003
Theres a zone here called http://www.experts-exchange.com/Database/Reporting_/  that may have your answer

I have used Crystal Enterprise and MS SQL Server 2005 Reporting System. For me I think Crystal makes the best reports but MS is better integrated with SQL server for things like scheduling reports triggering reports etc. I can't comment on JFreeChart but I'll bet you as far as "user-friendliness" it's last compared to MS Reporting or Crystal.
0
 
LVL 30

Expert Comment

by:Mayank S
ID: 18864168
JFreeReport is indeed, quite good:

http://www.jfree.org/jfreereport/index.php

If you have an MS SQL database, then you should be fine with MS SQL reporting system. However, I hope you are not introducing MS SQL Server into the picture just for the sake of reporting! What is your data repository? If it is MS SQL Server, you can just use its reporting features
0
 

Author Comment

by:indo81
ID: 18864209
Our data repository is Teradata. I understand that I should not introduce SQL Server just for the sake of reporting, however we are having some challenges with some BI tools and would like to consider some alternatives to get the data out.
0
 
LVL 30

Assisted Solution

by:Mayank S
Mayank S earned 250 total points
ID: 18864348
>> Our data repository is Teradata

Then you should not: >> introduce SQL Server just for the sake of reporting

I would vote for one of the open source reporting tools:

http://www.java-source.net/open-source/charting-and-reporting/datavision

See their features and pick the one you want
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Stored Proc - Rewrite 42 58
SQL Log size 3 17
MS SQL Delete Duplicate Rows Only 2 16
Substring works but need to tweak it 14 14
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question