Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Custom parameter fields Post Reply Post New Topic
Author Message
_Bash_
Newbie
Newbie


Joined: 06 Jan 2014
Online Status: Offline
Posts: 7
Quote _Bash_ Replybullet Topic: Custom parameter fields
    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!

IP IP Logged
kostya1122
Senior Member
Senior Member
Avatar

Joined: 13 Jun 2011
Online Status: Offline
Posts: 475
Quote kostya1122 Replybullet Posted: 07 Jan 2014 at 10:08am
you could use dynamic parameters
IP IP Logged
_Bash_
Newbie
Newbie


Joined: 06 Jan 2014
Online Status: Offline
Posts: 7
Quote _Bash_ Replybullet 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.

Edited by _Bash_ - 07 Jan 2014 at 10:17am
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 07 Jan 2014 at 10:36am
you can use a filtered view or stored proc as the source for the dynamic data
IP IP Logged
_Bash_
Newbie
Newbie


Joined: 06 Jan 2014
Online Status: Offline
Posts: 7
Quote _Bash_ Replybullet 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 !
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.031 seconds.