Print Page | Close Window

Custom parameter fields

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=20328
Printed Date: 27 Apr 2024 at 12:47pm


Topic: Custom parameter fields
Posted By: _Bash_
Subject: Custom parameter fields
Date Posted: 07 Jan 2014 at 10:06am
In Crystal Reports 2008.

Is there a way to customize a parameter field? (i.e. : apply a filter to the data).

I want the user to be able to select multiple entries for a parameter but there are over 1000 entries in the database and I don't need to display all of them. I'd like to apply a filter to lower the number of entries the user has to choose from.

Thanks!




Replies:
Posted By: kostya1122
Date Posted: 07 Jan 2014 at 10:08am
you could use dynamic parameters


Posted By: _Bash_
Date Posted: 07 Jan 2014 at 10:12am
That's what I did, gave a name to my parameter and selected the corresponding field as a value. The problem is I don't want all the values from that field to be displayed so I need a way to filter the data.


Posted By: DBlank
Date Posted: 07 Jan 2014 at 10:36am
you can use a filtered view or stored proc as the source for the dynamic data


Posted By: _Bash_
Date Posted: 08 Jan 2014 at 3:58am
Alright, I get it now. Thought there would be a way to do it without having to edit the database.

Thanks !



Print Page | Close Window