Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Change report prompts Post Reply Post New Topic
Author Message
Crystallite
Newbie
Newbie


Joined: 24 May 2011
Online Status: Offline
Posts: 4
Quote Crystallite Replybullet Topic: Change report prompts
     Posted: 24 May 2011 at 5:30am
Hi

am pretty new to Crystal Reporting (and enjoying :))

There is an existing report having two prompts "Start Date" and "End Date" which executes a stored proc in the background. i need to replace these prompts with a single prompt which can take values "Previous Day","Previous Week","Last Month","Last 6 months" from a drop down list.

Could anybody provide me some tips as to how to achieve this

Thanks
~CR
IP IP Logged
sharona
Senior Member
Senior Member
Avatar

Joined: 16 Oct 2008
Location: United States
Online Status: Offline
Posts: 255
Quote sharona Replybullet Posted: 24 May 2011 at 8:19am
if the @startdate and @enddate come from the stored procedure they have to be changed in there. i would suggest you build it in the sp.
 
you would create the date parameter in the sp
then make sure you add the values to the parameter in cr that match the values in the sp.
sharona
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