Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Formula for selection expert Post Reply Post New Topic
Author Message
sven2
Newbie
Newbie


Joined: 09 Jul 2010
Location: Belgium
Online Status: Offline
Posts: 8
Quote sven2 Replybullet Topic: Formula for selection expert
     Posted: 09 Jul 2010 at 1:49am
Hello,
 
I am trying to create a formula that allows the user to make no selection in the parameter fields.
 
The formula that we are now using look like:
 
{Afdeling.AfdelingNaam} = {?Selectie Afdeling} and
{Functie_titel.Functie_titel} = {?Selectie functie} and
{Personeelsfuncties.Status} = {?Selectie status} and
{Werknemers.Ploeg} = {?Selectie ploeg}
 
Is it possible to change this so that the user is able to leave the fields (1 or more) empty. When A field is empty all the records should be displayed ofcourse.
 
Best regards,
Sven.
 
IP IP Logged
FrnhtGLI
Senior Member
Senior Member
Avatar

Joined: 22 May 2009
Online Status: Offline
Posts: 347
Quote FrnhtGLI Replybullet Posted: 09 Jul 2010 at 3:21am

CR 2008 has a nice option for the parameters that is called Optional Prompt. I don't believe this is possible outside of 2008 though.
|< /\ '][' ( )
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 09 Jul 2010 at 3:58am
http://www.crystalreportsbook.com/Forum/forum_posts.asp?TID=9531
IP IP Logged
sven2
Newbie
Newbie


Joined: 09 Jul 2010
Location: Belgium
Online Status: Offline
Posts: 8
Quote sven2 Replybullet Posted: 11 Jul 2010 at 3:12am
Hello,
 
as far as I can see this is an usefull option for a static parameter where I can add the option all. But in my case it is a dynamic list so I can't add the  option all. 
 
Or can I add a record in a dynamic list?
 
Sven.
 
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 12 Jul 2010 at 3:54am
You can use a Command to Union in an 'All' option to each table and use that as the source.
IP IP Logged
sven2
Newbie
Newbie


Joined: 09 Jul 2010
Location: Belgium
Online Status: Offline
Posts: 8
Quote sven2 Replybullet Posted: 13 Jul 2010 at 7:48am
Hello,
 
is it possible to give some more information how to use this union function?
 
Best regards,
Sven.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 13 Jul 2010 at 7:57am
 

Edited by DBlank - 13 Jul 2010 at 7:57am
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

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | BAEZL

© 2004-2026 Brian Bischof. All Rights Reserved.