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.