I created a form that allows the user to enter selection criteria (including date range) in unbound text boxes and then print a report showing the selected records. I generate a query by constructing the WHERE clause in the SQL statement from the selected parameters. This works fine. My question is, how can I print the selected date range on the report header?

I know I can re-design the query with parameters that the user must enter at the prompt and then let these parameter prompts be the control source for the text boxes on the report. But is there any way to use the information directly from the form? In general, how do you get information from an unbound text box into the report?

Thanks for your help.

Try This

CrystalReport1.Formula(0) = "FormulaName = Format(StartDate,"dd/mm/yy")
CrystalReport1.Formula(1) = "FormulaName = Format(EndDate,"dd/mm/yy")


Zubair Khan