Print Page | Close Window

crystal report parameters

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=1481
Printed Date: 05 May 2024 at 1:46am


Topic: crystal report parameters
Posted By: botete
Subject: crystal report parameters
Date Posted: 09 Oct 2007 at 7:51pm
Hi and Good day!
 
Is there a way I could embed parameter in a sql command straight in the form, instead of calling a Stored Procedure. It would be helpful to lessen the creation of Stored Procedure for every report that uses parameters.
Can I ask for some example codes. I'm writing codes in C#. Thanks!
 
BoSmile



Replies:
Posted By: BrianBischof
Date Posted: 10 Oct 2007 at 10:32am
You can use ADO.NET with a SQL string in the Command object. Just make it all one string and include the parameter values in the string.

-------------
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: botete
Date Posted: 10 Oct 2007 at 7:40pm

Got it! Here I'm not going use Stored Procedure anymore. Thank you Sir.




Print Page | Close Window