LOV get populated from a single field from your data source (grouped to avoid duplicate entries). You can add it by creating a Parameter and setting it to be Dynamic then assigning the field from your data source.

 

You can make cascading LOVs in a similar way.

Depending on your version and total data rows from your source you may need to alter your registry to allow all values to appear. There are a few posts with direction on that.

Does that help? Do you have more specific questions?

 

Go into the Report design and Right click on the Parameters and select New.

Name it LOV_test (or whatever)

Set the type to match the database field you want to use for the list (e.g for a name field use 'string')

for List of Values click on Dynamic

Your screen will cahnge

Under the INsert folder on the new screen click in the Value column

It should become a pick list of all your data fields from your source table

Pick the one you want to be your list.

Hit OK

 

Drop the Paramter field onto your report and now you have LOV that is asked for at Run time.

If youwant it to act as a filter you add that into your Crystal Select Statement.

Click on the Slect Expert

Hit New

Pick the same field you used to populate your LOV parameter.

Change it to "is equal to"

Now in the next field click  on the select arrow and wait for it to populate.

The first option should be the {?LOV_test}.

Pick it

Hit OK.

Now your data is filtered by whatever you select from that LOV at report runtime.

Does that clear it up?