/* Report Builder Export Tool */ version:1.0 /* Report Name: Ser. Nos. at Customer */ /* Export File Generated: : 2014-05-07 08:05:43 */ /* Language Fields. */ /* Only modify the language portion between the single quotes after the colon. */ /* Report Name and Title Information: */ ReportName:'Ser. Nos. at Customer' Title1Desc:'%reportname%' Title2Desc:'Report Generated %date%' /* Report Field Description Information: */ FieldDesc0:'Item' FieldDesc1:'Customer' FieldDesc2:'Serial Number' FieldDesc4:'Item' FieldDesc5:'Customer' FieldDesc6:'branch' FieldDesc7:'Type' FieldDesc8:'Date' FieldDesc9:'Serial Number' FieldDesc10:'Customer' FieldDesc11:'Item' FieldDesc12:'Date' FieldDesc13:'Item' FieldDesc14:'Customer' FieldDesc15:'trans date' FieldDesc16:'Serial Number' /* End of language fields. */ /* DO NOT EDIT BELOW THIS LINE! */ /* SQL report data. */ ReportData:reportname='Ser. Nos. at Customer', reporttype='rpt', groupname='inv', defaultreport='1', papersize='Letter:216:282', paperorientation='L', margintop='10', marginbottom='15', 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='50', col2width='40', col3width='30', col4width='30', col5width='30', col6width='40', col7width='50', 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='stockmoves', table2='debtorsmaster', table2criteria='debtorsmaster.debtorno = stockmoves.debtorno', table3='systypes', table3criteria='stockmoves.type = systypes.typeid', table4='stockserialmoves', table4criteria='stockmoves.stkmoveno = stockserialmoves.stockmoveno', table5='', table5criteria='', table6='', table6criteria=''; /* SQL field data. */ FieldData0:entrytype='critlist', seqnum='1', fieldname='stockmoves.stockid', displaydesc='Item', visible='0', columnbreak='0', params='0'; FieldData1:entrytype='critlist', seqnum='2', fieldname='stockmoves.debtorno', displaydesc='Customer', visible='0', columnbreak='0', params='0'; FieldData2:entrytype='critlist', seqnum='3', fieldname='stockserialmoves.serialno', displaydesc='Serial Number', visible='0', columnbreak='0', params='0'; FieldData3:entrytype='dateselect', seqnum='0', fieldname='stockmoves.trandate', displaydesc='ab', visible='1', columnbreak='1', params='a'; FieldData4:entrytype='fieldlist', seqnum='1', fieldname='stockmoves.stockid', displaydesc='Item', visible='1', columnbreak='1', params='0'; FieldData5:entrytype='fieldlist', seqnum='2', fieldname='debtorsmaster.name', displaydesc='Customer', visible='1', columnbreak='1', params='0'; FieldData6:entrytype='fieldlist', seqnum='3', fieldname='stockmoves.branchcode', displaydesc='branch', visible='1', columnbreak='1', params='0'; FieldData7:entrytype='fieldlist', seqnum='4', fieldname='systypes.typename', displaydesc='Type', visible='1', columnbreak='1', params='0'; FieldData8:entrytype='fieldlist', seqnum='5', fieldname='stockmoves.trandate', displaydesc='Date', visible='1', columnbreak='1', params='0'; FieldData9:entrytype='fieldlist', seqnum='6', fieldname='stockserialmoves.serialno', displaydesc='Serial Number', visible='1', columnbreak='1', params='0'; FieldData10:entrytype='grouplist', seqnum='1', fieldname='stockmoves.debtorno', displaydesc='Customer', visible='0', columnbreak='0', params='0'; FieldData11:entrytype='grouplist', seqnum='2', fieldname='stockmoves.stockid', displaydesc='Item', visible='0', columnbreak='0', params='0'; FieldData12:entrytype='grouplist', seqnum='3', fieldname='stockmoves.trandate', displaydesc='Date', visible='0', columnbreak='0', params='0'; FieldData13:entrytype='sortlist', seqnum='1', fieldname='stockmoves.stockid', displaydesc='Item', visible='0', columnbreak='0', params='1'; FieldData14:entrytype='sortlist', seqnum='2', fieldname='stockmoves.debtorno', displaydesc='Customer', visible='0', columnbreak='0', params='0'; FieldData15:entrytype='sortlist', seqnum='3', fieldname='stockmoves.trandate', displaydesc='trans date', visible='0', columnbreak='0', params='0'; FieldData16:entrytype='sortlist', seqnum='4', fieldname='stockserialmoves.serialno', displaydesc='Serial Number', visible='0', columnbreak='0', params='0'; FieldData17:entrytype='trunclong', seqnum='0', fieldname='', displaydesc='', visible='1', columnbreak='1', params='1'; /* End of Export File */