/* Report Builder Export Tool */ version:1.0 /* Report Name: Serial Numbers Issued */ /* Export File Generated: : 2014-05-07 08:05:53 */ /* Language Fields. */ /* Only modify the language portion between the single quotes after the colon. */ /* Report Name and Title Information: */ ReportName:'Serial Numbers Issued' Title1Desc:'%reportname%' Title2Desc:'Report Generated %date%' /* Report Field Description Information: */ FieldDesc0:'Serial_No.' FieldDesc2:'Date' FieldDesc3:'seq.' FieldDesc4:'Serial_No.' FieldDesc5:'Ident' FieldDesc6:'Work_Order' FieldDesc7:'loc' FieldDesc8:'change' FieldDesc9:'onhand' FieldDesc10:'move' FieldDesc11:'Serial_No.' FieldDesc12:'Item' /* End of language fields. */ /* DO NOT EDIT BELOW THIS LINE! */ /* SQL report data. */ ReportData:reportname='Serial Numbers Issued', reporttype='rpt', groupname='man', defaultreport='1', papersize='Letter:216:282', paperorientation='P', margintop='10', marginbottom='10', marginleft='10', marginright='10', coynamefont='helvetica', coynamefontsize='12', coynamefontcolor='0:0:0', coynamealign='C', coynameshow='1', title1desc='%reportname%', title1font='helvetica', title1fontsize='10', title1fontcolor='0:0:0', title1fontalign='C', title1show='1', title2desc='Report Generated %date%', title2font='helvetica', title2fontsize='10', title2fontcolor='0:0:0', title2fontalign='C', title2show='1', filterfont='helvetica', filterfontsize='8', filterfontcolor='0:0:0', filterfontalign='L', datafont='helvetica', datafontsize='10', datafontcolor='0:0:0', datafontalign='L', totalsfont='helvetica', totalsfontsize='10', totalsfontcolor='0:0:0', totalsfontalign='L', col1width='25', col2width='25', col3width='25', col4width='25', col5width='25', col6width='25', col7width='25', col8width='25', col9width='25', col10width='25', col11width='25', col12width='25', col13width='25', col14width='25', col15width='25', col16width='25', col17width='25', col18width='25', col19width='25', col20width='25', table1='worequirements', table2='stockserialitems', table2criteria='worequirements.stockid = stockserialitems.stockid', table3='stockserialmoves', table3criteria='stockserialmoves.serialno = stockserialitems.serialno', table4='stockmoves', table4criteria='stockmoves.stkmoveno=stockserialmoves.stockmoveno', table5='systypes', table5criteria='systypes.typeid = stockmoves.type', table6='', table6criteria=''; /* SQL field data. */ FieldData0:entrytype='critlist', seqnum='1', fieldname='stockserialitems.serialno', displaydesc='Serial_No.', visible='0', columnbreak='0', params='1'; FieldData1:entrytype='dateselect', seqnum='0', fieldname='', displaydesc='a', visible='1', columnbreak='1', params='a'; FieldData2:entrytype='fieldlist', seqnum='1', fieldname='stockmoves.trandate', displaydesc='Date', visible='1', columnbreak='1', params='0'; FieldData3:entrytype='fieldlist', seqnum='2', fieldname='stockmoves.stkmoveno', displaydesc='seq.', visible='1', columnbreak='1', params='0'; FieldData4:entrytype='fieldlist', seqnum='3', fieldname='stockserialitems.serialno', displaydesc='Serial_No.', visible='1', columnbreak='1', params='0'; FieldData5:entrytype='fieldlist', seqnum='4', fieldname='stockserialitems.stockid', displaydesc='Ident', visible='1', columnbreak='1', params='0'; FieldData6:entrytype='fieldlist', seqnum='5', fieldname='worequirements.wo', displaydesc='Work_Order', visible='1', columnbreak='1', params='0'; FieldData7:entrytype='fieldlist', seqnum='6', fieldname='stockmoves.loccode', displaydesc='loc', visible='1', columnbreak='1', params='0'; FieldData8:entrytype='fieldlist', seqnum='7', fieldname='stockserialmoves.moveqty', displaydesc='change', visible='1', columnbreak='1', params='0'; FieldData9:entrytype='fieldlist', seqnum='8', fieldname='stockserialitems.quantity', displaydesc='onhand', visible='1', columnbreak='1', params='0'; FieldData10:entrytype='sortlist', seqnum='1', fieldname='stockmoves.stkmoveno', displaydesc='move', visible='0', columnbreak='0', params='1'; FieldData11:entrytype='sortlist', seqnum='2', fieldname='stockserialitems.serialno', displaydesc='Serial_No.', visible='0', columnbreak='0', params='1'; FieldData12:entrytype='sortlist', seqnum='3', fieldname='stockserialitems.stockid', displaydesc='Item', visible='0', columnbreak='0', params='1'; FieldData13:entrytype='trunclong', seqnum='0', fieldname='', displaydesc='', visible='1', columnbreak='1', params='0'; /* End of Export File */