Print Page | Close Window

Filter in parameter field

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=8140
Printed Date: 20 Apr 2024 at 1:14am


Topic: Filter in parameter field
Posted By: andicsc
Subject: Filter in parameter field
Date 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


Replies:
Posted By: DBlank
Date Posted: 28 Oct 2009 at 7:20am
Use the paramter field in your select statment:
{?Member Type param} = {table.membertypefield}

Posted By: andicsc
Date 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.

Posted By: DBlank
Date 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?


Print Page | Close Window