Setting parameters at runtime for stored procedure
Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Writing Code
Forum Discription: .NET programming API, report integration
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=3386
Printed Date: 03 May 2025 at 12:06am
Topic: Setting parameters at runtime for stored procedure
Posted By: catalinandrei00
Subject: Setting parameters at runtime for stored procedure
Date Posted: 10 Jun 2008 at 12:17am
Hello,
I have several crystal reports made in Crystal Reports 11
and I'm integrated them in Visual Studio 2005. I need to change the
database connection for those reports at runtime, and this is working
quite well.
Some of the reports are using queries and others are using stored procedures.
Question)
The problem I've encountered is that I cannot set the stored procedures
parameters after changing the runtime connection for reports that are
using stored procedures.
The message is :
"Missing parameter values.
Exception Details: System.Runtime.InteropServices.COMException: Missing parameter values. "
I've seen this problem on another thread, I tried to follow the instructions described there, but nothing works.
The thread I am talking about is here : http://forums.msdn.microsoft.com/en-US/vscrystalreports/thread/3c8db743-f1fb-4021-bf46-f6aee8889932/ - http://forums.msdn.microsoft.com/en-US/vscrystalreports/thread/3c8db743-f1fb-4021-bf46-f6aee8889932/"
Does anyone knows what's happening?
Thank you,
Catalin
|
Replies:
Posted By: catalinandrei00
Date Posted: 13 Jun 2008 at 7:51am
The solution is this patch that applies to Visual Studio 2005 :
http://ftp1.businessobjects.com/outgoing/CHF/crnet20win32x86_en_chf.zip - http://ftp1.businessobjects.com/outgoing/CHF/crnet20win32x86_en_chf.zip
|
|