i want to generate crystal report using vb6.0 using invoice table which have rate column and total should round up like 63.7 to 64.00 invoice table is in sqlserver 2005

We do not answer posts starting with "Help, Urgent, Need" etc. You should know this after 10 posts....;)

To your question, to get the values calculated, write a loop going through each record -

'All your open recordset code here FIRST

Dim xCount As Integer, xVal As Integer
xCount = 0
xVal = 0

Do While rsRecSet.EOF = False
xCount = rsRecSet!MyValueFieldNameHere
xVal = xVal + xCount
xCount = 0
Loop

Text1.Text = xVal

@Gangaloves7, please mark this thread as solved found at the bottom of this page, thanks.:)

It has been open for some time now.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.