Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Stored Procedure Parameters Post Reply Post New Topic
Author Message
rminder
Newbie
Newbie


Joined: 20 Aug 2010
Online Status: Offline
Posts: 3
Quote rminder Replybullet Topic: Stored Procedure Parameters
     Posted: 20 Aug 2010 at 10:48am
My report hits a stored procedure for its data. The stored proc takes four parameters. Crystal 2008 automatically creates four report parameters for me. Is there any way I can delete these four auto-generated parameters, and create four of my own and use them to pass to the stored proc?

Thanks.
IP IP Logged
sukhveer
Newbie
Newbie


Joined: 18 Aug 2010
Online Status: Offline
Posts: 22
Quote sukhveer Replybullet Posted: 22 Aug 2010 at 8:35am
No, it is not possible I guess.
---
However, I don't understand why would you want to do that?
If it is to rename.. you can do that quite easily.. just right click and rename
---
If it is for some logic or data format etc... why not work around on that stored procedure?
---
IP IP Logged
saoco77
Senior Member
Senior Member


Joined: 26 Jun 2007
Online Status: Offline
Posts: 104
Quote saoco77 Replybullet Posted: 23 Aug 2010 at 6:12am
One work around is to make your report a subreport and link the main report to the subreport based on one or more of the parameters in the stored procedures.

You may take a hit on performance, but this will allow you to control the names of the parameters if that is a requirements
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