Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: filter the parameter field Post Reply Post New Topic
Author Message
andicsc
Newbie
Newbie
Avatar

Joined: 03 Jul 2008
Location: Australia
Online Status: Offline
Posts: 12
Quote andicsc Replybullet Topic: filter the parameter field
    Posted: 18 Jan 2011 at 12:22pm
I want to filter a member type i nthe parameter field which shows the active memebr type.
 
For example, the member type contains :
 
Member type    Expiry Date
A                       2011
B                       2011
C                       2009
D                       2010
E                       2011
 
When display the parameter field, only A, B, E shows o nthe parameter fields.
 
Many thanks
 
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 19 Jan 2011 at 4:16am
you have to filter the source data in some manner (e.g. SQL view or stored proc or a crystal command) and then use this new item/view/sp/command as the source for your dynamic param
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.016 seconds.