Use a formula field in the report for your record selection formula. Then when you instantiate the report in code, set the formula field's value using the value in the drop down list.  (in C#)

myReport.DataDefinition.FormulaFields("formulaname").Text="""" + dropDownList.Text + """";

If it isn't a text dropdown value, then you don't need to insert the double quotes around the field's value.

I cover this on page 318 in my book, "CR.NET Programming"


Edited by BrianBischof - 24 Sep 2007 at 9:28am