Crystal Reports Filter in parameter field

Report Design

Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: Filter in parameter field

Post Reply

Post New Topic

Author	Message
andicsc Newbie Joined: 03 Jul 2008 Location: Australia Online Status: Offline Posts: 12	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 Logged


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

andicsc Newbie Joined: 03 Jul 2008 Location: Australia Online Status: Offline Posts: 12	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 Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	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 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