By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,320 Members | 1,893 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,320 IT Pros & Developers. It's quick & easy.

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

P: n/a
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.

Oct 24 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.