Print "label X Of Y" Based On Record Count From Sql

Legacy Poster

• 2012年05月07日 21:17

I am trying to utilize the "Label X of Y" serialization sample component. I am polling data from my SQL database, and need to be able to use the total record count for my 'Y' value in the 'X of Y' expression. Has anyone done this successfully? I have read many posts on counting total records from .TXT files, but have come across nothing that fits my scenario.

0

• 

  Legacy Poster

  ★ BarTender Hero ★

  • 2013年01月29日 19:17
  [quote name='Austin Mathis' timestamp='1336425451' post='2367']
  I am trying to utilize the "Label X of Y" serialization sample component. I am polling data from my SQL database, and need to be able to use the total record count for my 'Y' value in the 'X of Y' expression. Has anyone done this successfully? I have read many posts on counting total records from .TXT files, but have come across nothing that fits my scenario.
  [/quote]
  
  Do you have a sequence count on each record you are printing? I've written seq 0001, 0002, 0003 to the records and am using the following vbscript to help create 1 of 3, etc.
  
  set con=createobject("ADODB.Connection")
  con.open "ODBC database name","userid","password"
  set rst=con.execute("Select count(Terminal) as WBC from V_BI_BIN_LABELS Where Terminal = '"+Field("V_BI_BIN_LABELS.TERMINAL") + "' and Report_ID = '" + Field("V_BI_BIN_LABELS.REPORT_ID")+"'")
  sLblCount=cstr(rst("WBC"))
  rst.close
  con.close
  set rst=nothing
  set con=nothing
  Value =cstr(clng(Field("V_BI_BIN_LABELS.SEQUENCE")))+" of "+sLblCount

  0

请先登录再写评论。