/* Report Builder Export Tool */ version:1.0 /* Report Name: Sales Order Report */ /* Export File Generated: : 2010-05-20 03:05:05 */ /* Language Fields. */ /* Only modify the language portion between the single quotes after the colon. */ /* Report Name and Title Information: */ ReportName:'Sales Order Report' Title1Desc:'%reportname%' Title2Desc:'Report Generated %date%' /* Report Field Description Information: */ FieldDesc0:'is Quotation or Not' FieldDesc1:'Sales is Completed' FieldDesc3:'EntryDate' FieldDesc4:'S.No' FieldDesc5:'Customer' FieldDesc6:'OrderNo' FieldDesc7:'ProductName' FieldDesc8:'Quantity' FieldDesc9:'Sent' FieldDesc10:'LastSentDate' FieldDesc11:'CustomerName' FieldDesc12:'ProductName' FieldDesc13:'CustomerName' FieldDesc14:'ProductName' /* End of language fields. */ /* DO NOT EDIT BELOW THIS LINE! */ /* SQL report data. */ ReportData:reportname='Sales Order Report', reporttype='rpt', groupname='ord', defaultreport='1', papersize='A4:210:297', paperorientation='P', margintop='10', marginbottom='10', marginleft='10', marginright='10', coynamefont='helvetica', coynamefontsize='8', coynamefontcolor='0:0:0', coynamealign='C', coynameshow='1', title1desc='%reportname%', title1font='helvetica', title1fontsize='8', title1fontcolor='0:0:0', title1fontalign='C', title1show='1', title2desc='Report Generated %date%', title2font='helvetica', title2fontsize='8', title2fontcolor='0:0:0', title2fontalign='C', title2show='1', filterfont='helvetica', filterfontsize='8', filterfontcolor='0:0:0', filterfontalign='L', datafont='helvetica', datafontsize='8', datafontcolor='0:0:0', datafontalign='L', totalsfont='helvetica', totalsfontsize='8', totalsfontcolor='0:0:0', totalsfontalign='L', col1width='18', col2width='10', col3width='20', col4width='20', col5width='50', col6width='13', col7width='13', col8width='30', table1='salesorders', table2='salesorderdetails', table2criteria='salesorders.orderno=salesorderdetails.orderno', table3='stockmaster', table3criteria='salesorderdetails.stkcode=stockmaster.stockid', table4='', table4criteria='', table5='', table5criteria='', table6='', table6criteria=''; /* SQL field data. */ FieldData0:entrytype='critlist', seqnum='1', fieldname='salesorders.quotation', displaydesc='is Quotation or Not', visible='0', columnbreak='0', params='3'; FieldData1:entrytype='critlist', seqnum='2', fieldname='salesorderdetails.completed', displaydesc='Sales is Completed', visible='0', columnbreak='0', params='3'; FieldData2:entrytype='dateselect', seqnum='0', fieldname='salesorders.orddate', displaydesc='abcdfhj', visible='1', columnbreak='1', params='a'; FieldData3:entrytype='fieldlist', seqnum='1', fieldname='salesorders.orddate', displaydesc='EntryDate', visible='1', columnbreak='1', params='0'; FieldData4:entrytype='fieldlist', seqnum='2', fieldname='salesorders.orderno', displaydesc='S.No', visible='1', columnbreak='1', params='0'; FieldData5:entrytype='fieldlist', seqnum='3', fieldname='salesorders.debtorno', displaydesc='Customer', visible='1', columnbreak='1', params='0'; FieldData6:entrytype='fieldlist', seqnum='4', fieldname='salesorderdetails.poline', displaydesc='OrderNo', visible='1', columnbreak='1', params='0'; FieldData7:entrytype='fieldlist', seqnum='5', fieldname='stockmaster.description', displaydesc='ProductName', visible='1', columnbreak='1', params='0'; FieldData8:entrytype='fieldlist', seqnum='6', fieldname='salesorderdetails.quantity', displaydesc='Quantity', visible='1', columnbreak='1', params='1'; FieldData9:entrytype='fieldlist', seqnum='7', fieldname='salesorderdetails.qtyinvoiced', displaydesc='Sent', visible='1', columnbreak='1', params='1'; FieldData10:entrytype='fieldlist', seqnum='8', fieldname='salesorderdetails.actualdispatchdate', displaydesc='LastSentDate', visible='1', columnbreak='1', params='0'; FieldData11:entrytype='grouplist', seqnum='1', fieldname='salesorders.debtorno', displaydesc='CustomerName', visible='0', columnbreak='0', params='0'; FieldData12:entrytype='grouplist', seqnum='2', fieldname='stockmaster.description', displaydesc='ProductName', visible='0', columnbreak='0', params='0'; FieldData13:entrytype='sortlist', seqnum='1', fieldname='salesorders.debtorno', displaydesc='CustomerName', visible='0', columnbreak='0', params='0'; FieldData14:entrytype='sortlist', seqnum='2', fieldname='stockmaster.description', displaydesc='ProductName', visible='0', columnbreak='0', params='0'; FieldData15:entrytype='trunclong', seqnum='0', fieldname='', displaydesc='', visible='1', columnbreak='1', params='0'; /* End of Export File */