Topic: Report parameter not effect Posted: 11 Sep 2012 at 11:04pm
Hi Guys,
I have problem with crystal report 2008 sp5 and vs2010.
I have an report call store procedure with 5 parameters.
In vs2010 source code i supply 5 parameters correct but not data show.
I try to trace executed sql in SQL Profiler but all parameter input to store procedure is NULL. But when i make a new report with the same store procedure and the new report show OK and SQL Profiler also see input parameter into store procedure.
It taken me one week debug but found no thing.
I have a lot of report, so can't re-design all again.
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Posted: 12 Sep 2012 at 4:27am
all that comes to mind is verify database.
are you setting the parameters in code and then displaying the report, or is the parameter screen displayed, user enters parameter, and then report displayed.
if the first, the only other thought is if the parameters are spelled the same.
are you setting the parameters in code and then displaying the report, or is the parameter screen displayed, user enters parameter, and then report displayed.
if the first, the only other thought is if the parameters are spelled the same.
HTH
Thanks for your relay,
I setting parameter value in code vb 2010. I had verify database ok. But in Reportdocument the parameters value not effect.
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
IP Logged
