Inside VB using Crystal Report

How to Intract with the Crystal Report Data like Report Title and Date. Can I change the Date or title of the field from the Visual Basic?


How can I Calculate the Accumulation of the field in the Crystal Report.
I give the example Below. Here I want the balance Column

Debit      Credit        Balance
--------------------------------
100          0             100
0            65               35
70            0             105
0            50               55
-----------------------------
170       115               55
-----------------------------
kazendiraneAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

kazendiraneAuthor Commented:
Edited text of question.
0
yjtCommented:
Hi!

There are two methods that you can use to sum up your column.
1) Creating a new formula by going to menu item Insert->formula field and specify a new formula name. eg TotBalance. This will bring up the formula builder. Type in:
Sum ({tblProd.Balance})

where tblProd.Balance refers to your table's balance field. Drag the formula to your footer and place it there.

2) Assume that you have a group header and footer defined. Right click on the balance field in the detail section. Choose Insert subtotal and choose the group name. The sum field will automatically be added for you at the footer.

And for your other question, you can use a formula to control whatever is displayed as the field title. Create a new formula and named it TitleCol. In the formula builder, you can change it as you will. Eg:

If {tblProd.Balance} = 0 then
     "BALANCE"
else
     "TOTAL"

the method above allows you to change the title field to display as balance or total

Good Luck!
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
kazendiraneAuthor Commented:
Dear vit
In this report I want the Calculation of Balance row by row
in which the balance column accumulated row by row.

As well as How to send the Parameters to the report.
Can I send the date or name to the report from Visual Basic?

0
yjtCommented:
You can have a look at how to pass fields to CReport using VB:

http://www.experts-exchange.com/secure/bin/Q.10248766
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.