crystal reports XI - how to filter the contents of a dynamic combo box in a parameter field
Posted on 2007-10-04
i have 2 fields in seperate tables
one is employee surnames - f_employ.sname
the other is their category - f_cat.value
i set up a parameter field ?name, which is dynamically populated from f_employ.sname, no problem, and i can then base a select record formula on that, get the drop down box, select my name(s) and away we go - so far, so good
the difficulty arises because f_employ.sname contains about 200 values and i am only actually interested in those where the equivalent f_cat.value = 1.0
i can't find a way to limit the drop down box to only those f_employ.sname values that have a corresponding f_cat.value of 1.00 (the 2 tables are linked with an inner join BTW)
does that make sense as a question ?
anyone able to help ??