意见需要：Crystal Reports与其他任何东西相比，一个人自己的实现 [英] Opinion needed: Crystal Reports vs. anything else vs. One's own implementation

问题描述

我将开发一个开发基于网络的报告系统的新项目。

我从BI组获得的第一个要求是 ;我们只想查看

数据。基本上，有一个庞大的数据库，他们希望某些人能够深入了解他们想要的数据，也许这里有一些图表和

那里，以及然后将所选数据提取到Excel文件或平面文件中进行进一步分析。截至目前，有一些参数需要

来过滤。

我的问题是直截了当，这是值得的

进入Crystal或任何其他报告工具？我从未有过很好的经历

Crystal;并且它们在.NET版本中导出到Excel选项会使excel

文件无法用于任何进一步的数据分析（它会进行大量的单元合并以及

谁知道还有什么）。有没有其他报告工具易于使用和

程序可以完成这些要求（特别是导出到

Excel功能）。或者我应该使用

DataGrids和一些图表组件来开发自己的Web应用程序？我真的很感激您的意见。

提前谢谢。

Hi,
I will be taking on a new project developing a web-based "reporting system".
The first requirement I got from BI group is "we just want to look at the
data". Basically, there is a huge database, and they want certain people to
be able to drill down to the data they want, perhaps a few graphs here and
there, and then extract selected data to an Excel file or a flat file for
further analysis. As of now there are a handful of parameters that they want
to filter on.
My question is for something straight forward as this, is it worth going
into Crystal or any other reporting tool? I never had a good experience with
Crystal; and their export to Excel option in .NET version renders an excel
file useless for any further data analysis (it does bunch of cell merges and
who knows what else). Is there any other reporting tool easy to use and
program against that can accomplish these requirements (especially export to
Excel feature). Or should I just develop my own web application with
DataGrids and some charting components? I would really appreciate to hear
your opinions.
Thank you in advance.

推荐答案

" LP" < [e-mail]>在新闻中写道：＃8 ************** @ TK2MSFTNGP14.phx.gbl：

"LP" <[e-mail]> wrote in news:#8**************@TK2MSFTNGP14.phx.gbl:

我的问题是直截了当的，因为这是它值得
进入Crystal或任何其他报告工具？我从未有过与Crystal相关的良好体验;

My question is for something straight forward as this, is it worth
going into Crystal or any other reporting tool? I never had a good
experience with Crystal;

水晶的最大问题是报告限制在~50,000

数据库行。任何返回的查询> 50,000行将杀死IIS +

水晶。


为了解决这个限制，你必须在
$上进行所有计算b $ b服务器端并返回格式良好的结果集。这可能或者可能不会是一个很好的解决方案，这取决于你的SQL服务器有多强大。


-

Lucas Tam （RE********@rogers.com）

请删除删除来自回复时的电子邮件地址。
http：//成员。 ebay.com/aboutme/coolspot18/

确保在跳转之前阅读RS新闻组。从我已经阅读的内容来看，RS在出口到

Excel时遇到的问题不仅仅是公平的。请记住，它是一个1.0产品，它通常需要MS几个版本

才能保持稳定且功能齐全。


" Scott Allen" < SC *** @ nospam.odetocode.com>在消息中写道

新闻：h5 ******************************** @ 4ax.com ...

Make sure you read the RS newsgroups before making the jump. From what I''ve
been reading, RS has more than its fair share of problems exporting to
Excel. Remember, it''s a 1.0 product and it usually takes MS a few releases
before they have something stable and feature complete.

"Scott Allen" <sc***@nospam.odetocode.com> wrote in message
news:h5********************************@4ax.com...

您是否拥有SQL Server许可证？如果是这样，您应该尝试使用SQL Server
Reporting Services，因为您还可以获得许可证。到报告工具为止 - 它还不错。
http://www.microsoft.com/sql/reporting/default.asp

-
Scott
http://www.OdeToCode.com/blogs/scott/

On Sun，2005年2月13日22:40:50 -0500，LP < [e-mail]>写道：

Do you have a SQL Server license? If so, you should get SQL Server
Reporting Services a try as you''ll have a license for it also. As far
as Reporting Tools go - it''s not too bad.
http://www.microsoft.com/sql/reporting/default.asp

--
Scott
http://www.OdeToCode.com/blogs/scott/

On Sun, 13 Feb 2005 22:40:50 -0500, "LP" <[e-mail]> wrote:

