ConnectionInformix Provider=Ifxoledbc.2;Password=efectiva;User ID=informix;Data Source=tbase@ol_svr_custom;Persist Security Info=true ConnectionInformix False DataSource1 agencia,System.Int32 ntra,System.Int32 modn,System.Int32 ftra,System.DateTime fven,System.DateTime tdoc,System.Int32 nser,System.String adua,System.String corr,System.Int32 tdid,System.Int32 ndid,System.String nomb,System.String impt,System.Decimal iigv,System.Decimal vaag,System.Decimal itot,System.Decimal ndnd,System.Int32 tcam,System.Decimal fdor,System.DateTime tdoo,System.Int32 nseo,System.String ndoo,System.Int32 exon,System.Decimal otro,System.Decimal bole,System.Decimal 30 False DataSource1 ConnectionInformix {cadenaSQL} --EXECUTE PROCEDURE NET_REG_COMPRAS_T('', '') ,cadenaSQL,cadenaSQL,System.String,,False,False ,periodo,periodo,System.String,,False,False ,numeroPagina,numeroPagina,System.Int32,,False,False EngineV1 None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.4,33.6,1.6 None;Black;1;Dot;False;4;Black Transparent 0,0,12,0.4 Courier New,9 0,0,0,0 Texto1 {Config.NombreCia} Black Expression Center None;Black;1;Dot;False;4;Black Transparent 0,0.4,12,0.4 Courier New,9 0,0,0,0 Texto2 RUC: {Config.RucCia} Black Expression Center None;Black;1;Dot;False;4;Black Transparent 0,0.8,33.4,0.4 Courier New,11,Bold Center 0,0,0,0 Texto3 REGISTRO DE COMPRAS Black Expression Center None;Black;1;Dot;False;4;Black Transparent 0,1.2,33.4,0.4 Courier New,11,Bold Center 0,0,0,0 Texto4 {periodo} Black Expression Center None;Black;1;Dot;False;4;Black Transparent 26.2,0,3.4,0.4 Courier New,9 0,0,0,0 Texto5 Pagina {numeroPagina} Black Expression EncabezadoPágina1 None;Black;1;Dash;False;4;Black Transparent 0,2.8,33.6,2 Top, Right, Bottom;Black;1;Dot;False;4;Black Transparent 7,1.4,1.6,0.4 Courier New,6 Center 0,0,0,0 Texto21 NUMERO Black Expression Center Top, Right, Bottom;Black;1;Dot;False;4;Black Transparent 8.6,1,2.8,0.8 Courier New,6 Center 0,0,0,0 Texto22 APELLIDOS Y NOMBRES O RAZON SOCIAL Black Expression Center Top, Right, Bottom;Black;1;Dot;False;4;Black Transparent 11.4,1,2,0.8 Courier New,6 Center 0,0,0,0 Texto23 BASE IMPONIBLE Black Expression Center Top, Right, Bottom;Black;1;Dot;False;4;Black Transparent 6.6,1.4,0.4,0.4 Courier New,6 70c49e3871e14b04b2cc915c945d06ce Center 0,0,0,0 Texto6 TI Black Expression Center Top, Left, Right;Black;1;Dot;False;4;Black Transparent 6.6,0,4.8,1 Courier New,6 Center 0,0,0,0 Texto20 INFORMACION DEL PROVEEDOR Black Expression Center Top, Left, Right;Black;1;Dot;False;4;Black Transparent 11.4,0,3.8,1 Courier New,6 6bf2c03b73ae4554a74fa6e71c5d1c8d Center 0,0,0,0 Texto28 ADQ.GRAVADAS DESTINADAS A OPER.GRAVADAS Y/O DE EXPORTACION Black Expression Center Right, Bottom;Black;1;Dot;False;4;Black Transparent 1.2,1,1.2,0.8 Courier New,6 68c6d8cf8dc74da88af4cd6287799524 Center 0,0,0,0 Texto32 FECHA EMISION Black Expression Center Top, Right, Bottom;Black;1;Dot;False;4;Black Transparent 13.4,1,1.8,0.8 Courier New,6 a920bf2c60274a11866b9e1cec82d925 Center 0,0,0,0 Text2 IGV Black Expression Center Top, Right, Bottom;Black;1;Dot;False;4;Black Transparent 30.2,0,3.2,1 Courier New,6 74a0a1b4a8c84a3a968c05ceeebbbcf1 Center 0,0,0,0 Text18 REFERENCIA DOC. ORIG. QUE SE MODIFICA Black Expression Center Top, Bottom;Black;1;Dot;False;4;Black Transparent 1.2,0,5.4,1 Courier New,6 43031ff06c3b4c90961b295e91bfc418 Center 0,0,0,0 Text23 COMPROBANTE DE PAGO Black Expression Center Left, Bottom;Black;1;Dot;False;4;Black Transparent 3.6,1,0.4,0.8 Courier New,6 8907ddadee3b43109477ace6111ff1f9 Center 0,0,0,0 Text7 TI Black Expression Center Left, Bottom;Black;1;Dot;False;4;Black Transparent 4,1,0.6,0.8 Courier New,6 ab1be60c91464b5aaf9067c75ff14883 Center 0,0,0,0 Text9 SER Black Expression Center Left, Right, Bottom;Black;1;Dot;False;4;Black Transparent 5.4,1,1.2,0.8 Courier New,6 e49bd4b53bab4d5d929ce4467f342c2c Center 0,0,0,0 Text12 NUMERO Black Expression Center Top, Right, Bottom;Black;1;Dot;False;4;Black Transparent 26.2,0,2,1.8 Courier New,6 53e7e6fb88654ba39fb26fdd4925a749 Center 0,0,0,0 Text5 IMPORTE TOTAL Black Expression Center Top, Right, Bottom;Black;1;Dot;False;4;Black Transparent 28.2,0,0.8,1.8 Courier New,6 35ea3ad9966f4c8497021f69a75fe873 Center 0,0,0,0 Text20 TIPO CAMBIO Black Expression Center Bottom;Black;1;Dot;False;4;Black Transparent 31.4,1,0.4,0.8 Courier New,6 b1fdc50dfec74775970722c7880014cb Center 0,0,0,0 Text17 TI Black Expression Center All;Black;1;Dot;False;4;Black Transparent 0,0,1.2,1.8 Courier New,6 2a1fa6db11c941f8afb558ef024a6388 Center 0,0,0,0 Text34 NRO. TRANS. Black Expression Center Left, Right, Bottom;Black;1;Dot;False;4;Black Transparent 32.4,1,1,0.8 Courier New,6 6ca8dc0628de42df80e1128378877f15 Center 0,0,0,0 Text21 NUMERO Black Expression Center Left, Bottom;Black;1;Dot;False;4;Black Transparent 31.8,1,0.6,0.8 Courier New,6 c44a706351b5485a929d9beedfbd8b60 Center 0,0,0,0 Text16 SER Black Expression Center Right, Bottom;Black;1;Dot;False;4;Black Transparent 30.2,1,1.2,0.8 Courier New,6 36f2184ce3c8472e873df10dbd17e650 Center 0,0,0,0 Text36 FECHA Black Expression Center Bottom;Black;1;Dot;False;4;Black Transparent 2.4,1,1.2,0.8 Courier New,6 60d3a7e0a31448128f301de064b9bdfa Center 0,0,0,0 Text38 FECHA VENCIM. Black Expression Center Top, Right;Black;1;Dot;False;4;Black Transparent 6.6,1,2,0.4 Courier New,6 c46b2e9bef8b4cf8a19d9a4da633390c Center 0,0,0,0 Text40 DOC.IDENTIDAD Black Expression Center Top, Right, Bottom;Black;1;Dot;False;4;Black Transparent 18.6,0,1.4,1.8 Courier New,6 1f62f3795b1b4f1797a35c8b45b3a96c Center 0,0,0,0 Text41 VALOR DE LAS ADQUISIC. NO GRAVADAS Black Expression Center Left, Right, Bottom;Black;1;Dot;False;4;Black Transparent 4.6,1,0.8,0.8 Courier New,6 0c66b2eed1df4025ae37dc90dded55fc Center 0,0,0,0 Text46 AÑO DUA Black Expression Center Top, Right, Bottom;Black;1;Dot;False;4;Black Transparent 29,0,1.2,1.8 Courier New,6 2059fc67ba4d4a8ca44a2c80e787d263 Center 0,0,0,0 Text3 NRO.DOC. SUJETO NO DOMICIL. Black Expression Center Top, Right, Bottom;Black;1;Dot;False;4;Black Transparent 15.2,1,1.8,0.8 Courier New,6 f0cb69d276b3457e879200974e7f46c5 Center 0,0,0,0 Text30 BASE IMPONIBLE Black Expression Center Top, Left, Right;Black;1;Dot;False;4;Black Transparent 15.2,0,3.4,1 Courier New,6 f3aa33c931184651907e5870d0754f52 Center 0,0,0,0 Text31 ADQ.GRAVADAS DESTINADAS A OPER.GRAVADAS Y/O DE EXPORT. Y NO GRAVADAS Black Expression Center Top, Right, Bottom;Black;1;Dot;False;4;Black Transparent 17,1,1.6,0.8 Courier New,6 fb0241ce01ce497d88629e821836e539 Center 0,0,0,0 Text44 IGV Black Expression Center Top, Right, Bottom;Black;1;Dot;False;4;Black Transparent 20,0,1.4,1.8 Courier New,6 160fdabbe04642fea18a6a4dcfda24fd Center 0,0,0,0 Text51 OTROS TRIBUTOS Y CARGOS Black Expression Center Top, Right, Bottom;Black;1;Dot;False;4;Black Transparent 21.4,0,1.4,1.8 Courier New,6 8cb0e2496b2b4f50a303d4bef62a9b79 Center 0,0,0,0 Text53 OPERAC. EXONERADAS Black Expression Center Top, Right, Bottom;Black;1;Dot;False;4;Black Transparent 22.8,0,1.4,1.8 Courier New,6 41cb005fe81243b2a9c4b49642afaebd Center 0,0,0,0 Text52 ADQUIS. GRAVADAS SIN DERECHO CREDITO FISCAL Black Expression Center Top, Left, Right;Black;1;Dot;False;4;Black Transparent 24.2,0,2,1 Courier New,6 7bac05fe44784120b8c318debdf5d4fd Center 0,0,0,0 Text60 CONSTANCIA DEPOSITO DETRACCION Black Expression Center Top, Right, Bottom;Black;1;Dot;False;4;Black Transparent 24.2,1,1,0.8 Courier New,6 2581df188b5b4d399e9248e392146baa Center 0,0,0,0 Text61 NUMERO Black Expression Center Top, Right, Bottom;Black;1;Dot;False;4;Black Transparent 25.2,1,1,0.8 Courier New,6 e367f0d04797471b990924abd60b239f Center 0,0,0,0 Text62 FECHA Black Expression Center Encabezado1 Transparent 0,5.6,33.6,0.4 None;Black;1;Dot;False;4;Black Transparent 1.2,0,1.2,0.4 Courier New,6 80b4fad38162453391786b9718571ac8 0,0,0,0 Text6 {DataSource1.ftra} Black dd/MM/yy DataColumn None;Black;1;Dot;False;4;Black Transparent 3.6,0,0.4,0.4 Courier New,6 d0654091b20341ffb5a4503591dbf1e0 Center 0,0,0,0 Text8 {ctype(DataSource1.tdoc, integer).ToString.PadLeft(2, "0")} Black Expression None;Black;1;Dot;False;4;Black Transparent 4,0,0.6,0.4 Courier New,6 6b9614b466c744dca360546c6b6e0efe Center 0,0,0,0 Text10 {DataSource1.nser} Black DataColumn None;Black;1;Dot;False;4;Black Transparent 5.4,0,1.2,0.4 Courier New,6 959946dad97c425c9ee89133a82d13f4 Right 0,0,0,0 Text11 {DataSource1.corr} Black Expression None;Black;1;Dot;False;4;Black Transparent 6.6,0,0.4,0.4 Courier New,6 2476e7203b064b048bcc1804d63e9331 Center 0,0,0,0 Text1 {DataSource1.tdid} Black Expression None;Black;1;Dot;False;4;Black Transparent 7,0,1.6,0.4 Courier New,6 1abc7360778d48cfb5b7331ced089d71 0,0,0,0 Text13 {DataSource1.ndid} Black Expression None;Black;1;Dot;False;4;Black Transparent 8.6,0,2.8,0.4 Courier New,6 2d4d329dab29478db9dfe0d222692f04 0,0,0,0 Text14 {DataSource1.nomb} Black Expression None;Black;1;Dot;False;4;Black Transparent 11.4,0,2,0.4 Courier New,6 961d83bffda1421bb7ea338acef7f048 Right 0,0,0,0 Text15 {DataSource1.impt} Black , 1 Expression None;Black;1;Dot;False;4;Black Transparent 13.4,0,1.8,0.4 Courier New,6 c6f3f2cc2d66480d932ba9d362daf652 Right 0,0,0,0 Text19 {DataSource1.iigv} Black , 1 Expression None;Black;1;Dot;False;4;Black Transparent 26.2,0,2,0.4 Courier New,6 919b8360b60b4d1da266e809c63b2852 Right 0,0,0,0 Text22 {DataSource1.itot} Black , 1 Expression None;Black;1;Dot;False;4;Black Transparent 28.2,0,0.8,0.4 Courier New,6 127e389b39c04cf8987a24c9c7ccca51 Right 0,0,0,0 Text24 {DataSource1.tcam} Black #.## Expression None;Black;1;Dot;False;4;Black Transparent 31.4,0,0.4,0.4 Courier New,6 d892c037d3f74b5eabdd477c0adbc0cc Center 0,0,0,0 Text26 {IIF(IsNull(DataSource1,"tdoo"),"",ctype(DataSource1.tdoo, Integer).ToString.PadLeft(2, "0"))} Black Expression None;Black;1;Dot;False;4;Black Transparent 32.4,0,1,0.4 Courier New,6 d56aa834949d4ba4a9af015d47d0c30d Right 0,0,0,0 Text27 {DataSource1.ndoo} Black DataColumn None;Black;1;Dot;False;4;Black Transparent 31.8,0,0.6,0.4 Courier New,6 210eecfa6b604b2caaadd9457818fd39 Center 0,0,0,0 Text25 {DataSource1.nseo} Black Expression None;Black;1;Dot;False;4;Black Transparent 0,0,1.2,0.4 Courier New,6 7e4a6bd5601e42b5adea53b1617fa64d Right 0,0,0,0 Text35 {DataSource1.ntra} Black Expression None;Black;1;Dot;False;4;Black Transparent 30.2,0,1.2,0.4 Courier New,6 f3304ce95ed14e408299a4f3377d0097 True 0,0,0,0 Text37 {DataSource1.fdor} Black dd/MM/yy DataColumn None;Black;1;Dot;False;4;Black Transparent 2.4,0,1.2,0.4 Courier New,6 021faa17aca046fc8886d7775b616244 0,0,0,0 Text39 {DataSource1.fven} Black dd/MM/yy DataColumn None;Black;1;Dot;False;4;Black Transparent 18.6,0,1.4,0.4 Courier New,6 8d65e36f88ea4af1aa9c526aa639788c Right 0,0,0,0 Text42 {DataSource1.vaag} Black , 1 Expression None;Black;1;Dot;False;4;Black Transparent 4.6,0,0.8,0.4 Courier New,6 2e382837d80e417880a9277fff4a40e4 Center 0,0,0,0 Text47 {DataSource1.adua} Black DataColumn None;Black;1;Dot;False;4;Black Transparent 29,0,1.2,0.4 Courier New,6 8694ccc6b5444444b5b2db68209cba60 Right 0,0,0,0 Text4 {DataSource1.ndnd} Black DataColumn None;Black;1;Dot;False;4;Black Transparent 15.2,0,1.8,0.4 Courier New,6 530b0be946fc4fe98cfb79bf8895b63c Right 0,0,0,0 Text45 Black , 1 Expression None;Black;1;Dot;False;4;Black Transparent 17,0,1.6,0.4 Courier New,6 4fa075bef8594e7ab757d9eaad17178b Right 0,0,0,0 Text48 Black , 1 Expression None;Black;1;Dot;False;4;Black Transparent 20,0,1.4,0.4 Courier New,6 febaebe72d7d4af3a01a20ba36345d82 Right 0,0,0,0 Text54 {DataSource1.otro} Black , 1 Expression None;Black;1;Dot;False;4;Black Transparent 21.4,0,1.4,0.4 Courier New,6 8b622e3a6f8743e5b4a4e91bd5ab2efc Right 0,0,0,0 Text55 {DataSource1.exon} Black , 1 Expression None;Black;1;Dot;False;4;Black Transparent 22.8,0,1.4,0.4 Courier New,6 93f5e5b5c19d43799ba33c56916da6b1 Right 0,0,0,0 Text58 {DataSource1.bole} Black , 1 Expression None;Black;1;Dot;False;4;Black Transparent 25.2,0,1,0.4 Courier New,6 d5974a96513941c783869fbb56aa7b12 True 0,0,0,0 Text64 Black dd/MM/yy Expression None;Black;1;Dot;False;4;Black Transparent 24.2,0,1,0.4 Courier New,6 7bcd17b2b31b470585510e6136970a81 Center 0,0,0,0 Text65 Black Expression DataSource1 Datos1 ASC ftra ASC tdoc ASC nser ASC corr None;Black;1;Dot;False;4;Black Transparent 0,6.8,33.6,0 Pie1 Transparent 0,7.6,33.6,1.2 Top, Left, Bottom;Black;1;Dot;False;4;Black Transparent 0,0.2,11.4,0.6 Courier New,6,Bold 29b6275231264ccb869a7c5a85f59bf3 0,0,0,0 Texto29 TOTAL GENERAL Black Expression Center Top, Bottom;Black;1;Dot;False;4;Black Transparent 11.4,0.2,2,0.6 Courier New,6,Bold Right 0,0,0,0 Text28 {Sum(Datos1,DataSource1.impt)} Black , 1 Totals Center Top, Bottom;Black;1;Dot;False;4;Black Transparent 13.4,0.2,1.8,0.6 Courier New,6,Bold b7e4ee03a6be411fb1b1cf839e65a59e Right 0,0,0,0 Text29 {Sum(Datos1,DataSource1.iigv)} Black , 1 Totals Center Top, Bottom;Black;1;Dot;False;4;Black Transparent 26.2,0.2,2,0.6 Courier New,6,Bold fbf78c738a6644a480c3827999b91301 Right 0,0,0,0 Text32 {Sum(Datos1,DataSource1.itot)} Black , 1 Totals Center Top, Right, Bottom;Black;1;Dot;False;4;Black Transparent 28.2,0.2,5.2,0.6 Courier New,6 0,0,0,0 Text33 Black Top, Bottom;Black;1;Dot;False;4;Black Transparent 18.6,0.2,1.4,0.6 Courier New,6,Bold f8751a628c374a5db7058cd62bafa204 Right 0,0,0,0 Text43 {Sum(Datos1,DataSource1.vaag)} Black , 1 Totals Center Top, Bottom;Black;1;Dot;False;4;Black Transparent 15.2,0.2,1.8,0.6 Courier New,6,Bold 07f098b1b3ae4f4f815a9457f6233788 Right 0,0,0,0 Text49 Black , 1 Expression Center Top, Bottom;Black;1;Dot;False;4;Black Transparent 17,0.2,1.6,0.6 Courier New,6,Bold f8de1da4e535434abd69c0a354c54b15 Right 0,0,0,0 Text50 Black , 1 Expression Center Top, Bottom;Black;1;Dot;False;4;Black Transparent 20,0.2,1.4,0.6 Courier New,6,Bold 1ca368577e1d49fd87fb3aab35750d31 Right 0,0,0,0 Text56 {Sum(Datos1,DataSource1.otro)} Black , 1 Totals Center Top, Bottom;Black;1;Dot;False;4;Black Transparent 21.4,0.2,1.4,0.6 Courier New,6,Bold f69a0afaffee42a3b24b6d246d4f130c Right 0,0,0,0 Text57 {Sum(Datos1,DataSource1.exon)} Black , 1 Totals Center Top, Bottom;Black;1;Dot;False;4;Black Transparent 22.8,0.2,1.4,0.6 Courier New,6,Bold ba80cd6697574f06bab3f78bf5c7a101 Right 0,0,0,0 Text59 {Sum(Datos1,DataSource1.bole)} Black , 1 Totals Center Top, Bottom;Black;1;Dot;False;4;Black Transparent 24.2,0.2,2,0.6 Courier New,6,Bold 550ad2060fb54d399152bf15b58697d4 Right 0,0,0,0 Text63 Black Expression Center ReportSummary1 2382ccb470be4983b3a1b78a68a17b16 1,1,1,1 Página1 Landscape 21.6 35.6 Legal numeroPagina + =1 Arial,100 [50:0:0:0] Control Control 32,40,80,24 Microsoft Sans Serif,8 Black 32, 40 Etiqueta2 80, 24 Desde MiddleRight Window 120,40,104,20 Microsoft Sans Serif,8 Black Short 120, 40 12/31/9998 12:00:00 AM 1/1/1753 12:00:00 AM DateTimePicker1 104, 20 4/21/2008 12:00:00 AM Control 248,40,48,24 Microsoft Sans Serif,8 Black 530d9ae4793a49ddaf650b0ae364aa04 248, 40 Etiqueta3 48, 24 Hasta MiddleRight Window 304,40,104,20 Microsoft Sans Serif,8 Black Short 9483dae106f34ff69a6c0efd7ef17bff 304, 40 12/31/9998 12:00:00 AM 1/1/1753 12:00:00 AM DateTimePicker2 104, 20 4/21/2008 12:00:00 AM periodo = config.ObtenerPeriodo(DateTimePicker2.Value) cadenaSQL= " ERROR!!!! EXECUTE PROCEDURE NET_REG_COMPRAS_T('" & DateTimePicker1.Value.ToShortDateString & "', '" & DateTimePicker2.Value.ToShortDateString & "') " 208,104,96,24 True OK Microsoft Sans Serif,8 Black 208, 104 Botón1 96, 24 &Aceptar True 312,104,96,24 Cancel Microsoft Sans Serif,8 Black 07a43191903147d2a34111b3d13268af 312, 104 Botón2 96, 24 &Cancelar Microsoft Sans Serif,8 edae366db53c4893b642c99cb58c39cf Me.DateTimePicker1.Value = date.today Me.DateTimePicker2.Value = date.today 0, 0 Formulario1 448, 192 Registro de Compras 25104767 System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Controls.Dll Stimulsoft.Base.Dll Stimulsoft.Report.Dll LogicaNegocio.dll Informe 2/27/2009 3:14:02 PM 4/18/2008 3:36:30 PM 0958aa74819843a1bad3aee792a935d5 Informe Centimeters 2009.1.344 VB