Print Page | Close Window

Crystal Reports - Problems

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=888
Printed Date: 02 May 2025 at 10:06am


Topic: Crystal Reports - Problems
Posted By: varmabjr
Subject: Crystal Reports - Problems
Date Posted: 20 Jun 2007 at 2:29am

We had developed a web based application using .Net 2.0 (C#) , Crystal reports (bundled version within VS2005) on Window XP, SQL Server 2005, we are able to see all the reports on this development enviroment, but when the application is deployed on Windows 2003 server , IIS 6.0 and SQL server 2005 , we are not able to view the reports we are thrown with an error as

Failed to open a rowset. Details: ADO Error Code: 0x Source: Microsoft OLE DB Provider for SQL Server Description: Procedure or Function 'sp_xxxx' expects parameter '@ppppp', which was not supplied. SQL State: 42000 Native Error: Failed to open a rowset. Error in File

Could you please explain what the problem is ? as we are stuck with this problem for the migration of application to the user community.


Replies:
Posted By: BrianBischof
Date Posted: 20 Jun 2007 at 10:03am
I'm not sure of this error message's meaning, but when people tell me they have problems moving reports from the dev box to production, 99% of the time the problem is due to permissions. Either you don't have permission to the folder with the reports or the report doesn't have all permissions to the SQL database. This is pretty much the reason for all these problems.

That said, it sounds like you might actually be hitting the database but the SP doesn't have the parameter that CR expects. Is the SP/view IDENTICAL to what's on the dev box? Even the smallest difference (data type, param name, order etc.) can throw CR off. You know how picky computers are - you really have to be careful to make sure everything is identical.

I hope that helps.


-------------
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>

Posted By: JeremyDP
Date Posted: 25 Jul 2007 at 10:02am
I am getting this same error, however it is not a result of moving from DEV to PROD.  The odd thing is that it works as expected in the VS2005 IDE when I select the Main Report Preview tab from the report in question.
 
When I run the application (Start Debugging) and select to preview the report I get this error:
 
Failed to open a rowset. Details: ADO Error Code: 0x Source: Microsoft OLE DB Provider for SQL Server Description: Procedure or Function 'sp_xxxx' expects parameter '@ppppp', which was not supplied. SQL State: 42000 Native Error: Failed to open a rowset. Error in File
 
Any help would be much appreciated!

Posted By: Shaft
Date Posted: 27 Jul 2007 at 5:23am
The error is because as it's says the stored procedure you are calling is expecting parameter @ppp which you are not supplying. How are you calling the data for the report?

Posted By: ntdong
Date Posted: 02 Aug 2007 at 6:43am
I am getting this same error.
 
my code :
<
myReportDocument.SetParameterValue("@parameter", value)
SetDBLogonForReport(myConnectionInfo, myReportDocument )
>
 
When I change the DatabaseName to test DBLogon, I get this error :
 Failed to open a rowset. Details: ADO Error Code: 0x Source: Microsoft OLE DB Provider for SQL Server Description: Procedure or Function 'sp_test' expects parameter mailto:@parameter - '@parameter' , which was not supplied. SQL State: 42000 Native Error: Failed to open a rowset. Error in File
 
SetParameterValue doesn't work.
 
  


Print Page | Close Window