Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Date Parameters Post Reply Post New Topic
Author Message
wolverine12
Newbie
Newbie
Avatar

Joined: 04 Dec 2007
Location: Canada
Online Status: Offline
Posts: 2
Quote wolverine12 Replybullet Topic: Date Parameters
    Posted: 04 Dec 2007 at 8:23am
I'm new to Crystal Reports but not new to DBs.
 
I have dates, as columns, across my report (from a query in a DB).  I would like to make this a 'rolling' 13 month view where the user selects the range that gets shown.
 
Currently, I have a 13 month view (Nov06-Nov07) set up.  Can I use parameters to change this next month to show Dec06-Dec07?  If so, any hints as to how?
 
Thanks
IP IP Logged
Lugh
Senior Member
Senior Member
Avatar

Joined: 14 Nov 2007
Online Status: Offline
Posts: 377
Quote Lugh Replybullet Posted: 04 Dec 2007 at 10:59am
Yes.  It's fairly easy, actually.  You have a few options.

First, read up on parameters.  Both in the help file, and in Brian's book.  That will answer a goodly chunk of your questions.

Now, you have three basic ways to get the date window you are looking for.  You can create a single date parameter, that represents either the beginning or ending of the window.  Use DateAdd to calculate the other endpoint.  You can create a pair of date parameters, which are the endpoints of your window.  Or, you can use a daterange parameter, which is a parameter that includes the entire range of dates.

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.