This is the interface i want to display:
---------------------------------------------------------------------------------------------
Enter Facility:
Enter ItemNoFrom:
Enter ItemNoTo:
Enter Status:
---------------------------------------------------------------------------------------------
(a) For Enter Facility, Enter ItemNoFrom, Enter ItemNoTo i already done.
(b) Now what i still don't know how to do is the Enter Status part.
For the Enter Status part, i want to let user choose either user want
the "Match" record or "Not Match" record.
i want the formula something around like this:
if {?Status} ="1" then (
{table1.status}={?Status} and
{table2.status}={?Status} and
{table3.status}={?Status} )
else
{table1.status}<>{?Status} and
{table2.status}<>{?Status} and
{table3.status}<>{?Status} )
But like this formula is have error, so i not sure how to do the "Not
Match" part formula.
(c) Because after i done this crystal report, i need to put into vb.net to
become a part report for my application.
Thanks for your help.

Edited by angelyin1984 - 16 Jul 2009 at 11:07pm