dfilimon Опубликовано: 11 марта, 2011 Share Опубликовано: 11 марта, 2011 Подскажите, как в отчет "произвдственный лист" добавить размер створки по фальцу, из какой таблицы его можно взять? Цитата Ссылка на комментарий Поделиться на других сайтах More sharing options...
speaker Опубликовано: 20 марта, 2011 Share Опубликовано: 20 марта, 2011 (изменено) посмотри этот производственный лист, там есть фальц <HTML> <HEAD> <TITLE></TITLE> <META content="text/html; charset=windows-1251" http-equiv=Content-Type> <META NAME="Generator" CONTENT="ProfSegment WorkShop"> <META NAME="Author" CONTENT="I?IONO?IE"> <META NAME="Keywords" CONTENT="I?IONO?IE"> <META NAME="Description" CONTENT="I?IONO?IE"> </HEAD> <BODY> <CENTER> <~OI?IINOU:IA?CAOAEUIA?:2~> <~OI?IINOU:AIIIEIEOAEUIA?:0~> <!-- Noaiaa?oiay oaaeeoa --> <TABLE WIDTH=640 style="border-collapse: collapse; font-size:11px; text-align:left; font-family:Arial; color:#0; font-weight: none;" bgColor=#FFFFFF cellpadding=1 spacepadding=1 border=1 bordercolor=#0> <TR> <TD WIDTH=640 COLSPAN=2><b>I?IECAIANOAAIIUE EENO<span style='font-size:15pt'><~I?IAEO:IIIA?_CAEACA~> ? <~ECAAEEA:IIIA?~></span></b></td> </td> </TR> <TR> <TD WIDTH=280>Caeac?ee:<b><~@caeac?ee=PRJ_kName~><i><b><~ECAAEEA:IACAAIEA~></b></i></b></td> <TD WIDTH=360>Oe?. o Aun:<b><span style='font-size:15pt'><~ECAAEEA:OE?EIA~> o <~ECAAEEA:AUNIOA~></span></b><TR> </TD> </TR> <TR height=20> <TD WIDTH=280><b><!-- Ia?aiao?u--> Eiee?anoai : <b><span style='font-size:50pt'><~ECAAEEA:EIEE?ANOAI~></span></b> oo. </b> <TABLE style="border-collapse: collapse; font-size:16px; text-align:right; font-family:Arial; color:#0; font-weight: none;" bgColor=#FFFFFF cellpadding=1 spacepadding=1 border=1 bordercolor=#0> <~SET_SQL_PROG:SELECT aNumb,pNumb,nZp FROM tSaveZLT~> <~ADD_SQL_PROG:WHERE (pUnic=:^pUnic:)AND(oUnic=:^oUnic:)~> <~ADD_SQL_PROG:ORDER BY aNumb~> <~LOOP_SQL_PROG~> <~SQL_FILTER_PARORD:pView=1~> <~LOOP_PARORD~> <TR> <TD style=" text-align:left"><~PARORD:NAME~></TD><TD><b><~PARORD:VALUE~></b></TD> </TR> <~END_LOOP_PARORD~> <~SQL_FILTER_SPEC:aTypP=20~> <~LOOP_SPEC~> <TR><TD style=" text-align:left"> <~NIAO:IACAAIEA~></TD><TD> Oaao:<~NIAO:OAENOO?A~></TD> </TR> <~END_LOOP_SPEC~> </TD></TR> </TABLE> Oaeuo <!-- Oeee ii oaeuoai i?yiioaieuiuo noai?ie --> <b><span style='font-size:25pt'> <~SET_SQL_PROG:SELECT cIncR,oLeng,oHeig FROM tContOrd WHERE~> <~ADD_SQL_PROG:(pUnic=:^pUnic:)AND(oUnic=:^oUnic:)AND(nElem<0)~> <~LOOP_SQL_PROG~> <~PROG:#oLeng~> * <~PROG:#oHeig~> <br> <~END_SQL_PROG~> </span></b></td> <!-- Noaiaa?oiay oaaeeoa --> <TABLE style="border-collapse: collapse; font-size:12.5px; text-align:right; font-family:Arial; color:#0; font-weight: none;" bgColor=#FFFFFF cellpadding=1 spacepadding=1 border=1 bordercolor=#0> <TR> <~SET_SQL_PROG:SELECT DISTINCT pUnic,pNumb,aNumb FROM tSpecZLT WHERE (pUnic=:^pUnic:)AND(oUnic=:^oUnic:)AND(zPoin=0)~> <~LOOP_SQL_PROG~> </TD></TR> </TABLE> </TD> <TD WIDTH=360> -------------- <!-- Noaiaa?oiay oaaeeoa --> <TABLE WIDTH=360 style="border-collapse: collapse; font-size:10px; text-align:center; font-family:Arial; color:#0; font-weight: none;" bgColor=#FFFFFF cellpadding=1 spacepadding=1 border=1 bordercolor=#0> <~SQL_FILTER_SPEC:tSpecPAU.aTypM=1~> <TR><TD align=center bgcolor=#CCCCCC>I?IOEEE</TD><TD></TD></TR> <~LOOP_SPEC_SUM~> <TR> <TD align=left> <~NIAO:IACAAIEA~></TD> <TD> <~NIAO:IIAIIA?_IAUEE~> <~NIAO:AA_ECI~></TD> </TR> <~END_LOOP_SPEC~> <TR><TD align=center bgcolor=#CCCCCC>OIEIOIAIE?</TD><TD></TD></TR> <~SQL_FILTER_SPEC:tSpecPAU.aTypM=3 ~> <~LOOP_SPEC_SUM~> <TR> <TD align=left> <~NIAO:IACAAIEA~></TD> <TD> <~NIAO:IIAIIA?_IAUEE~> <~NIAO:AA_ECI~> </TD> </TR> <~END_LOOP_SPEC~> <TR><TD align=center bgcolor=#CCCCCC>CAIIEIAIE?</TD><TD></TD></TR> <~LOOP_ZAPL_SUM~> <TR> <TD align=left> <~CAI:IACAAIEA~></TD> <TD> <~CAI:IIAIIA?~> i.ea. </TD> </TD> </TR> <~END_LOOP_ZAPL~> </TABLE> -------------- </td> </TR> </TABLE> </TD> <TD rowspan=1 align=center width=150%><~ECAAEEA:YNEEC:640:640~> </TR></td> </TD> <~SET_SQL_PROG:SELECT DISTINCT pUnic,pNumb,aNumb FROM tSpecPAU WHERE (pUnic=:^pUnic:)AND(oUnic<>0)AND(aTypM=1)~> <~LOOP_SQL_PROG~> <BR><BR><BR> <TABLE WIDTH=640 style="border-collapse: collapse; font-size:11px; text-align:left; font-family:Arial; color:#0; font-weight: none;" bgColor=#FFFFFF cellpadding=1 spacepadding=1 border=1 bordercolor=#0> <TR> <TD WIDTH=640 COLSPAN=2><b> EENO ?ANE?I? I?IOEE?<span style='font-size:15pt'><~I?IAEO:IIIA?_CAEACA~> ? <~ECAAEEA:IIIA?~></span></b></td> </td> </TR> <TR> <TD WIDTH=280>Caeac?ee:<b><~@caeac?ee=PRJ_kName~><i><b><~ECAAEEA:IACAAIEA~></b></i></b></td> <TD WIDTH=360>Oe?. o Aun:<b><span style='font-size:15pt'><~ECAAEEA:OE?EIA~> o <~ECAAEEA:AUNIOA~></span></b><TR> </TD> </TR> <TR height=20> <TD WIDTH=280><b><!-- Ia?aiao?u--> Eiee?anoai : <b><span style='font-size:50pt'><~ECAAEEA:EIEE?ANOAI~></span></b> oo. </b> <TD rowspan=1 align=center ><~ECAAEEA:YNEEC:140:140~> </TD></TR> </TABLE> <TABLE WIDTH=600 style="border-collapse: collapse; font-size:20px; text-align:left; font-family:Arial; color:#0" bgColor=#FFFFFF cellpadding=2 spacepadding=2 border=1 bordercolor=#0> <!-- I?IOEEE --> <~SET_SQL_PROG:SELECT DISTINCT pNumb,aNumb FROM tSpecPAU WHERE (aTypM=1)AND(pUnic=:^pUnic:)~> <~LOOP_SQL_PROG~> <TR><TD colspan=8><BR> I?IOEEE</TD></TR> <TR> <TD align=center bgColor=#CCCCCC>Iacaaiea</TD> <TD align=center bgColor=#CCCCCC>Aeeia, ii</TD> <TD align=center bgColor=#CCCCCC>Oaeu ?aca</TD> <TD align=center bgColor=#CCCCCC>Eie-ai</TD> </TR> <~BREAK_LOOP_PROG~> <~END_SQL_PROG~> <~SET_SQL_PROG:SELECT DISTINCT pNumb,aNumb,clCod,clNum FROM tSpecPAU WHERE (pUnic=:^pUnic:)AND(aTypM=1)~> <~ADD_SQL_PROG:ORDER BY pNumb,aNumb,clCod,clNum~> <~LOOP_SQL_PROG~> <~I?IA_IA?AIAO?:OAEUE:iinoaauee:pNumb~> <~I?IA_IA?AIAO?:NO?IEA:a?oeeoe:aNumb~> <~I?IA_IA?AIAO?:OAEUE:oaao:clNum~> <TR> <TD valign=top><~I?IA:IACAAIEA~></TD> <TD align=center valign=top> <~SQL_FILTER_SPEC:(pNumb=:^iinoaauee:)AND(clNum=:^oaao:)AND(aNumb=':^a?oeeoe:')~> <~LOOP_SPEC_UNI~> <~NIAO:AEEIA~><BR> <~END_LOOP_SPEC~> </TD> <TD align=center valign=top> <~SQL_FILTER_SPEC:(pNumb=:^iinoaauee:)AND(clNum=:^oaao:)AND(aNumb=':^a?oeeoe:')~> <~LOOP_SPEC_UNI~> <~NIAO:OAEU_?ACA~><BR> <~END_LOOP_SPEC~> </TD> <TD align=center valign=top> <~SQL_FILTER_SPEC:(pNumb=:^iinoaauee:)AND(clNum=:^oaao:)AND(aNumb=':^a?oeeoe:')~> <~LOOP_SPEC_UNI~> <~NIAO:EIEE?ANOAI_OIEEAEUII_IAUAA~><BR> <~END_LOOP_SPEC~> </TD> </TR> <~END_SQL_PROG~> </TABLE> <TABLE WIDTH=600 style="border-collapse: collapse; font-size:10px; text-align:left; font-family:Arial; color:#0" bgColor=#FFFFFF cellpadding=2 spacepadding=2 border=1 bordercolor=#0> <TABLE WIDTH=600 style="border-collapse: collapse; font-size:10px; text-align:left; font-family:Arial; color:#0" bgColor=#FFFFFF cellpadding=2 spacepadding=2 border=1 bordercolor=#0> <!-- CAIIEIAIE? a ecaaeeyo i?yiioaieuiua --> <~SET_SQL_PROG:SELECT DISTINCT pUnic,pNumb,aNumb FROM tSpecZLT WHERE (pUnic=:^pUnic:)AND(zPoin=0)~> <~LOOP_SQL_PROG~> <TR><TD colspan=8 align=left><BR> I??IIOAIEUIUA CAIIEIAIE?</TD></TR> <TR> <TD bgColor=#CCCCCC align=center>Iinoaauee</TD> <TD bgColor=#CCCCCC align=center>A?oeeoe</TD> <TD bgColor=#CCCCCC align=center>Iacaaiea</TD> <TD bgColor=#CCCCCC align=center>Oaao</TD> <TD bgColor=#CCCCCC align=center colspan=2>Oe?. * Aun., ii</TD> <TD bgColor=#CCCCCC align=center colspan=2>Eie-ai</TD> </TR> <~SQL_FILTER_ZAPL:zPoin=0~> <~LOOP_ZAPL~> <TR> <TD><~CAI:IINOAAUEE~></TD> <TD><~CAI:A?OEEOE~></TD> <TD><~CAI:IACAAIEA~></TD> <TD><~CAI:OAAO~></TD> <TD align=center colspan=2 span style='font-size:10pt'><~CAI:AEEIA~> * <~CAI:OE?EIA~></TD span > <TD align=center colspan=2><~CAI:ANAAI~></TD> </TR> <~END_LOOP_ZAPL~> <~BREAK_LOOP_PROG~> <~END_SQL_PROG~> </TABLE> <TABLE WIDTH=600 style="border-collapse: collapse; font-size:10px; text-align:left; font-family:Arial; color:#0" bgColor=#FFFFFF cellpadding=2 spacepadding=2 border=1 bordercolor=#0> <!-- CAIIEIAIE? a ecaaeeyo iai?yiioaieuiua --> <~SET_SQL_PROG:SELECT DISTINCT pUnic,pNumb,aNumb FROM tSpecZLT WHERE (pUnic=:^pUnic:)AND(zPoin>0)~> <~LOOP_SQL_PROG~> <TR><TD colspan=8 align=left><BR> IAI??IIOAIEUIUA CAIIEIAIE?</TD></TR> <TR> <TD bgColor=#CCCCCC align=center>Iinoaauee</TD> <TD bgColor=#CCCCCC align=center>A?oeeoe</TD> <TD bgColor=#CCCCCC align=center>Iacaaiea</TD> <TD bgColor=#CCCCCC align=center>Oaao</TD> <TD bgColor=#CCCCCC align=center colspan=2>Oe?. * Aun., ii</TD> <TD bgColor=#CCCCCC align=center colspan=2>Eie-ai</TD> </TR> <~SQL_FILTER_ZAPL:zPoin>0~> <~LOOP_ZAPL~> <TR> <TD rowspan=2><~CAI:IINOAAUEE~><BR><~CAI:YNEEC:70~></TD> <TD><~CAI:A?OEEOE~></TD> <TD><~CAI:IACAAIEA~></TD> <TD><~CAI:OAAO~></TD> <TD align=center colspan=2 span style='font-size:10pt'><~CAI:AEEIA~> * <~CAI:OE?EIA~></TD span > <TD align=center colspan=2><~CAI:ANAAI~></TD> </TR> <TR> <TD colspan=7><~CAI:?ACEA~><BR><BR><BR><BR></TD> </TR> <~END_LOOP_ZAPL~> <~BREAK_LOOP_PROG~> <~END_SQL_PROG~> </TABLE> <TABLE WIDTH=600 style="border-collapse: collapse; font-size:10px; text-align:left; font-family:Arial; color:#0" bgColor=#FFFFFF cellpadding=2 spacepadding=2 border=1 bordercolor=#0> <!-- CAIIEIAIE? a aii. eiiieaeoo?ueo i?yiioaieuiua --> <~SET_SQL_PROG:SELECT DISTINCT pUnic,pNumb,aNumb FROM tSpecPAU WHERE (pUnic=:^pUnic:)AND(aTypM=5)~> <~LOOP_SQL_PROG~> <TR><TD colspan=8 align=left><BR> AII. CAIIEIAIE?</TD></TR> <TR> <TD bgColor=#CCCCCC align=center>Iinoaauee</TD> <TD bgColor=#CCCCCC align=center>A?oeeoe</TD> <TD bgColor=#CCCCCC align=center>Iacaaiea</TD> <TD bgColor=#CCCCCC align=center>Oaao</TD> <TD bgColor=#CCCCCC align=center colspan=2>Oe?. * Aun., ii</TD> <TD bgColor=#CCCCCC align=center colspan=2>Eie-ai</TD> </TR> <~SQL_FILTER_SPEC:aTypM=5~> <~LOOP_SPEC~> <TR> <TD><~NIAO:IINOAAUEE~></TD> <TD><~NIAO:A?OEEOE~></TD> <TD><~NIAO:IACAAIEA~></TD> <TD><~NIAO:OAAO~></TD> <TD align=center colspan=2 span style='font-size:10pt'><~NIAO:AEEIA~> * <~NIAO:OE?EIA~></TD span > <TD align=center colspan=2><~NIAO:ANAAI~></TD> </TR> <~END_LOOP_SPEC~> <~BREAK_LOOP_PROG~> <~END_SQL_PROG~> </TABLE> </BODY> </HTML> Изменено 20 марта, 2011 пользователем speaker Цитата Ссылка на комментарий Поделиться на других сайтах More sharing options...
Рекомендованные сообщения
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.