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
gangaloves7 0 Newbie Poster
AndreRet 526 Senior Poster
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 AndreRet 526 Senior Poster
@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.