How do I include all data based on a parameter 2

[jercisneros]

I have created a parameter that will select discrete and ranges of stock codes. But once I create that parameter if I don't enter anything in the parameter the report will refresh empty. Is there a special character that will include all stock codes when entered into the parameter?

Any help would be greatly appreciated.

Jerry

 

[DanENW]

You could set a default value for the parameter to some value that is not a legal stock code, like "ALL". Then replace the selection formula with the following:

[tt] (( {?Stock Code Param} = 'ALL' ) or // Accept all stock codes.
( {?Stock Code Param} <> 'ALL' and // Accept only select stock codes.
{Table.StockCodes} = {?Stock Code Param} ))[/tt]

 

[jercisneros]

This solution works excellent. However I have another question. Now that I can bring in all the stock codes, there are about ten that we no longer use and want to exclude them from the report. How can I add it to the parameter so that every time &quot;ALL&quot; is selected to exclude those ten stock codes?

Thanks again!

 

[dgillz]

Not {StockCode} in [&quot;Comma&quot;,&quot;delimited&quot;,&quot;list&quot;]

place you list in between the square brakets above. Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[synapsevampire]

Very nice, *Dan*!

I've been overworking the record selection criteria by using IFs, and apparently this passes the SQL as often as my now old method.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com