/* Report Builder Export Tool */ version:1.0 /* Report Name: Inventory at Customer */ /* Export File Generated: : 2014-05-07 08:05:38 */ /* Language Fields. */ /* Only modify the language portion between the single quotes after the colon. */ /* Report Name and Title Information: */ ReportName:'Inventory at Customer' Title1Desc:'%reportname%' Title2Desc:'Report Generated %date%' /* Report Field Description Information: */ FieldDesc0:'Item' FieldDesc1:'Customer' FieldDesc3:'Item' FieldDesc4:'Customer' FieldDesc5:'branch' FieldDesc6:'Type' FieldDesc7:'Date' FieldDesc8:'Quantity' FieldDesc9:'Customer' FieldDesc10:'Item' FieldDesc11:'Date' FieldDesc12:'Item' FieldDesc13:'Customer' FieldDesc14:'trans date' /* End of language fields. */ /* DO NOT EDIT BELOW THIS LINE! */ /* SQL report data. */ ReportData:reportname='Inventory at Customer', reporttype='rpt', groupname='inv', defaultreport='1', papersize='Letter:216:282', paperorientation='P', 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='50', 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='stockmoves', table2='debtorsmaster', table2criteria='debtorsmaster.debtorno = stockmoves.debtorno', table3='systypes', table3criteria='stockmoves.type = systypes.typeid', table4='', table4criteria='', 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='dateselect', seqnum='0', fieldname='stockmoves.trandate', displaydesc='ab', visible='1', columnbreak='1', params='a'; FieldData3:entrytype='fieldlist', seqnum='1', fieldname='stockmoves.stockid', displaydesc='Item', visible='1', columnbreak='1', params='0'; FieldData4:entrytype='fieldlist', seqnum='2', fieldname='debtorsmaster.name', displaydesc='Customer', visible='1', columnbreak='1', params='0'; FieldData5:entrytype='fieldlist', seqnum='3', fieldname='stockmoves.branchcode', displaydesc='branch', visible='1', columnbreak='1', params='0'; FieldData6:entrytype='fieldlist', seqnum='4', fieldname='systypes.typename', displaydesc='Type', visible='1', columnbreak='1', params='0'; FieldData7:entrytype='fieldlist', seqnum='5', fieldname='stockmoves.trandate', displaydesc='Date', visible='1', columnbreak='1', params='0'; FieldData8:entrytype='fieldlist', seqnum='6', fieldname='stockmoves.qty', displaydesc='Quantity', visible='1', columnbreak='1', params='1'; FieldData9:entrytype='grouplist', seqnum='1', fieldname='stockmoves.debtorno', displaydesc='Customer', visible='0', columnbreak='0', params='1'; FieldData10:entrytype='grouplist', seqnum='2', fieldname='stockmoves.stockid', displaydesc='Item', visible='0', columnbreak='0', params='1'; FieldData11:entrytype='grouplist', seqnum='3', fieldname='stockmoves.trandate', displaydesc='Date', visible='0', columnbreak='0', params='1'; FieldData12:entrytype='sortlist', seqnum='1', fieldname='stockmoves.stockid', displaydesc='Item', visible='0', columnbreak='0', params='1'; FieldData13:entrytype='sortlist', seqnum='2', fieldname='stockmoves.debtorno', displaydesc='Customer', visible='0', columnbreak='0', params='0'; FieldData14:entrytype='sortlist', seqnum='3', fieldname='stockmoves.trandate', displaydesc='trans date', visible='0', columnbreak='0', params='0'; FieldData15:entrytype='trunclong', seqnum='0', fieldname='', displaydesc='', visible='1', columnbreak='1', params='0'; /* End of Export File */