Joined: 13 Nov 2008
Location: United States
Online Status: Offline
Posts: 1
Topic: Parameters Posted: 13 Nov 2008 at 11:53am
I have a character field in my data and report that has multiple values. I want to be able to parameter Prompt yes or no for a specific value or all. For example in this field I can have (PF, DR, TY, FP, FC and on) The decision I want made in the record selection is to have only PF or have all .
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Posted: 13 Nov 2008 at 4:22pm
You need to add 'All' as one of the options. Then in your record selction formula have it check for "all" or any of the other options. For example, here is a selection formula:
{?Param}='All' OR {?Param}={table.yourfield}
My book, Crystal Reports Encyclopedia, gives you many ways of using parameters with record selection formulas. You can find out more about my books at Amazon.com or reading the Crystal Reports eBooks online.
[
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Posted: 13 Nov 2008 at 4:22pm
You need to add 'All' as one of the options. Then in your record selction formula have it check for "all" or any of the other options. For example, here is a selection formula:
{?Param}='All' OR {?Param}={table.yourfield}
My book, Crystal Reports Encyclopedia, gives you many ways of using parameters with record selection formulas. You can find out more about my books at Amazon.com or reading the Crystal Reports eBooks online.
[
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Posted: 13 Nov 2008 at 4:22pm
You need to add 'All' as one of the options. Then in your record selction formula have it check for "all" or any of the other options. For example, here is a selection formula:
{?Param}='All' OR {?Param}={table.yourfield}
My book, Crystal Reports Encyclopedia, gives you many ways of using parameters with record selection formulas. You can find out more about my books at Amazon.com or reading the Crystal Reports eBooks online.
[
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
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
IP Logged
