Active TopicsMemberlistSearchHelpRegisterLogin

Data Connectivity
 Crystal Reports Forum : Crystal Reports .NET 2003 : Data Connectivity
Message Icon Topic: Passing a Crystal report parameter to stored proc. Post Reply Post New Topic
<< Prev Page  of 2
Author Message
Hyvong
Newbie
Newbie


Joined: 29 Jan 2008
Location: Canada
Online Status: Offline
Posts: 7
Quote Hyvong Replybullet Posted: 21 Feb 2008 at 6:39am
I went and changed all of my stored proc datatype to nvarchar instead of GUID and allow NULL.
 
I was able to see the data when i clicked on "Main Report Preview".
 
But when i run the report from my web app, I received this error.
One or more fields could not be found in the result set. Use Verify Database to update the report. Error in File C:\DOCUME~1\HyVong\LOCALS~1\Temp\4\StandardPartSummaryReport {6F44DA3D-7290-49DC-B5E2-7F734A4D6C8F}.rpt: The rowset column could not be found.
But i verified the database, and i tried to use only 1 field from the report and still receiving this error.  Does anyone knows why? is it because the value i passed into the report are not coming through and therefore my report couldn't retrieve any record from the database?
If i don't select any field to display on my report, then the report works, but as soon as i select a field from the 'Database field' i get this error.
 
I am new when it comes to hooking up CR with stored proc, perhaps somebody out there can help me.  I have been struggle through this for days.
Thanks in advance!
Love your love ones like there is no tomorrow.
IP IP Logged
Hyvong
Newbie
Newbie


Joined: 29 Jan 2008
Location: Canada
Online Status: Offline
Posts: 7
Quote Hyvong Replybullet Posted: 02 Mar 2008 at 4:00pm
Based on the code i posted from above; I find that i can pass the report's stored proc parameter successfully when i didn't have the database logon info.  Once i set the connection to my database, all of the report stored proc parameter values are not being passed through.  Does any one know if this is a Crystal REport bug, and whether there is a hot fix i should apply?
Your help is greatly appreciated.
 
Thanks,
Love your love ones like there is no tomorrow.
IP IP Logged
Hyvong
Newbie
Newbie


Joined: 29 Jan 2008
Location: Canada
Online Status: Offline
Posts: 7
Quote Hyvong Replybullet Posted: 03 Mar 2008 at 11:25am
After weeks of frustration, I found out that the issue  posted above is from Crystal Report 10 bug.
 
I applied the hot fixed and it works for me but i have read some people claimed that it didn't work them.  However, here is the patch since it might be helpful to some of you.
 
Love your love ones like there is no tomorrow.
IP IP Logged
rickysch
Newbie
Newbie


Joined: 25 Mar 2008
Location: United States
Online Status: Offline
Posts: 1
Quote rickysch Replybullet Posted: 25 Mar 2008 at 12:07pm
Thank you man!

This patch fixed a similar issue for me!


Ricky
IP IP Logged
Hyvong
Newbie
Newbie


Joined: 29 Jan 2008
Location: Canada
Online Status: Offline
Posts: 7
Quote Hyvong Replybullet Posted: 28 Mar 2008 at 1:05pm
Glad i could help.
I totally understand the frustration when it comes to bug like this.
 
Cheers!
Love your love ones like there is no tomorrow.
IP IP Logged
usman009
Newbie
Newbie


Joined: 09 Feb 2009
Location: United Kingdom
Online Status: Offline
Posts: 2
Quote usman009 Replybullet Posted: 26 Mar 2009 at 3:18am
Hi I am having the same issue has any one got solution for it.
 
Thanks in advance.
IP IP Logged
<< Prev Page  of 2
Post Reply Post New Topic
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.