c97de888-ff28-4e1f-96d8-11b440d3d938 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 Integer =2 true FormatNumber_SaleDiamelBits Integer =0 true DiamelBits String =999999999999 true LINE String ="1010000000" true Report_Parameter_26 false 19cm 0.1cm true true 4.2cm 3.05cm 10 15.6cm 0.5cm ="Repre.: " & Parameters!Vendedor.Value 4.2cm 4.3cm 9 4.65cm 0.5cm ="FECHA: " & Replace(Parameters!Fecha.Value,"0:00","") 4.2cm 2.1cm 8 13.25cm 0.5cm ="PAG: " & Globals!PageNumber & "/" & Globals!TotalPages true 4.2cm 3.8cm 7 true 9.2cm 0.5cm ="COD.CLIE:" & Parameters!ClientID.Value 0.09662cm 6 = GetChar(Parameters!Albformat.Value,18)="1" =GetChar(Parameters!Albformat.Value,6)="0" 2.8cm 6 2.79cm =iif(GetChar(Parameters!Albformat.Value,6)="0","","COD.BARRA") 5 16.37676cm IMPORTE 1.37354cm 4 13.91645cm PRE/U 1.45291cm 3 12.46354cm CANTID 1.08677cm 2 15.28999cm DTO% 2.79cm 1 REFERENCIA 9.67354cm 2.79cm =iif(GetChar(Parameters!Albformat.Value,6)="0"," ARTICULO"," ARTICULO BUTOS") 5.9cm 18.70676cm 0.09662cm 5 = GetChar(Parameters!Albformat.Value,18)="0" 1.18678cm 7 15.21322cm PRE/U =GetChar(Parameters!Albformat.Value,6)="0" 2.8cm 6 2.79cm =iif(GetChar(Parameters!Albformat.Value,6)="0","","COD.BARRA") 2.33cm 5 16.38676cm IMPORTE 1.37354cm 4 12.75291cm PRE/U 1.45291cm 3 11.3cm CANTID 1.08677cm 2 14.12645cm DTO% 2.79cm 1 REF.CAJAS 8.51cm 2.79cm =iif(GetChar(Parameters!Albformat.Value,6)="0"," ARTICULO","ARTICULO") 5.9cm 18.74322cm 9.7cm 4 0.73968cm 8.49669cm 6 0.25165cm 0.5cm =Parameters!CustomerCompanyName.Value 2.03968cm 6.19669cm 5 2.55165cm 0.5cm =Parameters!CustomerTlf.Value 0.26031cm 6.09669cm 4 2.65165cm 0.55899cm =Parameters!ClientID.Value true 2.03968cm 2.25cm 3 true 0.25165cm 0.5cm TEL.CLIE...: true 0.26031cm 2.25cm 2 true 0.25165cm 0.5cm COD.CLIE...: 1.53968cm 8.49669cm 1 0.25165cm 0.51798cm =Parameters!CustomerCitys.Value 1.13969cm 8.49669cm 0.25165cm 0.55899cm =Parameters!CustomerAdress.Value 0.8cm 9cm 2.8cm 0.11cm 3 =GetChar(Parameters!Albformat.Value,1)="0" 2.7cm 8.87049cm 3 true 0.11475cm 0.5cm =Parameters!Tlf.Value & " " & Parameters!fax.Value =GetChar(Parameters!Albformat.Value,1)="0" 1.65558cm 8.87049cm 2 true 0.11475cm 1.04442cm =Parameters!Adress.Value & " " & Parameters!Postcode.Value =GetChar(Parameters!Albformat.Value,1)="0" 1.15558cm 8.87049cm 1 true 0.11475cm 0.5cm =Parameters!Name2.Value =GetChar(Parameters!Albformat.Value,1)="0" 0.2cm 8.87049cm true 0.11475cm 0.95558cm =Parameters!Name1.Value 0.2cm 9.1cm 3.4cm 4cm 18.59cm 2 0.11cm 0cm 4.2cm 4.23709cm 1 0.16291cm 0.5cm =iif((Parameters!AlbaranID.Value=Nothing or Parameters!AlbaranID.Value=0),"Nº PEDIDO : " & Parameters!PedidoID.Value,"Nº ALBARAN : " & Parameters!AlbaranID.Value) 3.8cm true 14.7cm 0.73492cm = IIf((Parameters!AlbaranID.Value=Nothing or Parameters!AlbaranID.Value=0),"Pedido","Albaran") 6.4cm true 8ce50dc1-e320-4811-8991-f8bd4265b399 21cm 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 UnitPrice System.Decimal UserCode System.String ProductName System.String QuantityPerUnit2nd System.Int32 QuantityPerUnit System.Int32 Discount System.Int32 QuantityTotal System.Decimal Tax System.Single BarCode System.String ds_shopConnectionString SELECT TOP (100) PERCENT ProductID, SUM(Quantity) AS QuantityTotal, UnitPrice, UserCode, BarCode, ProductName, QuantityPerUnit2nd, QuantityPerUnit, Discount, Tax FROM [Order Details] WHERE (OrderID = @OrderID) GROUP BY ProductID, UnitPrice, UserCode, BarCode, ProductName, Discount, QuantityPerUnit2nd, QuantityPerUnit, Tax ORDER BY UserCode true ds_shopDataSet Order Details Ticket Order_Details_TicketTableAdapter Fill GetData Densen


  18.9cm
  
    1cm
    
      
        4
        0.09662cm
        ds_shopDataSet_Order_Details_Ticket
        
          =not(GetChar(Parameters!Albformat.Value,18)="1" and GetChar(Parameters!Albformat.Value,6)="1")
        
        
          
            
              =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
            
            10
          
          
            
              =GetChar(Parameters!Albformat.Value,7)="0"
            
            2.3cm
            
            9
            9cm
            = IIF( Fields!QuantityPerUnit2nd.Value = 1, FormatNumber(Fields!QuantityTotal.Value/Fields!QuantityPerUnit.Value,0) & "x" & FormatNumber(Fields!QuantityPerUnit.Value,0) ,FormatNumber(Fields!QuantityTotal.Value/Fields!QuantityPerUnit2nd.Value,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
            
            8
            =RowNumber(nothing)
          
          
            2.8cm
            
            7
            true
            2.79cm
            =iif(GetChar(Parameters!Albformat.Value,6)="0","", Fields!BarCode.Value.ToString.Trim((Chr(13) & chr(10)).ToCharArray()))
          
          
            1.37354cm
            
            6
            12.75291cm
            =FormatNumber(Fields!UnitPrice.Value,cint(Mid(Parameters!Albformat.Value,13,1)))
          
          
            1.08677cm
            
            5
            14.12645cm
            =Fields!Discount.Value
          
          
            5.71cm
            
            4
            true
            5.59cm
            = Fields!ProductName.Value.ToString.Trim((Chr(13) & chr(10)).ToCharArray())
          
          
            1.45291cm
            
            3
            11.3cm
            =FormatNumber(Fields!QuantityTotal.Value,cint(Mid(Parameters!Albformat.Value,12,1)))
          
          
            2.79cm
            
            2
            true
            =iif(Mid(Parameters!Albformat.Value,16,1)="0","", "      ") & Fields!UserCode.Value.ToString.Trim((Chr(13) & chr(10)).ToCharArray())
          
          
            
            1
            16.37676cm
            =FormatNumber(Fields!UnitPrice.Value*Fields!QuantityTotal.Value*(100-Fields!Discount.Value)/100,cint(Mid(Parameters!Albformat.Value,14,1)))
          
          
            1.16cm
            
            15.21322cm
            =FormatNumber(Fields!UnitPrice.Value*(100-Fields!Discount.Value)/100,cint(Mid(Parameters!Albformat.Value,13,1)))
          
        
        1.2cm
        18.70676cm
        
        0.6cm
      
      
        3
        0.09662cm
        ds_shopDataSet_Order_Details_Ticket
        
          =GetChar(Parameters!Albformat.Value,6)="1"
        
        
          
            
              =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"
            
            2.76354cm
            
            7
            true
            9.7cm
            = IIF( Fields!QuantityPerUnit2nd.Value = 1, FormatNumber(Fields!QuantityTotal.Value/Fields!QuantityPerUnit.Value,0) & "x" & FormatNumber(Fields!QuantityPerUnit.Value,0) ,FormatNumber(Fields!QuantityTotal.Value/Fields!QuantityPerUnit2nd.Value,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.91645cm
            =FormatNumber(Fields!UnitPrice.Value,cint(Mid(Parameters!Albformat.Value,13,1)))
          
          
            1.08677cm
            
            4
            15.28999cm
            =Fields!Discount.Value
          
          
            9.67354cm
            
            3
            true
            2.79cm
            = Fields!ProductName.Value.ToString.Trim((Chr(13) & chr(10)).ToCharArray())
          
          
            1.45291cm
            
            2
            12.46354cm
            =FormatNumber(Fields!QuantityTotal.Value,cint(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())
          
          
            
            16.37676cm
            =FormatNumber(Fields!UnitPrice.Value*Fields!QuantityTotal.Value*(100-Fields!Discount.Value)/100,cint(Mid(Parameters!Albformat.Value,14,1)))
          
        
        18.70676cm
        
        0.6cm
      
      
        2.3cm
        2.85cm
        
        2
        true
        8.1cm
        0.4cm
        =iif(GetChar(Parameters!Albformat.Value,7)<>"0", "TOTAL BULTOS:","TOTAL CANTIDAD:")
      
      
        2.3cm
        1.45cm
        
        1
        true
        11.5cm
        0.4cm
        =iif(GetChar(Parameters!Albformat.Value,7)<>"0", FormatNumber(Sum(Fields!Bultos2nd.Value, "ds_shopDataSet_DataTableA4"),0),FormatNumber(Sum(Fields!QuantityTotal.Value, "ds_shopDataSet_Order_Details_Ticket"),0))
      
      
        0.09662cm
        ds_shopDataSet_Order_Details_Ticket
        
          =GetChar(Parameters!Albformat.Value,6)="0" or (GetChar(Parameters!Albformat.Value,18)="1" and GetChar(Parameters!Albformat.Value,6)="1")
        
        
          
            
              =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.36354cm
            
            8
            11.1cm
            = IIF( Fields!QuantityPerUnit2nd.Value = 1, FormatNumber(Fields!QuantityTotal.Value/Fields!QuantityPerUnit.Value,0) & "x" & FormatNumber(Fields!QuantityPerUnit.Value,0) ,FormatNumber(Fields!QuantityTotal.Value/Fields!QuantityPerUnit2nd.Value,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.91645cm
            =FormatNumber(Fields!UnitPrice.Value,cint(Mid(Parameters!Albformat.Value,13,1)))
          
          
            Discount
            1.08677cm
            
            4
            15.28999cm
            =Fields!Discount.Value
          
          
            ProductName
            6.87354cm
            
            3
            true
            5.59cm
            = Fields!ProductName.Value.ToString.Trim((Chr(13) & chr(10)).ToCharArray())
          
          
            Quantity
            1.45291cm
            
            2
            12.46354cm
            =FormatNumber(Fields!QuantityTotal.Value,cint(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
            
            16.37676cm
            =FormatNumber(Fields!UnitPrice.Value*Fields!QuantityTotal.Value*(100-Fields!Discount.Value)/100,cint(Mid(Parameters!Albformat.Value,14,1)))
          
        
        0.6cm
        18.70676cm
        
        0.6cm
      
    
    3.1cm
  
  ElementNormal
  =User!Language
  
    true
    
      
        Output
        1.7cm
        18.2cm
        
        10
        true
        0.11cm
        1.35cm
        =iif(Mid(Parameters!Albformat.Value,17,1)="1","","Nota: " & Parameters!Remark.Value)
      
      
        0.45cm
        2.35cm
        
        9
        true
        8.39418cm
        0.52063cm
        =FormatNumber(Parameters!DtoTotal.Value,cint(Mid(Parameters!Albformat.Value,15,1)))
      
      
        0.45cm
        2.35cm
        
        8
        true
        5.78667cm
        0.52063cm
        IMP.Dto:
      
      
        1.05cm
        2.35cm
        
        7
        true
        8.39418cm
        0.52063cm
        =iif(Parameters!Dto.Value=0,"",FormatNumber(Parameters!Total.Value*Parameters!Dto.Value/100,cint(Mid(Parameters!Albformat.Value,15,1))))
      
      
        1.05cm
        2.35cm
        
        6
        true
        2.71751cm
        0.52063cm
        =iif(Parameters!Dto.Value=0,"",Parameters!Dto.Value)
      
      
        1.05cm
        2.35cm
        
        5
        true
        5.78667cm
        0.52063cm
        =iif(Parameters!Dto.Value=0,"","IMP.Vip.Dto:")
      
      
        1.05cm
        2.35cm
        
        4
        true
        0.11cm
        0.52063cm
        =iif(Parameters!Dto.Value=0,"","VIP.DTO(%):")
      
      
        0.45cm
        2.35cm
        
        3
        true
        0.11cm
        0.52063cm
        SUMA...:
      
      
        0.45cm
        2.35cm
        
        2
        true
        2.71751cm
        0.52063cm
        =FormatNumber(CDbl(Parameters!Total.Value)+CDbl(Parameters!DtoTotal.Value),cint(Mid(Parameters!Albformat.Value,15,1)))
      
      
        Output
        12.80pt
        202.01pt
        
        1
        true
        325.78pt
        27.55pt
        ="TOTAL:  " & FormatNumber(Parameters!Total.Value*(1-Parameters!Dto.Value/100),cint(Mid(Parameters!Albformat.Value,15,1)))
      
      
        0.25cm
        18.59cm
        
        0.11cm
        0cm
      
    
    3.3cm
    true
  
  27.94cm
  1cm