Report Design
 Crystal Reports Forum : Crystal Reports .NET 2003 : Report Design
Message Icon Topic: Date selection parameter need Year Post Reply Post New Topic
Author Message
Yamisquiff
Newbie
Newbie


Joined: 23 Jun 2009
Location: United Kingdom
Online Status: Offline
Posts: 10
Quote Yamisquiff Replybullet Topic: Date selection parameter need Year
    Posted: 08 Oct 2009 at 8:33am
Hi Guys,
 
I have been modifiying a report which came with our support desk software and I have pretty much got it to do what I want.
 
I now want to alter the method of record selection to allow the report to be ran each year.
 
It is currently set up to allow you to run the report either as a 12 month or a 1 month report.
 
The selection formula currently in use is shown below:
 
 
If {?Time Period} = 12 then
   {@Call Date} in YearToDate
else
   {@Call Date} in MonthToDate
 
I was thinking of the following but im sure it will not work
 
{?Time Period} = {@Call Date}
 
If I set the paramter values for the years
 
I understand what its doing, just not how to change it to suit my needs.

Warren
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 12 Oct 2009 at 6:32am
probably depends on what value is in the parameter.  if it is the year that you want, then this should work:
{?Time Period} = year({@Call Date})
 
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.016 seconds.