Skip to Content
0
Former Member
Oct 25, 2007 at 01:26 AM

How to have access to the fields in the crystal report using VB.NET (outside the design of the crystal report) with SQL stateme

56 Views

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.