Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Filter in 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 in parameter field
    Posted: 27 Oct 2009 at 4:31pm
I'm a new guy in crystal report.  I create a parameter field named Member Type and insert all value from member type in database.  However, I would like the user can select those member types are active in parameter field.  
 
Many thanks


Edited by andicsc - 27 Oct 2009 at 4:31pm
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 28 Oct 2009 at 7:20am
Use the paramter field in your select statment:
{?Member Type param} = {table.membertypefield}
IP IP Logged
andicsc
Newbie
Newbie
Avatar

Joined: 03 Jul 2008
Location: Australia
Online Status: Offline
Posts: 12
Quote andicsc Replybullet Posted: 29 Oct 2009 at 5:43pm

The parameter field display all member type, however, can those member type be filtered first, e.g. only those member type are in active cab be displayed.

IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 29 Oct 2009 at 6:53pm
you mean you are using a dynamic parameter here?
Try and change your source to filter at that level and then use that as the source for the param.
Examples ... stored proc, SQL view or a crystal command if your source data won't support the other options.
Is that a plausible solution for your set up?


Edited by DBlank - 29 Oct 2009 at 6:54pm
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.