4735be5c-857c-44d4-81e6-79807646569e SQL Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Data\ds_shop.mdf;Integrated Security=True;User Instance=True;Context Connection=False 22.94cm Factura String true true Report_Parameter_1 String true true Report_Parameter_2 String true true Report_Parameter_4 String true true Report_Parameter_5 String true true Report_Parameter_3 String true true Report_Parameter_5 String true true Report_Parameter_6 String true true Report_Parameter_7 String true true Report_Parameter_8 String true true Report_Parameter_9 String true true Report_Parameter_10 String true true Report_Parameter_11 String true true Report_Parameter_12 String true true Report_Parameter_13 String true true Report_Parameter_14 String true true Report_Parameter_15 String true true Report_Parameter_16 String true true Report_Parameter_17 String true true Report_Parameter_18 String true Report_Parameter_19 String true Report_Parameter_20 String true Report_Parameter_21 String true true Report_Parameter_22 String true true Report_Parameter_23 String true true Report_Parameter_24 String true true Report_Parameter_25 String true true Report_Remark2 String true true Report_Remark3 String true true Report_Parameter_26 Integer true =2 true FormatNumber_SaleDiamelBits String true =0 true DiamelBits Boolean true Report_Parameter_29 String true true Report_Parameter_30 String true true Report_Parameter_31 false 19cm 0.1cm true true 5.2cm 3.05cm 9 15.7cm 0.5cm ="Repre.: " & Parameters!Vendedor.Value 0.17203cm 8 7 17.7cm IVA =GetChar(Parameters!Albformat.Value,6)="0" 2.8cm 6 2.79cm =iif(GetChar(Parameters!Albformat.Value,6)="0","","COD.BARRA") 1.68678cm 5 16.01322cm IMPORTE 1.37354cm 4 13.55291cm PRE/U 1.45291cm 3 12.1cm CANTID 1.08677cm 2 14.92645cm DTO% 2.79cm 1 REFERENCIA 9.31cm 2.79cm =iif(GetChar(Parameters!Albformat.Value,6)="0"," ARTICULO"," ARTICULO " + iif(GetChar(Parameters!Albformat.Value,7)="0","","BUTOS")) 6.5cm 18.70676cm 9.745cm 7 2.71798cm 6.09669cm 6 2.65165cm 0.5cm =Parameters!CustomerTlf.Value true 2.21798cm 2.25cm 5 true 0.25165cm 0.5cm C.I.F / N.I.F....: 0.3cm 8.49669cm 4 0.25165cm 0.5cm =Parameters!CustomerCompanyName.Value 2.15899cm 6.09669cm 3 2.65165cm 0.84101cm =Parameters!CTaxNo.Value true 2.71798cm 2.25cm 2 true 0.25165cm 0.5cm TEL.CLIE...: 1.7cm 8.49669cm 1 0.25165cm 0.51798cm =Parameters!CustomerCitys.Value 0.8cm 8.49669cm 0.25165cm 0.9cm =Parameters!CustomerAdress.Value 1.2cm 8.955cm 3.4cm 0.155cm 6 Fit =(Convert.ToInt32(Mid(Parameters!Albformat.Value,19,1))=0) 0.3cm 1.9cm image/jpeg External 5 0.1cm 1cm ="file:///" & "c:\logo.jpg" =GetChar(Parameters!Albformat.Value,1)<>"0" 3.24709cm 8.87049cm 4 true 0.11475cm 0.5cm =Parameters!Tlf.Value & " " & Parameters!fax.Value =GetChar(Parameters!Albformat.Value,1)<>"0" 2.32331cm 8.87049cm 3 true 0.11475cm 0.92378cm =Parameters!Adress.Value & " " & Parameters!Postcode.Value =GetChar(Parameters!Albformat.Value,1)<>"0" 1.33047cm 8.87049cm 2 true 0.11475cm 0.5cm =Parameters!Name2.Value =GetChar(Parameters!Albformat.Value,1)<>"0" 0.3cm 6.88524cm 1 true 2.1cm 1cm =Parameters!Name1.Value =GetChar(Parameters!Albformat.Value,1)<>"0" 1.83047cm 8.87049cm true 0.11475cm 0.49284cm =Parameters!Tax_NO.Value 0.6cm 9.1cm 4.1cm 5.2cm 4.4cm 5 4.6cm 0.5cm ="FECHA: " & Split(Parameters!Fecha.Value, " ")(0) 5cm 18.59cm 4 0.155cm 0cm 5.2cm 4.3cm 3 true 0.1cm 0.5cm ="Nº FAC: " & Parameters!FacturaID.Value 5.2cm 2.1cm 2 13.3cm 0.5cm ="PAG: " & Globals!PageNumber & "/" & Globals!TotalPages 0.2cm 3.4cm 1 true 14.745cm 0.73492cm = IIf((len(Parameters!FacturaID.Value)>0 andalso Parameters!FacturaID.Value<>"0"),"Factura","FACTURA PROFORMA") true 5.2cm 3.8cm true 9.2cm 0.5cm ="COD.CLIE:" & Parameters!ClientID.Value 7cm true 8ce50dc1-e320-4811-8991-f8bd4265b399 21cm OrderID System.Int32 OrderDate System.DateTime RequiredDate System.DateTime CustomerID System.Int32 EmployeeID System.Int32 FacturaID System.Int32 FacturaID2 System.Int32 FacturaID3 System.Int32 AlbaranID System.Int32 Remark System.String ShipAddress System.String SubTotal System.Decimal Receivd System.Decimal Status System.String ECTotal System.Decimal fjson System.String TaxType System.Int32 TaxInclude System.Boolean AttachTax System.Decimal OrderType System.Int32 SalesMan System.String ShipPostalCode System.String ShipName System.String ShipVia System.Int32 ValueAddTax System.Decimal PayMode System.String Cash System.Decimal VISA System.Decimal Bank System.Decimal PayOthers System.Decimal Vouchers System.Decimal VouchersID System.String Profits System.Decimal PriceBase System.Decimal PriceIncTax System.Decimal TaxC System.Decimal Discount System.Single DiscountII System.Double ETotal System.Decimal ED System.Int32 EDGProfits System.Decimal EDInc System.Boolean ReserveID System.Int32 Final System.String UUID System.String sn System.String FreePosUserName System.String FreePosRemark System.String PostalCode System.String MiniOrderId System.Int32 ds_shopConnectionString SELECT OrderID, OrderDate, RequiredDate, CustomerID, EmployeeID, FacturaID, FacturaID2, FacturaID3, AlbaranID, Remark, ShipAddress, SubTotal, Receivd, Status, ECTotal, fjson, TaxType, TaxInclude, AttachTax, OrderType, SalesMan, ShipPostalCode, ShipName, DiscountValue, ShipVia, ValueAddTax, PayMode, Cash, VISA, Bank, PayOthers, Vouchers, VouchersID, Profits, PriceBase, PriceIncTax, TaxC, Discount, DiscountII, ETotal, ED, EDGProfits, EDInc, ReserveID, Final, UUID, sn, FreePosUserName, FreePosRemark, PostalCode, MiniOrderId FROM Orders WHERE (OrderID = 1) ds_shopDataSet DataTableA4 DataTableA4TableAdapter Fill GetData OrderID System.Int32 Total System.Decimal DiscountValue System.Decimal DiscountI System.Decimal DiscountII System.Decimal DiscountValueFinal System.Decimal SubTotalFinal System.Decimal ds_shopConnectionString SELECT OrderID, Total, DiscountValue, DiscountI, DiscountII, DiscountValueFinal, SubTotalFinal FROM OrderDiscount where OrderID=1 ds_shopDataSet DataTableA4 DataTableA4TableAdapter Fill GetData CustomerID System.Int32 CompanyName System.String ContactName System.String Phone System.String Address System.String City System.String Region System.String PostalCode System.String Country System.String TaxNumber System.String TaxNumber2 System.String TaxNumberAtt System.String TaxType System.Int32 Discount System.Int32 Address2 System.String Address3 System.String Address4 System.String AddressNumber System.String AttachTax System.Boolean email System.String email2 System.String emailAtt System.String EmployeeID System.Int32 Fax System.String field1 System.String field2 System.String field3 System.String fjson System.String hide System.Boolean HomePage System.String ConsumerOnOrder System.Decimal ConsumerOnPurchase System.Decimal LastPurchaseDate System.DateTime Order System.Boolean PayDays System.Int32 Prepaid System.Decimal PriceType System.Int32 Remark System.String Birthday System.DateTime UseBirthdayGift System.DateTime VipExpDate System.DateTime VIPID System.String app System.Boolean username System.String pw System.String UUID System.String SellerID System.Int32 CompanyNameII System.String PhoneII System.String AddressII System.String AddressNumberII System.String AddressFloorRoomII System.String CityII System.String RegionII System.String CountryII System.String PostalCodeII System.String TaxNumberII System.String PaymentType System.String PayDate System.DateTime ds_shopConnectionString SELECT CustomerID , CompanyName, ContactName, Phone, Address, City, Region, PostalCode, Country, TaxNumber, TaxNumber2, TaxNumberAtt, TaxType, Discount, Address2, Address3, Address4, AddressNumber, AttachTax, email, email2, emailAtt, EmployeeID, Fax, field1, field2, field3, fjson, hide, HomePage, ConsumerOnOrder, ConsumerOnPurchase, LastPurchaseDate, [Order], PayDays, Prepaid, PriceType, Remark, Birthday, UseBirthdayGift, VipExpDate, VIPID, app, username, pw, UUID, SellerID, CompanyNameII, PhoneII, AddressII, AddressNumberII, AddressFloorRoomII, CityII, RegionII, CountryII, PostalCodeII, TaxNumberII FROM Customers where CustomerID=1 ds_shopDataSet DataTableA4 DataTableA4TableAdapter Fill GetData OrderID System.Int32 CustomerID System.Int32 AlbaranID System.Int32 FacturaID System.Int32 RequiredDate System.DateTime Remark System.String Employe System.String SubTotal System.Decimal PayMode System.String Cash System.Decimal VISA System.Decimal PayOthers System.Decimal UserCode System.String BarCode System.String ProductName System.String UnitPrice System.Decimal TaxNumber System.String CompanyName System.String Quantity System.Int32 Discount System.Int32 SubtotalA System.Decimal Bultos System.Int32 QuantityPerUnit System.Int32 Tax System.Single QuantityPerUnit2nd System.Int32 Bultos2nd System.Int32 ds_shopConnectionString SELECT OrderID, CustomerID, AlbaranID, FacturaID, RequiredDate, Remark, Employe, SubTotal, PayMode, Cash, VISA, PayOthers, UserCode, BarCode, ProductName, UnitPrice, Discount, TaxNumber, SubtotalA, CompanyName, Bultos, QuantityPerUnit, Quantity, Tax, QuantityPerUnit2nd, Bultos2nd FROM DataTableA4 true ds_shopDataSet DataTableA4 DataTableA4TableAdapter Fill GetData ProductID System.Int32 Remark System.String Remark System.String UnitPrice System.Decimal PriceEx System.Int32 UserCode System.String BarCode System.String ProductName System.String ProductName2 System.String QuantityTotal System.Decimal Discount System.Double DiscountO System.Double DiscountI System.Double DiscountII System.Double QuantityPerUnit2nd System.Int32 QuantityPerUnit System.Int32 Tax System.Single PriceBase System.Decimal PriceBasePrint System.Decimal PriceIncTax System.Decimal TaxC System.Decimal ds_shopConnectionString SELECT ProductID, UnitPrice, 0 as PriceEx, UserCode, BarCode, ProductName , ProductName2 , SUM (Quantity) as QuantityTotal , Discount ,DiscountO ,DiscountI ,DiscountII, QuantityPerUnit2nd , QuantityPerUnit , Tax , SUM (PriceBase) as PriceBase, SUM (PriceBasePrint) as PriceBasePrint , SUM (PriceIncTax) as PriceIncTax, SUM (TaxC) as TaxC FROM [Order Details] WHERE (OrderID = 1) GROUP BY ProductID, UserCode, BarCode, ProductName, ProductName2, UnitPrice, Discount,DiscountO ,DiscountI ,DiscountII, QuantityPerUnit2nd, QuantityPerUnit, Tax ds_shopDataSet Order Details Ticket Order_Details_TicketTableAdapter Fill GetData Densen 19cm 1cm 3 0.14243cm ds_shopDataSet_Order_Details_Ticket =GetChar(Parameters!Albformat.Value,6)="1" 9 17.7cm =iif(Mid(Parameters!Albformat.Value,20,1)="0",Fields!Tax.Value *100 & "%","0") =iif(Mid(Parameters!Albformat.Value,8,2)="00",True,(int(RowNumber(Nothing)/Mid(Parameters!Albformat.Value,8,2))<>RowNumber(Nothing)/Mid(Parameters!Albformat.Value,8,2))) 0.6cm 8 =GetChar(Parameters!Albformat.Value,7)="0" 1.16354cm 7 10.93646cm = IIF( Fields!QuantityPerUnit2nd.Value = 1, FormatNumber(Fields!QuantityTotal.Value/Fields!QuantityPerUnit.Value,0) & iif(GetChar(Parameters!Albformat.Value,21)="0", "x" & FormatNumber(Fields!QuantityPerUnit.Value,0),"") , FormatNumber(Fields!QuantityTotal.Value/Fields!QuantityPerUnit2nd.Value,0) & iif(GetChar(Parameters!Albformat.Value,21)="0", "x" & FormatNumber(Fields!QuantityPerUnit2nd.Value,0) & "(" & FormatNumber(Fields!QuantityTotal.Value/Fields!QuantityPerUnit.Value,0) & "x" & FormatNumber(Fields!QuantityPerUnit.Value,0) & ")","")) =Mid(Parameters!Albformat.Value,16,1)="0" 0.5cm 6 =RowNumber(nothing) 1.37354cm 5 13.55291cm =FormatNumber(iif(Convert.ToInt32(Mid(Parameters!Albformat.Value,18,1))=1,Fields!PriceIncTax.Value/Fields!QuantityTotal.Value ,Fields!PriceBase.Value/Fields!QuantityTotal.Value)/((100-Fields!Discount.Value)/100),Convert.ToInt32(Mid(Parameters!Albformat.Value,13,1))) 1.08677cm 4 14.92645cm =Fields!Discount.Value 9.31cm 3 true 2.79cm = Fields!ProductName.Value.ToString.Trim((Chr(13) & chr(10)).ToCharArray()) 1.45291cm 2 12.1cm =FormatNumber(Fields!QuantityTotal.Value,Convert.ToInt32(Mid(Parameters!Albformat.Value,12,1))) 2.79cm 1 true =iif(Mid(Parameters!Albformat.Value,16,1)="0","", " ") & Fields!UserCode.Value.ToString.Trim((Chr(13) & chr(10)).ToCharArray()) 1.68678cm 16.01322cm =FormatNumber(iif(Convert.ToInt32(Mid(Parameters!Albformat.Value,18,1))=1,Fields!PriceIncTax.Value ,Fields!PriceBase.Value),Convert.ToInt32(Mid(Parameters!Albformat.Value,13,1))) 18.70676cm 0.6cm 1.5cm 2.85cm 2 true 7.7cm 0.4cm =iif(GetChar(Parameters!Albformat.Value,7)<>"0", "TOTAL BULTOS:","TOTAL CANTIDAD:") 1.5cm 1.45cm 1 true 10.8cm 0.4cm =iif(GetChar(Parameters!Albformat.Value,7)<>"0", FormatNumber(Sum(Fields!Bultos.Value, "ds_shopDataSet_DataTableA4"),0),FormatNumber(Sum(Fields!QuantityTotal.Value, "ds_shopDataSet_Order_Details_Ticket"),0)) 0.14243cm ds_shopDataSet_Order_Details_Ticket =GetChar(Parameters!Albformat.Value,6)="0" 10 17.7cm =iif(Mid(Parameters!Albformat.Value,20,1)="0",Fields!Tax.Value *100 & "%","0") =iif(Mid(Parameters!Albformat.Value,8,2)="00",True,(int(RowNumber(Nothing)/Mid(Parameters!Albformat.Value,8,2))<>RowNumber(Nothing)/Mid(Parameters!Albformat.Value,8,2))) 0.6cm 9 =GetChar(Parameters!Albformat.Value,7)="0" 1.16354cm 8 10.93646cm = IIF( Fields!QuantityPerUnit2nd.Value = 1, FormatNumber(Fields!QuantityTotal.Value/Fields!QuantityPerUnit.Value,0) & iif(GetChar(Parameters!Albformat.Value,21)="0", "x" & FormatNumber(Fields!QuantityPerUnit.Value,0),"") , FormatNumber(Fields!QuantityTotal.Value/Fields!QuantityPerUnit2nd.Value,0) & iif(GetChar(Parameters!Albformat.Value,21)="0", "x" & FormatNumber(Fields!QuantityPerUnit2nd.Value,0) & "(" & FormatNumber(Fields!QuantityTotal.Value/Fields!QuantityPerUnit.Value,0) & "x" & FormatNumber(Fields!QuantityPerUnit.Value,0) & ")","")) =Mid(Parameters!Albformat.Value,16,1)="0" 0.5cm 7 =RowNumber(nothing) 2.8cm 6 true 2.79cm =iif(GetChar(Parameters!Albformat.Value,6)="0","", Fields!BarCode.Value.ToString.Trim((Chr(13) & chr(10)).ToCharArray())) 1.37354cm 5 13.55291cm =FormatNumber(iif(Convert.ToInt32(Mid(Parameters!Albformat.Value,18,1))=1,Fields!PriceIncTax.Value/Fields!QuantityTotal.Value ,Fields!PriceBase.Value/Fields!QuantityTotal.Value)/((100-Fields!Discount.Value)/100),Convert.ToInt32(Mid(Parameters!Albformat.Value,13,1))) Discount 1.08677cm 4 14.92645cm =Fields!Discount.Value ProductName 6.51cm 3 true 5.59cm = Fields!ProductName.Value.ToString.Trim((Chr(13) & chr(10)).ToCharArray()) Quantity 1.45291cm 2 12.1cm =FormatNumber(Fields!QuantityTotal.Value,Convert.ToInt32(Mid(Parameters!Albformat.Value,12,1))) UserCode 2.79cm 1 true =iif(Mid(Parameters!Albformat.Value,16,1)="0","", " ") & Fields!UserCode.Value.ToString.Trim((Chr(13) & chr(10)).ToCharArray()) UnitPrice 1.68678cm 16.01322cm =FormatNumber(iif(Convert.ToInt32(Mid(Parameters!Albformat.Value,18,1))=1,Fields!PriceIncTax.Value ,Fields!PriceBase.Value),Convert.ToInt32(Mid(Parameters!Albformat.Value,13,1))) 0.6cm 18.70676cm 0.6cm 2.1cm ElementNormal =User!Language textbox36 0.2cm 1.6cm 13 true 0.2cm 0.2cm =Parameters!TaxType.Value Output 56.2pt 18.2cm 12 true 10.0pt 1.6cm =iif(Mid(Parameters!Albformat.Value,17,1)="1","","Nota: " & Parameters!Remark.Value) 0.87354cm 1.80283cm 11 true 2.69717cm 0.52063cm =iif(Parameters!DtoTotal.Value>0,iif(Convert.ToInt32(Parameters!FormatNumber_SaleDiamelBits.Value)>0,FormatNumber(Parameters!DtoTotal.Value,Convert.ToInt32(Parameters!FormatNumber_SaleDiamelBits.Value)),FormatNumber(Parameters!DtoTotal.Value,2)),"") 0.2cm 1.8cm 10 true 2.7cm 0.52063cm Dto. 0.87937cm 6.7cm 9 true 8.1cm 1.12063cm =iif(Mid(Parameters!Albformat.Value,20,1)="0",Parameters!TaxTotal.Value,"0") 0.2cm 3.1cm 8 true 4.7cm 0.52063cm BASE IVA 0.2cm 2.3cm 7 true 8cm 0.52063cm IMPORTA IVA 0.2cm 2.7cm 6 true 12.1cm 0.52063cm =iif(Mid(Parameters!Albformat.Value,20,1)="0","IMPORTA Req","") 0.2cm 1.1cm 5 true 10.6cm 0.52063cm =iif(Mid(Parameters!Albformat.Value,20,1)="0","% Req","") 0.87937cm 3cm 4 true 4.8cm 1.1cm =iif(Mid(Parameters!Albformat.Value,20,1)="0",Parameters!BaseTotal.Value,"0% " & FormatNumber(Parameters!Total.Value*(1-Parameters!Dto.Value/100),Convert.ToInt32(Mid(Parameters!Albformat.Value,15,1)))) 0.87937cm 3.2cm 3 true 15.35cm 0.52063cm =FormatNumber(Parameters!Total.Value*(1-Parameters!Dto.Value/100),Convert.ToInt32(Mid(Parameters!Albformat.Value,15,1))) 0.2cm 3.2cm 2 true 15.35cm 0.52063cm TOTAL: 0.05291cm 18.5cm 1 0.3cm 0cm 101.0pt 123.63pt 10.6pt 11.69pt ="*" & iif(len(Parameters!FacturaID.Value)<3,"00" & Parameters!FacturaID.Value,Parameters!FacturaID.Value) & "*" 4cm true 27.94cm 1cm