Cryastl Reports is not recognizing that a new parameter has been added to the report's stored proc

Posted by ann on Stack Overflow See other posts from Stack Overflow or by ann
Published on 2010-03-25T20:52:09Z Indexed on 2010/03/25 20:53 UTC
Read the original article Hit count: 305

Filed under:

crystal-reports

|

stored-procedures

i have added another input parameter to a stored proc used by a crystal report. i've had our dba recompile the stp to be sure that the new parameter is cached and "really there".

i cannot get my crystal report to recognize the new parameter -- i've tried verifying database and using the Set Datasource Location/Update to re-select the stp.

i'm using cr11 against a 2005 sql server db.

any other suggestions?

© Stack Overflow or respective owner

Related posts about crystal-reports

Crystal Reports: Save Time with Formula Sharing

as seen on ASP alliance - Search for 'ASP alliance'
Once a report library grows to a certain size there are always going to be common formulas which are needed repeatedly. Having easier access to them can save a lot of development time. >>> More
Automate delivery of Crystal Reports With a Windows Service

as seen on ASP alliance - Search for 'ASP alliance'
In this article, Vince demonstrates the creation of a Windows Service to automatically run and send a Crystal Report as an email attachment. After a basic introduction, he examines the creation of the database and windows service with the help of relevant source code and explanations. Towards the… >>> More
Crystal Reports for VS deployment to Web Application doesn't work (3 replies)

as seen on .NET 247 - Search for '.NET 247'
I've followed the "documentation" for getting crystal reports to work on a production web site. I've migrated a VS 2003 web project to a VS 2008 web application. Everything works fine on my dev box. publish the site out to the server (2003 X86) and no go on the reports, get the infamous:… >>> More
Crystal Reports: 5 Tests for Top Performance

as seen on ASP alliance - Search for 'ASP alliance'
Your masterpiece report is now complete. It doesn't just meet your customer’s expectations, it blows them out of the water. All they want is a beautifully-summarized report that can be displayed in a myriad of ways. Then disaster strikes! You try to run the report for a month against the live database… >>> More
Crystal Reports for VS deployment to Web Application doesn't work (3 replies)

as seen on .NET 247 - Search for '.NET 247'
I've followed the "documentation" for getting crystal reports to work on a production web site. I've migrated a VS 2003 web project to a VS 2008 web application. Everything works fine on my dev box. publish the site out to the server (2003 X86) and no go on the reports, get the infamous:… >>> More

Related posts about stored-procedures

SubSonic 2.2 missing stored procedures in StoredProcedures.cs when generated with sonic.exe

as seen on Stack Overflow - Search for 'Stack Overflow'
We are trying to move from SubSonic 2.0.3 to 2.2 (not using .NET 3.5). When we regenerate the project using SubCommander\sonic.exe and try to compile we get some errors reporting missing members (which should have been automatically generated based on the stored procedures we have). On closer inspection… >>> More
SubSonic missing stored procedures in StoredProcedures.cs when generated with SubCommander sonic.exe

as seen on Stack Overflow - Search for 'Stack Overflow'
We have been using SubSonic to generate our DAL with a lot of success on VS2005 and SubSonic Tools 2.0.3. SubSonic Tools do not work on VS2008 (as far as we can work out) so we have tried to use SubCommander\sonic.exe and are now hitting some problems. When we regenerate the project using SubCommander\sonic… >>> More
Drop all stored procedures in MySQL or using temporary stored procedures

as seen on Stack Overflow - Search for 'Stack Overflow'
Is there a statement that can drop all stored procedures in MySQL? Alternatively (if the first one is not possible), is there such thing as temporary stored procedures in MySQL? Something similar to temporary tables? So far, for both tasks, I seem not to find any answers although there were people… >>> More
What is your best-practice advice on implementing SQL stored procedures (in a C# winforms applicatio

as seen on Stack Overflow - Search for 'Stack Overflow'
I have read these very good questions on SO about SQL stored procedures: When should you use stored procedures? and Are Stored Procedures more efficient, in general, than inline statements on modern RDBMS’s? I am a beginner on integrating .NET/SQL though I have used basic SQL functionality for… >>> More
Creating Stored Procedures in MySQL Using HeidiSQL 4&#146;s Stored Routine Editor

as seen on Internet.com - Search for 'Internet.com'
In the "Write MySQL Queries Using HeidiSQL 4" article, we learned how to connect to a MySQL database and execute queries against it using the free HeidiSQL GUI client. Today, we'll learn how to create a stored procedure using HeidiSQL's Stored Procedure Editor. >>> More