我将开发一个新项目，开发一个基于网络的报告
系统。我从BI获得的第一个要求group是我们只想查看
数据。基本上，有一个巨大的数据库，他们希望某些人能够深入挖掘他们想要的数据，也许这里有一些图表
andthere，然后将所选数据提取到Excel文件或者平面文件进一步分析。截至目前，还有一些参数，他们想要过滤掉它们。
我的问题是直截了当的事情，是否值得进入Crystal或任何其他报告工具？我从未有过
withCrystal的好经验;并且它们在.NET版本中导出到Excel选项会导致
excelfile无法用于任何进一步的数据分析（它会将一堆单元格合并为
并且知道还有什么）。是否有任何其他报告工具易于使用，并且针对该程序可以实现这些要求（尤其是导出
toExcel功能）。或者我应该使用
DataGrids和一些图表组件开发自己的Web应用程序？我真的很感激听到您的意见。
提前谢谢。

Hi,
I will be taking on a new project developing a web-based "reporting system".The first requirement I got from BI group is "we just want to look at the
data". Basically, there is a huge database, and they want certain people tobe able to drill down to the data they want, perhaps a few graphs here andthere, and then extract selected data to an Excel file or a flat file for
further analysis. As of now there are a handful of parameters that they wantto filter on.
My question is for something straight forward as this, is it worth going
into Crystal or any other reporting tool? I never had a good experience withCrystal; and their export to Excel option in .NET version renders an excelfile useless for any further data analysis (it does bunch of cell merges andwho knows what else). Is there any other reporting tool easy to use and
program against that can accomplish these requirements (especially export toExcel feature). Or should I just develop my own web application with
DataGrids and some charting components? I would really appreciate to hear
your opinions.
Thank you in advance.

我同意水晶的声音喜欢矫枉过正以满足您的要求。

为什么不切入追逐并直接导出到Excel？


以下是一些例子：
http://SteveOrr.net/Articles/ExcelExport.aspx
http://SteveOrr.net/Articles/ExportPanel.aspx
< a rel =nofollowhref =http://SteveOrr.net/export.aspxtarget =_ blank> http://SteveOrr.net/export.aspx


-

我希望这会有所帮助，

Steve C. Orr，MCSD，MVP
http://SteveOrr.net

" LP" < [e-mail]>在留言中写道

新闻：％2 **************** @ TK2MSFTNGP14.phx.gbl ...

I agree that Crystal sounds like overkill for your requirements.
Why not cut to the chase and export directly to Excel?

Here are some examples:
http://SteveOrr.net/Articles/ExcelExport.aspx
http://SteveOrr.net/Articles/ExportPanel.aspx
http://SteveOrr.net/export.aspx

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://SteveOrr.net
"LP" <[e-mail]> wrote in message
news:%2****************@TK2MSFTNGP14.phx.gbl...

我将开发一个开发基于网络的报告系统的新项目。
我从BI小组得到的第一个要求是我们只想看看<数据。基本上，有一个庞大的数据库，他们希望某些人能够深入了解他们想要的数据，也许这里有一些图表，然后提取所选数据到Excel文件或平面文件进行进一步分析。截至目前，他们希望过滤一些参数。
我的问题是直截了当的事情，是否值得进入Crystal或任何其他报告工具？我从来没有一个很好的经历
水晶;并且它们在.NET版本中导出到Excel选项会使excel
文件无法用于任何进一步的数据分析（它会进行大量的单元合并
和
谁知道还有什么）。是否有任何其他报告工具易于使用，并且针对它的程序可以实现这些要求（特别是导出到Excel功能）。或者我应该使用
DataGrids和一些图表组件开发自己的Web应用程序？我非常感谢您听到您的意见。
提前感谢您。

Hi,
I will be taking on a new project developing a web-based "reporting
system".
The first requirement I got from BI group is "we just want to look at the
data". Basically, there is a huge database, and they want certain people
to
be able to drill down to the data they want, perhaps a few graphs here and
there, and then extract selected data to an Excel file or a flat file for
further analysis. As of now there are a handful of parameters that they
want
to filter on.
My question is for something straight forward as this, is it worth going
into Crystal or any other reporting tool? I never had a good experience
with
Crystal; and their export to Excel option in .NET version renders an excel
file useless for any further data analysis (it does bunch of cell merges
and
who knows what else). Is there any other reporting tool easy to use and
program against that can accomplish these requirements (especially export
to
Excel feature). Or should I just develop my own web application with
DataGrids and some charting components? I would really appreciate to hear
your opinions.
Thank you in advance.

这篇关于意见需要：Crystal Reports与其他任何东西相比，一个人自己的实现的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！