Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Record Selection for Dates Post Reply Post New Topic
Author Message
sinichi_v
Newbie
Newbie


Joined: 20 Jan 2008
Online Status: Offline
Posts: 2
Quote sinichi_v Replybullet Topic: Record Selection for Dates
    Posted: 20 Jan 2008 at 9:06pm
Hi, Crystal Report newbie here.
 
I am trying to design a monthly sales analysis report for my company.  They would need to enter the desired month and the report would display all sales in that month.  I have used the Calendar_Date table for the month parameter.  My problem now is I don't know how to select the records so that it displays all sales for the month selected.  The sales date in the table is in the Julian format so I have converted it. 
 
Can someone please tell me how to select the records? Thanks in advance.
IP IP Logged
rahulwalawalkar
Senior Member
Senior Member
Avatar

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Quote rahulwalawalkar Replybullet Posted: 21 Jan 2008 at 12:55am
Hi ,
 
You can use the Month fucntion from crystal it will go like this in record selection formula
 
Month({?parameter datefield}) =  {@formulaMonthdatefield)
 
 
 
Month(databasefield) which will give you whole number
 
 
cheers
Rahul
 
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.030 seconds.