How to show possible value in prompt when showing crystal report

hi,

If we have a parameter field in crystal report, we need to provide the value for this parameter before viewing the report. Does anyone knows how to show the possible values that we have in DB under the dropdown list? The idea is similar to what we seen in Crystal Report program when we select "print preview". I tried to call a report in windows form (C#) but I need to enter the value manually, there isn't any value inside the dropdown list..

Many thanks for your helps :)

You probably need to access the database and get use a distinct query to do that, since you probably already have access to the database. I believe that is how the Crystal Report do in the first place.

Does anyone has idea how to put the possible value into the drop down list ????

 

thanks.

Pardon me, but I believe that when you use Crystal Report to preview, it actually connects to the database and queries the table to obtain distinct values to populate the drop down list. Are you trying to have the drop down list to be automatically to be populated by the Crystal Report Engine or are you trying to populate it yourself?