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
10  1615 
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... 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
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... 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
Thanks for the reply. The problem is that I just buy a SQL Server service -
I don't own the server. The provider I have wants $50/mo to provide the SQL
Server Reporting Services.
Wayne
"Ken Tucker [MVP]" <vb***@bellsouth.net> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl... 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...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
Thanks for the reply. The problem is that I just buy a SQL Server service -
I don't own the server. The provider I have wants $50/mo to provide the SQL
Server Reporting Services.
Wayne
"Ken Tucker [MVP]" <vb***@bellsouth.net> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl... 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...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
I tried using Crystal Reports. Using the version that came with VS 2002, I
was able to work around most of the bugs. I wasn't able to get the version
with VS 2003 to even run on a client's machine. Ended up using
ActiveReports. Did everything I was trying to do with Crystal Reports plus
more, without any of the bugs.
That's my personal experience, your mileage may differ,
Richard Rosenheim
"Wayne Wengert" <wa***************@wengert.com> wrote in message
news:O$*************@tk2msftngp13.phx.gbl... Thanks for the reply. The problem is that I just buy a SQL Server
service - I don't own the server. The provider I have wants $50/mo to provide the
SQL Server Reporting Services.
Wayne
"Ken Tucker [MVP]" <vb***@bellsouth.net> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl... 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...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
I tried using Crystal Reports. Using the version that came with VS 2002, I
was able to work around most of the bugs. I wasn't able to get the version
with VS 2003 to even run on a client's machine. Ended up using
ActiveReports. Did everything I was trying to do with Crystal Reports plus
more, without any of the bugs.
That's my personal experience, your mileage may differ,
Richard Rosenheim
"Wayne Wengert" <wa***************@wengert.com> wrote in message
news:O$*************@tk2msftngp13.phx.gbl... Thanks for the reply. The problem is that I just buy a SQL Server
service - I don't own the server. The provider I have wants $50/mo to provide the
SQL Server Reporting Services.
Wayne
"Ken Tucker [MVP]" <vb***@bellsouth.net> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl... 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...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
For a FREE Product? How in the world does he justify that?
"Wayne Wengert" <wa***************@wengert.com> wrote in message
news:O$*************@tk2msftngp13.phx.gbl... Thanks for the reply. The problem is that I just buy a SQL Server
service - I don't own the server. The provider I have wants $50/mo to provide the
SQL Server Reporting Services.
Wayne
"Ken Tucker [MVP]" <vb***@bellsouth.net> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl... 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...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
For a FREE Product? How in the world does he justify that?
"Wayne Wengert" <wa***************@wengert.com> wrote in message
news:O$*************@tk2msftngp13.phx.gbl... Thanks for the reply. The problem is that I just buy a SQL Server
service - I don't own the server. The provider I have wants $50/mo to provide the
SQL Server Reporting Services.
Wayne
"Ken Tucker [MVP]" <vb***@bellsouth.net> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl... 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...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
Based on bandwidth, report server functions and storage.
Wayne
"William Ryan eMVP" <do********@comcast.nospam.net> wrote in message
news:uW**************@TK2MSFTNGP09.phx.gbl... For a FREE Product? How in the world does he justify that?
"Wayne Wengert" <wa***************@wengert.com> wrote in message
news:O$*************@tk2msftngp13.phx.gbl... Thanks for the reply. The problem is that I just buy a SQL Server
service - I don't own the server. The provider I have wants $50/mo to provide the
SQL Server Reporting Services.
Wayne
"Ken Tucker [MVP]" <vb***@bellsouth.net> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl... 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...
>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
>
>
Based on bandwidth, report server functions and storage.
Wayne
"William Ryan eMVP" <do********@comcast.nospam.net> wrote in message
news:uW**************@TK2MSFTNGP09.phx.gbl... For a FREE Product? How in the world does he justify that?
"Wayne Wengert" <wa***************@wengert.com> wrote in message
news:O$*************@tk2msftngp13.phx.gbl... Thanks for the reply. The problem is that I just buy a SQL Server
service - I don't own the server. The provider I have wants $50/mo to provide the
SQL Server Reporting Services.
Wayne
"Ken Tucker [MVP]" <vb***@bellsouth.net> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl... 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...
>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
>
>
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Chad Smith |
last post by:
Hello,
I'm relatively new to the database world so please forgive me in
advance for my ignorance. I have recently been tasked at my job with
finding a tool that will perform the following tasks:...
|
by: Danny J. Lesandrini |
last post by:
First, this is _not_ a question about how to get Crystal Reports to run
on a client machine. I've got all the merge modules added to the project
and it's working fine. The question is about...
|
by: Tom |
last post by:
I have a report where one field tends to be rather lengthly and ends
up being several lines long while another field has several short
entries. The problem I have is that the first of the short...
|
by: Mythran |
last post by:
In .Net, how can I go about and set a Crystal Reports namespace? Right now
they use the Root Namespace (VB) from the project. How can I extend the
namespace for a single report (which will be set...
|
by: Danny J. Lesandrini |
last post by:
Didn't get any takers on this post this morning at dotnet.General, so I'm
reposting here.
First, this is _not_ a question about how to get Crystal Reports to run
on a client machine. I've got...
| | |
by: Bob |
last post by:
I want to dump Crystal, one of the many reasons being that it requires a
client-side installation. I'm looking for a reporting package that
integrates into DotNet yet has absolutely no COM in it,...
|
by: Wayne Wengert |
last post by:
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...
|
by: MD |
last post by:
Hello
I work in a .NET environment and I am about to create a development
strategy. As part of this I am looking at implementing a testing tool
to fit in with an iterative approach and NUnit...
|
by: beantaxi |
last post by:
Hello all,
I'm looking for a very simple code analysis tool. I have a large
codebase to analyze, and all I really need to do is to find all uses
of all methods in a few interfaces.
Many tools...
|
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,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
| | |
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,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
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...
|
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: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...
| |
