Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Filter Dynamic Parameter List Results Post Reply Post New Topic
Author Message
Twizik
Newbie
Newbie
Avatar

Joined: 19 Apr 2012
Online Status: Offline
Posts: 21
Quote Twizik Replybullet Topic: Filter Dynamic Parameter List Results
     Posted: 25 Nov 2013 at 7:45am
Crystal XI

I'm trying to create a dynamic parameter and filter the listed results to active customers.

I have {Cust.Name} and {Cust.Active} and would like to only show {Cust.Active}-(Y) in the dynamic parameter list of {Cust.Name}

Is this possible?

Thank you.
IP IP Logged
kostya1122
Senior Member
Senior Member
Avatar

Joined: 13 Jun 2011
Online Status: Offline
Posts: 475
Quote kostya1122 Replybullet Posted: 25 Nov 2013 at 8:16am
you could do
either first filter on {Cust.Active}=(Y)
then create dynamic parameter for {Cust.Name}
or
create dynamic parameter for
{Cust.Active} >>{Cust.Name}
to create a dynamic parameter
right click parameter fields >>new parameter>>
under list of values select dynamic >>
under value select {Cust.Name} or
select {Cust.Active} first line {Cust.Name} second line
IP IP Logged
Twizik
Newbie
Newbie
Avatar

Joined: 19 Apr 2012
Online Status: Offline
Posts: 21
Quote Twizik Replybullet Posted: 25 Nov 2013 at 8:26am
This worked perfectly for what I needed.

Created a [Cust.Active] line then a [Cust.Name] line in the dynamic parameter.

Thank you very much.
IP 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