Write now my code works..however....my label lblHMROrdersTotal.Text shows up like this
00215,000456,00
215
As you can see the page length makes the end number print on two lines, how can I get the ending 00 to print on the 215 line so the number stays together,
Public Sub GetOrders()
SqlShippingReport.SelectCommand = "SELECT ORD1PONBR, FULLORDID FROM ORDERHDR " & _
" WHERE ACCTNBR='" & lblAccount.Text & "' and CRDT >='" & Session("StartDate") & _
"' and CRDT <='" & Session("EndDate") & "'"
Dim dv As DataView = CType(SqlShippingReport.Select(DataSourceSelectArguments.Empty), DataView)
Dim orderCount As Integer = 0
If dv.Count > 0 Then
Dim i As Integer = 0
Do Until i = ...
Go to the complete details ...