Member Avatar for Es Sayen

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
  • 106 Views
  • 5 Days Discussion Span
  • Latest Post Latest Post by kshrini
Member Avatar for kshrini

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.