Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Prompting for a date using calendar Post Reply Post New Topic
Author Message
debmac
Newbie
Newbie


Joined: 26 Apr 2009
Location: Australia
Online Status: Offline
Posts: 12
Quote debmac Replybullet Topic: Prompting for a date using calendar
    Posted: 26 Apr 2009 at 6:01pm
Hi there,

I'm a new Crystal reports user (2008v) and am writing a report which propts the user for a date range (from table Trandet).

I have created a dynamic parameter value, but users get a list of all dates from the trandet table but have to select from a drop down, and cant type.

i would like to set it so users can either type a starte and end date, or better yet, choose from a calendar. 

the report also contains two sub-repots which need to use the same date range. How could i set that up?

your help is much appreciated.

Deb
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 27 Apr 2009 at 9:21am

Do not use the dynamic parameter but rather a static parameter as a Date type.

Create 2 paramters, one as Start Date the other as End Date.
Then in your select statment use them as:
{table.datefield} in {?start Date} to {?End Date}
IP IP Logged
debmac
Newbie
Newbie


Joined: 26 Apr 2009
Location: Australia
Online Status: Offline
Posts: 12
Quote debmac Replybullet Posted: 27 Apr 2009 at 6:58pm
That worked. Many thanks for your suggestion!
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.