Skip to Content
0
Nov 27, 2012 at 04:15 PM

Drop down list parameter

1349 Views

Hi

I'm trying to create a crystal report which will display a number of fields based on a user inputting a catalogue number, and then selecting the batch number (with the batch number to come from a list of batch numbers available for the chosen catalogue number)

I'm using OBTN table and fields Itemcode, Itemname, Distnumber, Notes

My first parameter prompts the user to enter a catalogue number and in select expert I have {OBTN.ItemCode} = {?Catalogue number}

For the second parameter I am getting stuck with how to get the drop down list of batch numbers associated with this catalogue number

I have tried to use "batch@SELECT DISTNUMBER From OBTN" as the name for my parameter, but I'm not getting a drop down list

Also I tried a simpler report from the crystal reports manual below:

MyParameter@SELECT * FROM OITM

http://www.pioneerb1.com/wp-content/uploads/2012/04/How-to-work-with-Crystal-Reports-8.8.pdf

But this did not give me a drop down list

My crystal reports is Basic 2008

Any help appreciated!

Thanks

Vicky