Home > Crystal Reports > Crystal Reports 9 Not Supported Error

Crystal Reports 9 Not Supported Error

limit.) Question: (Please be specific.) Tags: (Separate with commas.) What is a Tag? The stored procedure you are showing is an UPDATE procedure and doesn't return a record set so Crystal cannot use it. I have tried a number of different data sets with the report and they all produce the same error. History Contributors Ordered by most recent Bambele30 pts. check my blog

I'm also able to connect to other DSNs. Subscribe to our monthly newsletter for tech news and trends Membership How it Works Gigs Live Careers Plans and Pricing For Business Become an Expert Resource Center About Us Who We Microsoft SQL Server ODBC Driver Version 03.85.1117 I've tried a native SQL odbc driver and the OLE DB (ADO) with the SQL Server OLE DB driver as well. Add a select statement to check if the error will disappear.

By submitting you agree to receive email from TechTarget and its partners. I've done a lot of problem solving, and followed some suggestions on the net that I've seen, even though they are limited and not specific to my problem. Close Reply To This Thread Posting in the Tek-Tips forums is a member-only feature.

And that was it, the report should now work. This enables me to display only the regions I want in the report as well as get proper totals for just those regions. Should Crystal not be able to do this? Oracle Database MS SQL Server Unix OS Extract Information From SQL Server Catalog Views Video by: Steve Via a live example combined with referencing Books Online, show some of the information

I have no problems choosing other stored procedures and/or tables with the same connection. By submitting you agree to receive email from TechTarget and its partners. Please enter an answer. I don't think there is anything to convert like that.

Connect with top rated Experts 15 Experts available now in Live! Connect with top rated Experts 16 Experts available now in Live! Forum New Posts FAQ Calendar Forum Actions Mark Forums Read Quick Links Today's Posts View Site Leaders What's New? If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.

The Stored Proc runs just fine. http://forums.codeguru.com/showthread.php?436703-quot-not-supported-quot-error-in-crystal-8-help-please I don't get any data back in the application, it goes directly to Crystal. If you can't create a new report to call that procedure then it is likely the connection between Crystal and the SQL database is not working. 0 Message Author Comment Registration on or use of this site constitutes acceptance of our Privacy Policy.

Can you browse any data fields? click site Join and Comment By clicking you are agreeing to Experts Exchange's Terms of Use. I'd really appreciate any help or suggestions for where to go next with this as I've hit the wall with my own investigations. Can you quickly put another together that executes the same stored procedure just to see if it is the report itself?

John IP Logged Printable version Forum Jump -- Select Forum -- Announcements Talk with the Author Self-Publishing Job Postings New feature request Report Design Data Connectivity Technical Questions Tips and Tricks Privacy Reply Processing your reply... The grand total for the report is for all regions and not just the regions I've selected in the groupselectionformula. news Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Register Hereor login if you are already a member E-mail User Name Password Forgot Password? Login with LinkedIN Or Log In Locally Email Password Remember Me Forgot Password?Register ENGINEERING.com Eng-Tips Forums Tek-Tips Forums Search Posts Find A Forum Thread Number Find An Expert Resources Jobs Resources Join | Indeed Jobs | Advertise Copyright © 1998-2016 ENGINEERING.com, Inc.

There are shared variables between the main report and all 4 subreports.

Can you test the connection? As for summing up in the application and passing that total as a parameter, again, the source of my report is a stored proc. I've used BO's special query tool to check the data as well. (SQLCon32) I can create simple reports that hit this Database. I was instructed to completely uninstall Crystal and remove all references from my vb project.

Privacy Follow Thanks! It works fine when executed via SQL Server Management Studio. We have on the company I work for an application built in Delphi V with Crystal Reports 8. http://ogdomains.com/crystal-reports/crystal-reports-not-supported-error.php Click Here to join Tek-Tips and talk with other members!

Add a select statement to check Go to Solution 3 3 +1 4 Participants Lee Savidge(3 comments) LVL 25 MS SQL Server15 Crystal Reports1 imstac73(3 comments) mlmcc LVL 100 Crystal Reports94 Make a "Ceeeeeeee" program how does 2*4*6....(2n) turn into 2^n* n! We'll send you an e-mail containing your password. If I leave the three fields out then the report runs fine, if I put them in then the report is returned as blank and a pop-up box appears twice with

It is possible the report is corrupt in some way. Advanced Search Forum Other Programming Crystal Reports "not supported" error in crystal 8 - help please If this is your first visit, be sure to check out the FAQ by clicking They have just upgraded the MSSQL 2000 database to MSSQL 2008 and the daily report fails with a 'Not supported' error message, on the larger brand of stores, but not on Back to top charlottecraigSenior MemberJoined: 20 Jun 2006Posts: 84 Posted: Wed Aug 09, 2006 12:04 pmPost subject: Re: Mysterious "Not Supported" error Database Driver?

To start viewing messages, select the forum that you want to visit from the selection below. Here is my procedure: -- Add parameter for top paid amount @toppaidamt money AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT On which physical drive is this logical drive? Thanks.

Can you browse any data fields? I created a test stored procedure that did a select statement with the same input parameter and where clause and it worked fine. Select pairs to match them. 4. Yes I can test the connection.

We'll let you know when a new response is added. That fixed the problem. 0 LVL 8 Overall: Level 8 Crystal Reports 3 Message Expert Comment by:MOA812007-08-31 Comment Utility Permalink(# a19812890) Thanks ROTRTechTeam: 0 LVL 1 Overall: Level 1 Join Now For immediate help use Live now! Exchange PRTG Quick Overview (07:27) Video by: Kimberley Get a first impression of how PRTG looks and learn how it works.

I am using version XI Version, Any ideas on how to resolve this error?Thanks in advance for any help...