Print Page | Close Window

Date selection parameter need Year

Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=7965
Printed Date: 28 Apr 2024 at 11:25pm


Topic: Date selection parameter need Year
Posted By: Yamisquiff
Subject: Date selection parameter need Year
Date 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
   mailto:%7b@Call - {@Call Date} in YearToDate
else
   mailto:%7b@Call - {@Call Date} in MonthToDate
 
I was thinking of the following but im sure it will not work
 
{?Time Period} = mailto:%7b@Call - {@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


Replies:
Posted By: lockwelle
Date 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( mailto:%7b@Call - {@Call Date})
 
HTH


Print Page | Close Window