0

hello all,

i have to prepare a report which will display data from a specific date upto the specific date, both will be defined by the user at run time.
the report is connected with the database and front end is vb. I am using crystal report for this.
i want to know how to do this, if a user enter both the dates in twp different textbox then how a report will display only related data.

If anyone know please tell me.

Thanks in advance.

2
Contributors
1
Reply
3
Views
9 Years
Discussion Span
Last Post by kshrini
0

Hi,
You need to use SelectionFormula property of Crystal Report Control

crptCtl.SelectionFormula="{tablename.fieldname}>=#" & fromDate & "# AND {tablename.fieldname}<=#" & toDate & "#"

I have not checked it, but should work.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.