473,320 Members | 1,982 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,320 software developers and data experts.

Looking For Report Tool

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
Nov 22 '05 #1
0 861

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

Similar topics

9
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:...
10
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...
0
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...
2
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...
3
by: tommy | last post by:
I am working with the Invoice report in the Northwind sample database. How can I see the SQL statement that provides the data to the report? Thanks.
2
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...
0
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...
6
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,...
1
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...
6
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...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.