Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Date Range for selected record Post Reply Post New Topic
Author Message
Shako
Newbie
Newbie


Joined: 07 Nov 2011
Online Status: Offline
Posts: 12
Quote Shako Replybullet Topic: Date Range for selected record
     Posted: 15 Nov 2011 at 11:54pm
Hi

How do i make the user select the date range of a result?

What i means is :

The user would select a serial number, that serial number a few dates linked to it. The dates correspond to the time a test was done.
How do i get these dates and display them as a parameter for the user to select from?

Im using Crystal Reports 2011.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 16 Nov 2011 at 3:48am
dynamic LOV in the parameters options.

Edited by DBlank - 16 Nov 2011 at 3:48am
IP IP Logged
Shako
Newbie
Newbie


Joined: 07 Nov 2011
Online Status: Offline
Posts: 12
Quote Shako Replybullet Posted: 16 Nov 2011 at 6:56pm
I have done that but it gives me all the dates and not just the dates pertaining to the Serial number that the user selected.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 17 Nov 2011 at 3:44am
In the param creation 
LOV=dynamic
value row 1=serial number field
value row 2=date field
In the parameters Column set them both as parameters
IP IP Logged
Shako
Newbie
Newbie


Joined: 07 Nov 2011
Online Status: Offline
Posts: 12
Quote Shako Replybullet Posted: 17 Nov 2011 at 7:27pm
Thanks DBlank.
Works like a dream.
IP IP Logged
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