Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Stored Procs Post Reply Post New Topic
Author Message
moleary
Newbie
Newbie


Joined: 06 Feb 2008
Location: United States
Online Status: Offline
Posts: 28
Quote moleary Replybullet Topic: Stored Procs
     Posted: 24 Apr 2008 at 9:52am
Since Crystal creates individual parameters for you from your stored procedure, I'm assuming them you can't turn those into DCP's Correct?

Edited by moleary - 24 Apr 2008 at 9:53am
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 24 Apr 2008 at 4:01pm
That's an interesting question. Since the parameter is used by SQL Server to create the original resultset, then no you can't turn the parameter into a DCP. (It's like a chicken and the egg problem - each one would need the other to go first to work). But you can create new DCPs based on a stored procedure that used a parameter.

I have two chapters in my Encyclopedia book covering how to use databases in your report and tons of tips for optimizing them. You can find out more about my books at Amazon.com or reading the Crystal Reports eBooks online.
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
moleary
Newbie
Newbie


Joined: 06 Feb 2008
Location: United States
Online Status: Offline
Posts: 28
Quote moleary Replybullet Posted: 25 Apr 2008 at 5:34am
Broke down and bought the book.....got it yesterday after I posted this.... SO HELPFUL THANKS!
IP IP Logged
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