How to have access to the fields in the crystal report using VB.NET (outside the design of the cryst

Hello,

I am developing a crystal report called Expense Report (I am not an
expert Crystal Report designer) if someone could help me in this
problem I would be greatly appreciate it. The report would be as
follows:



Description Sun Mon
Tue Wed Thurs Fri Sat Total

Computers

Apple II gs, Amiga 1200,

Commodore 64


Underneath the fields of Sun, Mon, Tue, Wed, Thurs, Fri, and Sat are
unbound currency fields called: Unbound Currency 1, Unbound Currency
2, Unbound Currency 3, Unbound Currency 4, Unbound Currency 5, Unbound
Currency 6 and Unbound Currency 7. Where the Unbound Currency
represents the following conditions:

Unbound Currency 1 = Sun

Unbound Currency 2 = Mon

Unbound Currency 3 = Tue

Unbound Currency 4 = Wed

Unbound Currency 5 = Thurs

Unbound Currency 6 = Fri
Unbound Currency 7 = Sat



The table expenseReport have the following fields:

ReportID

ExpenseType

Source

Price

Date



When the user enters for example the item "Apple II gs" with Price
30.00 and Date Wednesday 3, 2007 I want to be able to extract the date
Wednesday and check the condition if the selected date equals to
Wednesday then fill Unbound Currency 4 with the price while the rest
of the Unbound Currency is not filled up. How do I do that outside
the design of Crystal Report by using VB.NET and SQL statement?



To simplify matters even more how do I have access to the fields in
crystal report using VB.NET and SQL in another form for example? Thank
you very much.