954,535 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

display data in crystal report using vb

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.

Es Sayen
Newbie Poster
19 posts since Jun 2007
Reputation Points: 10
Solved Threads: 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.

kshrini
Light Poster
45 posts since Jun 2007
Reputation Points: 10
Solved Threads: 3
 

This question has already been solved

Post: Markdown Syntax: Formatting Help
You