Skip to Content

Select All option in drop down list

I'm working on a crystal report in which I have created a drop-down list by making three static parameters. Values are being fetched from the DB not by passing values in the static parameter box. I need to add the "All" option in my drop-down list. e.g when drop-down list is selected on item codes it shows All, 001, 002 and so on. Upon selecting "All" all item codes get displayed on the report. Kindly guide

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Nov 05, 2019 at 06:12 AM

    Hello,

    You may refer this blog on having Select All parameter.

    Thanks.

    Add a comment
    10|10000 characters needed characters exceeded

    • thanks. I have solved this by applying following method:

      1. Set parameter of item code like this:

      Item@Select 'All' as ItemCode from OITM Union Select Distinct ItemCode from OITM where U_Team_title = '@Team' order by ItemCode

      2. Then make it equal in the formula section like this:

      ({Command.ItemCode} = {?Item@Select 'All' as ItemCode from OITM Union Select Distinct ItemCode from OITM where U_Team_title = '@Team' order by ItemCode} or {?Item@Select 'All' as ItemCode from OITM Union Select Distinct ItemCode from OITM where U_Team_title = '@Team' order by ItemCode} = 'All')