Writing Code
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Writing Code
Message Icon Topic: crystal report parameters Post Reply Post New Topic
Author Message
botete
Newbie
Newbie
Avatar

Joined: 16 Sep 2007
Location: United States
Online Status: Offline
Posts: 15
Quote botete Replybullet Topic: crystal report parameters
    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
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet 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>
IP IP Logged
botete
Newbie
Newbie
Avatar

Joined: 16 Sep 2007
Location: United States
Online Status: Offline
Posts: 15
Quote botete Replybullet Posted: 10 Oct 2007 at 7:40pm

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

IP IP Logged
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.