Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Help:Parameters from Stored Procedures Post Reply Post New Topic
Author Message
Nav522
Senior Member
Senior Member


Joined: 25 Aug 2009
Location: United States
Online Status: Offline
Posts: 166
Quote Nav522 Replybullet Topic: Help:Parameters from Stored Procedures
    Posted: 18 Feb 2010 at 4:34pm
Hello Folks,
                  I have this report which gets populated by a Stored procedure with date parameters(start dt and end dt). As per requirement i got rid of date parameters and modified the SP as follows: created a parameter ?frequency and depending on this parameter i have selected the dates( i.e if ?frequency =year then year logic if ?frequency = month then month logic). Now the problem is when am triyng to run the report it doesnt show up any data for the  parameter ?frequency= Month as well as Year. I have used the Formula in Record Selection as @Frequency = ' Month'.
 
Please throw some light on this.
 
 
Thanks a million


Edited by Nav522 - 18 Feb 2010 at 4:36pm
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 19 Feb 2010 at 6:45am
where did you put your date logic?  In the report?  Won't work, unless you are filtering the data when it comes back from the sp.  Put the logic in the sp to respond to the value of frequency.  CR just passes the values from the parameter screen to the stored proc, it doesn't process any formulas that I know of before sending to the sp.
 
HTH
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.