寻找报告工具 [英] Looking For Report Tool
问题描述
我正在使用VSNET 2003，VB.NET和ASP.NET以及SQL Server 2000作为
数据库。我已经使用Crystal Reports多年了，主要是在
VB6中使用RDC和/或使用Access作为数据库的独立报告。
我有SQL Server中的一些表CR（CR 8.5）似乎无法正确处理
。如果我的报告引用了这些表中的任何一个，我会收到一条错误消息：
有一个无效句柄当我试图保存报告时，CR没有看到
看到数据。我知道我已获得完全许可，并且我已经尝试了创建视图，以便CR不必处理任何联接 - 没有帮助。
另外，在SQL Server中，我在表中有一些varChar字段，这些字段是500个字符
long。 CR将数据减少到255？
b br />
任何建议赞赏
Wayne
I am using VSNET 2003, VB.NET and ASP.NET with an SQL Server 2000 as the
database. I''ve used Crystal Reports for several years, mostly using RDC in
VB6 and/or standalone reports that used Access as the database.
I have some tables in SQL Server that CR (CR 8.5) cannot seem to handle
correctly. If my report references any of these tables I get an error saying
there is an "Invalid Handle" when I try to save the report and CR does not
appear to see the data. I know I have full permission and I''ve tried
creating Views so that CR doesn''t have to deal with any JOINs - no help.
Also, in SQL Server I have some varChar fields in a table that are 500 chars
long. CR cuts the data off at 255?
Anyway, does anyone have a suggestion for an alternative to CR? I need to be
able to create and run standalone reports against SQL Server tables and I
also need to have tables I can run from within my VB.NET apps.
Any suggestions appreciated
Wayne
推荐答案
我听说过有关SQL Server Reporting Services的好消息。
http://www.microsoft.com/sql/reporting/default.asp
Ken
----------------
" Wayne Wengert" < WA *************** @ wengert.com>在消息中写道
news：O
Hi,
I have heard good things about SQL Server Reporting Services.
http://www.microsoft.com/sql/reporting/default.asp
Ken
----------------
"Wayne Wengert" <wa***************@wengert.com> wrote in message
news:O
************** @ tk2msftngp13.phx.gbl ...
**************@tk2msftngp13.phx.gbl...
我使用VSNET 2003，VB.NET和ASP.NET以及SQL Server 2000作为数据库。我已经使用了Crystal Reports好几年了，主要是在VB6中使用RDC和/或使用Access作为数据库的独立报告。
我在SQL Server中有一些表CR（ CR 8.5）似乎无法正确处理
。如果我的报告引用任何这些表格，我会收到错误
说
有一个无效句柄当我尝试保存报告时，CR似乎没有看到数据。我知道我有完全的许可，我已经尝试创建视图，这样CR就不必处理任何JOIN了 - 没有帮助。
另外，在SQL Server中我有表格中的一些varChar字段长度为500
。 CR在255处削减数据？
无论如何，是否有人建议替代CR？我需要能够针对SQL Server表创建和运行独立报告，我还需要在我的VB.NET应用程序中运行表格。
任何建议赞赏
Wayne
I am using VSNET 2003, VB.NET and ASP.NET with an SQL Server 2000 as the
database. I''ve used Crystal Reports for several years, mostly using RDC in
VB6 and/or standalone reports that used Access as the database.
I have some tables in SQL Server that CR (CR 8.5) cannot seem to handle
correctly. If my report references any of these tables I get an error
saying
there is an "Invalid Handle" when I try to save the report and CR does not
appear to see the data. I know I have full permission and I''ve tried
creating Views so that CR doesn''t have to deal with any JOINs - no help.
Also, in SQL Server I have some varChar fields in a table that are 500
chars
long. CR cuts the data off at 255?
Anyway, does anyone have a suggestion for an alternative to CR? I need to
be
able to create and run standalone reports against SQL Server tables and I
also need to have tables I can run from within my VB.NET apps.
Any suggestions appreciated
Wayne
我听说过有关SQL Server Reporting Services的好消息。
http://www.microsoft.com/sql/reporting/default.asp
肯
------- ---------
" Wayne Wengert" < WA *************** @ wengert.com>在消息中写道
news：O
Hi,
I have heard good things about SQL Server Reporting Services.
http://www.microsoft.com/sql/reporting/default.asp
Ken
----------------
"Wayne Wengert" <wa***************@wengert.com> wrote in message
news:O
这篇关于寻找报告工具的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
