Visual Basic.NET data output issue on an Accounting Report.
Posted on 2007-03-30
We have an Accounting report generated from VB.NET that will list our Job Numbers starting with nines (93153 for example) before the other Job Numbers are listed sequentially no matter if the report is generated by Job Number, Name, Task Desc, Client or Billing Level. We would like that only when sorting by Job Number are our Accounting reports being generated starting with Job Numbers starting with nines. Below are the relevent codes that currently place Job Numbers starting with nines first on any sort. Any assistance offered would be greatly appreciated.
SQLConn = New SqlConnection(DWMA.ConnectionString)
DA = New SqlDataAdapter(strSQL, SQLConn)
DS = New DataSet()
dtReport = DS.Tables(0)
dtReport = oCipher.SortReport(dtReport, sSortFld, sSortOrder)
dtReport = oCipher.Sort9sOnTop(dtReport)
Catch SQLExc As SqlException
lblReportType.Text &= "Project Number"
strSQL &= " ORDER BY ProjNum " & sSortOrder & ", TaskNum " & sSortOrder
sSortFld = "ProjNum"