Attach print selection list to table field in database

[Saturn57]

I have a parameter used to select a print range in crystal reports. Is there a way to attach the pulldown list to a database field so the user does not have to remember the exact fields to type in. Note the field range is not static and changes all the time. Thanks

 

[lbass]

Ranges of what? Strings? numbers? dates? Why would there be standard though dynamic ranges? Please be more specific.

-LB

 

[Saturn57]

They are ranges of quote numbers in a data base. So they would be numbers. As we generate new quotes we will get new numbers so the range of values is always increasing.

 

[lbass]

Use a dynamic parameter for {?quotestart} and another dynamic one for {?quoteend}--assuming you have a high enough version of CR (which you should always identify).

-LB

 

[Saturn57]

When I create a parameter it only allows me to import the existing list of variables. Does this mean im at an older version of CR. Note it is the version integrated with visual studio 2005

 

[lbass]

I don't really know what is available in that version. If dynamic parameters are an option, then you should see the option of "static" or "dynamic" when you open the parameter setup screen.

-LB