Adding from two different reportitems

Question

I am trying to add from two separate text boxes from different datasets I had to create a code to summarize (codes below) giving a total. What I am trying to do is get GapTotal + GapTotal2 together into a separate dataset. Unfortunately I get a blank. Can anyone help? Thank you in advance

Public GapTotal AS Integer = 0
Public Function Sum(ByVal Value As Integer) As Integer
GapTotal = GapTotal + Value
Return Value
End Function


Public GapTotal2 AS Integer = 0
Public Function SumIt(ByVal Value As Integer) As Integer
GapTotal2 = GapTotal2 + Value
Return Value

End Function

Welcome to Stackoverflow! Please can you improve the formatting of your question? — Nilesh, Jul 02 '15 at 05:22

score 0 · Answer 1 · edited May 23 '17 at 11:58

0

There are two possible approaches l can think of here.

First reference the values in each dataset and add the values see this posting - Stack Overflow posting

Second place the values from each data into a control eg a text box, then add the values in each text box see - SQL Server Central posting

edited May 23 '17 at 11:58

Community

1
1

answered Jul 02 '15 at 08:34

SQLBobScot

694
5
20

Thank you! I appreciate your response. – donalejandro Jul 03 '15 at 06:35

Adding from two different reportitems

1 Answers1