Chris' Complete Code Trunk
Subversion Repository Public Repository

ChrisCompleteCodeTrunk

URLs

Copy to Clipboard
Explore
Commits
@ 1

ChrisCompleteCodeTrunk / ATTP / Action Tire Payment Processor / Reports / ATC Receipt.trdx 

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90

<?xml version="1.0" encoding="utf-8"?>
<Report DataSourceName="sqlDataSource2" Width="3in" Name="ATC Receipt" xmlns="http://schemas.telerik.com/reporting/2012/3.8">
  <DataSources>
    <SqlDataSource ConnectionString="ATPP1" SelectCommand="SELECT&#xD;&#xA;&#x9;[Transactions].[ID], &#xD;&#xA;&#x9;[Transactions].[StoreID], &#xD;&#xA;&#x9;[Transactions].[PrinterIP], &#xD;&#xA;&#x9;[Transactions].[OrderID], &#xD;&#xA;&#x9;[Transactions].[TransType], &#xD;&#xA;&#x9;[Transactions].[Amount], &#xD;&#xA;&#x9;[Transactions].[CardNbr], &#xD;&#xA;&#x9;[Transactions].[Cardholder], &#xD;&#xA;&#x9;[Transactions].[FirstName], &#xD;&#xA;&#x9;[Transactions].[LastName], &#xD;&#xA;&#x9;[Transactions].[ExpDate], &#xD;&#xA;&#x9;[Transactions].[Address], &#xD;&#xA;&#x9;[Transactions].[City], &#xD;&#xA;&#x9;[Transactions].[State], &#xD;&#xA;&#x9;[Transactions].[Zip], &#xD;&#xA;&#x9;[Transactions].[Phone], &#xD;&#xA;&#x9;[Transactions].[Fax], &#xD;&#xA;&#x9;[Transactions].[Email], &#xD;&#xA;&#x9;[Transactions].[Response], &#xD;&#xA;&#x9;[Transactions].[Response_Code], &#xD;&#xA;&#x9;[Transactions].[Response_Text], &#xD;&#xA;&#x9;[Transactions].[AuthCode], &#xD;&#xA;&#x9;[Transactions].[TransID], &#xD;&#xA;&#x9;[Transactions].[AVS_Response], &#xD;&#xA;&#x9;[Transactions].[CVV_Response], &#xD;&#xA;&#x9;[Transactions].[DateCreated], &#xD;&#xA;&#x9;[Transactions].[CardType], &#xD;&#xA;&#x9;[Transactions].[Amount_Mismatch], &#xD;&#xA;&#x9;[Transactions].[CardTypeGroup], &#xD;&#xA;&#x9;[Transactions].[ProcID], &#xD;&#xA;&#x9;[Transactions].[CreationDate]&#xD;&#xA;FROM [Transactions]&#xD;&#xA;WHERE [Transactions].[ID] = @Transactions_ID" Name="sqlDataSource2" ParameterValues="{&quot;@Transactions_ID&quot;:&quot;214&quot;}" QueryDesignerState="&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-16&quot;?&gt;&lt;DM xmlns:z=&quot;http://schemas.microsoft.com/2003/10/Serialization/&quot; xmlns:i=&quot;http://www.w3.org/2001/XMLSchema-instance&quot; xmlns=&quot;http://schemas.datacontract.org/2004/07/Telerik.Reporting.Design.QueryDesigner&quot;&gt;&lt;Es&gt;&lt;E z:Id=&quot;i1&quot;&gt;&lt;MBN&gt;Transactions&lt;/MBN&gt;&lt;MBP z:Id=&quot;i2&quot; i:type=&quot;Namespace&quot;&gt;&lt;MBN&gt;&lt;/MBN&gt;&lt;MOC&gt;&lt;MB z:Ref=&quot;i1&quot; /&gt;&lt;/MOC&gt;&lt;/MBP&gt;&lt;MOC&gt;&lt;MB z:Id=&quot;i3&quot; i:type=&quot;P&quot;&gt;&lt;MBN&gt;ID&lt;/MBN&gt;&lt;MBP z:Ref=&quot;i1&quot; /&gt;&lt;PO&gt;true&lt;/PO&gt;&lt;/MB&gt;&lt;MB z:Id=&quot;i4&quot; i:type=&quot;P&quot;&gt;&lt;MBN&gt;StoreID&lt;/MBN&gt;&lt;MBP z:Ref=&quot;i1&quot; /&gt;&lt;PO&gt;true&lt;/PO&gt;&lt;/MB&gt;&lt;MB z:Id=&quot;i5&quot; i:type=&quot;P&quot;&gt;&lt;MBN&gt;PrinterIP&lt;/MBN&gt;&lt;MBP z:Ref=&quot;i1&quot; /&gt;&lt;PO&gt;true&lt;/PO&gt;&lt;/MB&gt;&lt;MB z:Id=&quot;i6&quot; i:type=&quot;P&quot;&gt;&lt;MBN&gt;OrderID&lt;/MBN&gt;&lt;MBP z:Ref=&quot;i1&quot; /&gt;&lt;PO&gt;true&lt;/PO&gt;&lt;/MB&gt;&lt;MB z:Id=&quot;i7&quot; i:type=&quot;P&quot;&gt;&lt;MBN&gt;TransType&lt;/MBN&gt;&lt;MBP z:Ref=&quot;i1&quot; /&gt;&lt;PO&gt;true&lt;/PO&gt;&lt;/MB&gt;&lt;MB z:Id=&quot;i8&quot; i:type=&quot;P&quot;&gt;&lt;MBN&gt;Amount&lt;/MBN&gt;&lt;MBP z:Ref=&quot;i1&quot; /&gt;&lt;PO&gt;true&lt;/PO&gt;&lt;/MB&gt;&lt;MB z:Id=&quot;i9&quot; i:type=&quot;P&quot;&gt;&lt;MBN&gt;CardNbr&lt;/MBN&gt;&lt;MBP z:Ref=&quot;i1&quot; /&gt;&lt;PO&gt;true&lt;/PO&gt;&lt;/MB&gt;&lt;MB z:Id=&quot;i10&quot; i:type=&quot;P&quot;&gt;&lt;MBN&gt;Cardholder&lt;/MBN&gt;&lt;MBP z:Ref=&quot;i1&quot; /&gt;&lt;PO&gt;true&lt;/PO&gt;&lt;/MB&gt;&lt;MB z:Id=&quot;i11&quot; i:type=&quot;P&quot;&gt;&lt;MBN&gt;FirstName&lt;/MBN&gt;&lt;MBP z:Ref=&quot;i1&quot; /&gt;&lt;PO&gt;true&lt;/PO&gt;&lt;/MB&gt;&lt;MB z:Id=&quot;i12&quot; i:type=&quot;P&quot;&gt;&lt;MBN&gt;LastName&lt;/MBN&gt;&lt;MBP z:Ref=&quot;i1&quot; /&gt;&lt;PO&gt;true&lt;/PO&gt;&lt;/MB&gt;&lt;MB z:Id=&quot;i13&quot; i:type=&quot;P&quot;&gt;&lt;MBN&gt;ExpDate&lt;/MBN&gt;&lt;MBP z:Ref=&quot;i1&quot; /&gt;&lt;PO&gt;true&lt;/PO&gt;&lt;/MB&gt;&lt;MB z:Id=&quot;i14&quot; i:type=&quot;P&quot;&gt;&lt;MBN&gt;Address&lt;/MBN&gt;&lt;MBP z:Ref=&quot;i1&quot; /&gt;&lt;PO&gt;true&lt;/PO&gt;&lt;/MB&gt;&lt;MB z:Id=&quot;i15&quot; i:type=&quot;P&quot;&gt;&lt;MBN&gt;City&lt;/MBN&gt;&lt;MBP z:Ref=&quot;i1&quot; /&gt;&lt;PO&gt;true&lt;/PO&gt;&lt;/MB&gt;&lt;MB z:Id=&quot;i16&quot; i:type=&quot;P&quot;&gt;&lt;MBN&gt;State&lt;/MBN&gt;&lt;MBP z:Ref=&quot;i1&quot; /&gt;&lt;PO&gt;true&lt;/PO&gt;&lt;/MB&gt;&lt;MB z:Id=&quot;i17&quot; i:type=&quot;P&quot;&gt;&lt;MBN&gt;Zip&lt;/MBN&gt;&lt;MBP z:Ref=&quot;i1&quot; /&gt;&lt;PO&gt;true&lt;/PO&gt;&lt;/MB&gt;&lt;MB z:Id=&quot;i18&quot; i:type=&quot;P&quot;&gt;&lt;MBN&gt;Phone&lt;/MBN&gt;&lt;MBP z:Ref=&quot;i1&quot; /&gt;&lt;PO&gt;true&lt;/PO&gt;&lt;/MB&gt;&lt;MB z:Id=&quot;i19&quot; i:type=&quot;P&quot;&gt;&lt;MBN&gt;Fax&lt;/MBN&gt;&lt;MBP z:Ref=&quot;i1&quot; /&gt;&lt;PO&gt;true&lt;/PO&gt;&lt;/MB&gt;&lt;MB z:Id=&quot;i20&quot; i:type=&quot;P&quot;&gt;&lt;MBN&gt;Email&lt;/MBN&gt;&lt;MBP z:Ref=&quot;i1&quot; /&gt;&lt;PO&gt;true&lt;/PO&gt;&lt;/MB&gt;&lt;MB z:Id=&quot;i21&quot; i:type=&quot;P&quot;&gt;&lt;MBN&gt;Response&lt;/MBN&gt;&lt;MBP z:Ref=&quot;i1&quot; /&gt;&lt;PO&gt;true&lt;/PO&gt;&lt;/MB&gt;&lt;MB z:Id=&quot;i22&quot; i:type=&quot;P&quot;&gt;&lt;MBN&gt;Response_Code&lt;/MBN&gt;&lt;MBP z:Ref=&quot;i1&quot; /&gt;&lt;PO&gt;true&lt;/PO&gt;&lt;/MB&gt;&lt;MB z:Id=&quot;i23&quot; i:type=&quot;P&quot;&gt;&lt;MBN&gt;Response_Text&lt;/MBN&gt;&lt;MBP z:Ref=&quot;i1&quot; /&gt;&lt;PO&gt;true&lt;/PO&gt;&lt;/MB&gt;&lt;MB z:Id=&quot;i24&quot; i:type=&quot;P&quot;&gt;&lt;MBN&gt;AuthCode&lt;/MBN&gt;&lt;MBP z:Ref=&quot;i1&quot; /&gt;&lt;PO&gt;true&lt;/PO&gt;&lt;/MB&gt;&lt;MB z:Id=&quot;i25&quot; i:type=&quot;P&quot;&gt;&lt;MBN&gt;TransID&lt;/MBN&gt;&lt;MBP z:Ref=&quot;i1&quot; /&gt;&lt;PO&gt;true&lt;/PO&gt;&lt;/MB&gt;&lt;MB z:Id=&quot;i26&quot; i:type=&quot;P&quot;&gt;&lt;MBN&gt;AVS_Response&lt;/MBN&gt;&lt;MBP z:Ref=&quot;i1&quot; /&gt;&lt;PO&gt;true&lt;/PO&gt;&lt;/MB&gt;&lt;MB z:Id=&quot;i27&quot; i:type=&quot;P&quot;&gt;&lt;MBN&gt;CVV_Response&lt;/MBN&gt;&lt;MBP z:Ref=&quot;i1&quot; /&gt;&lt;PO&gt;true&lt;/PO&gt;&lt;/MB&gt;&lt;MB z:Id=&quot;i28&quot; i:type=&quot;P&quot;&gt;&lt;MBN&gt;DateCreated&lt;/MBN&gt;&lt;MBP z:Ref=&quot;i1&quot; /&gt;&lt;PO&gt;true&lt;/PO&gt;&lt;/MB&gt;&lt;MB z:Id=&quot;i29&quot; i:type=&quot;P&quot;&gt;&lt;MBN&gt;CardType&lt;/MBN&gt;&lt;MBP z:Ref=&quot;i1&quot; /&gt;&lt;PO&gt;true&lt;/PO&gt;&lt;/MB&gt;&lt;MB z:Id=&quot;i30&quot; i:type=&quot;P&quot;&gt;&lt;MBN&gt;Amount_Mismatch&lt;/MBN&gt;&lt;MBP z:Ref=&quot;i1&quot; /&gt;&lt;PO&gt;true&lt;/PO&gt;&lt;/MB&gt;&lt;MB z:Id=&quot;i31&quot; i:type=&quot;P&quot;&gt;&lt;MBN&gt;CardTypeGroup&lt;/MBN&gt;&lt;MBP z:Ref=&quot;i1&quot; /&gt;&lt;PO&gt;true&lt;/PO&gt;&lt;/MB&gt;&lt;MB z:Id=&quot;i32&quot; i:type=&quot;P&quot;&gt;&lt;MBN&gt;ProcID&lt;/MBN&gt;&lt;MBP z:Ref=&quot;i1&quot; /&gt;&lt;PO&gt;true&lt;/PO&gt;&lt;/MB&gt;&lt;MB z:Id=&quot;i33&quot; i:type=&quot;P&quot;&gt;&lt;MBN&gt;CreationDate&lt;/MBN&gt;&lt;MBP z:Ref=&quot;i1&quot; /&gt;&lt;PO&gt;true&lt;/PO&gt;&lt;/MB&gt;&lt;/MOC&gt;&lt;ER /&gt;&lt;/E&gt;&lt;/Es&gt;&lt;Fs&gt;&lt;F&gt;&lt;Op&gt;Equals&lt;/Op&gt;&lt;Pn&gt;@Transactions_ID&lt;/Pn&gt;&lt;Py z:Ref=&quot;i3&quot; /&gt;&lt;Ve&gt;214&lt;/Ve&gt;&lt;/F&gt;&lt;/Fs&gt;&lt;Ps&gt;&lt;P z:Ref=&quot;i3&quot; /&gt;&lt;P z:Ref=&quot;i4&quot; /&gt;&lt;P z:Ref=&quot;i5&quot; /&gt;&lt;P z:Ref=&quot;i6&quot; /&gt;&lt;P z:Ref=&quot;i7&quot; /&gt;&lt;P z:Ref=&quot;i8&quot; /&gt;&lt;P z:Ref=&quot;i9&quot; /&gt;&lt;P z:Ref=&quot;i10&quot; /&gt;&lt;P z:Ref=&quot;i11&quot; /&gt;&lt;P z:Ref=&quot;i12&quot; /&gt;&lt;P z:Ref=&quot;i13&quot; /&gt;&lt;P z:Ref=&quot;i14&quot; /&gt;&lt;P z:Ref=&quot;i15&quot; /&gt;&lt;P z:Ref=&quot;i16&quot; /&gt;&lt;P z:Ref=&quot;i17&quot; /&gt;&lt;P z:Ref=&quot;i18&quot; /&gt;&lt;P z:Ref=&quot;i19&quot; /&gt;&lt;P z:Ref=&quot;i20&quot; /&gt;&lt;P z:Ref=&quot;i21&quot; /&gt;&lt;P z:Ref=&quot;i22&quot; /&gt;&lt;P z:Ref=&quot;i23&quot; /&gt;&lt;P z:Ref=&quot;i24&quot; /&gt;&lt;P z:Ref=&quot;i25&quot; /&gt;&lt;P z:Ref=&quot;i26&quot; /&gt;&lt;P z:Ref=&quot;i27&quot; /&gt;&lt;P z:Ref=&quot;i28&quot; /&gt;&lt;P z:Ref=&quot;i29&quot; /&gt;&lt;P z:Ref=&quot;i30&quot; /&gt;&lt;P z:Ref=&quot;i31&quot; /&gt;&lt;P z:Ref=&quot;i32&quot; /&gt;&lt;P z:Ref=&quot;i33&quot; /&gt;&lt;/Ps&gt;&lt;Rs /&gt;&lt;/DM&gt;">
      <Parameters>
        <SqlDataSourceParameter DbType="Int32" Name="@Transactions_ID">
          <Value>
            <String>= Parameters.ID.Value</String>
          </Value>
        </SqlDataSourceParameter>
      </Parameters>
    </SqlDataSource>
  </DataSources>
  <Items>
    <PageHeaderSection Height="0.0520833333333334in" Name="pageHeaderSection1" />
    <DetailSection Height="4.04799556732178in" Name="detailSection1">
      <Items>
        <TextBox Width="1.60000006357829in" Height="0.200000047683716in" Left="1.29999987284342in" Top="0.847916682561239in" Value="= Format('{0} {1}', Fields.FirstName, Fields.LastName)" Name="textBox1" />
        <TextBox Width="1.60000006357829in" Height="0.199999968210856in" Left="1.29999987284342in" Top="1.14791671435038in" Value="= Fields.OrderID" Name="textBox3" />
        <TextBox Width="1.60000022252401in" Height="0.199999968210856in" Left="1.29999987284342in" Top="1.44791666666667in" Value="= '******' + Fields.CardNbr" Name="textBox4" />
        <TextBox Width="1.59999990463257in" Height="0.199999968210856in" Left="1.29999987284342in" Top="1.74791669845581in" Value="= Fields.AuthCode" Name="textBox5" />
        <TextBox Width="1.59999974568685in" Height="0.199999968210856in" Left="1.29999987284342in" Top="2.04791673024495in" Value="= Fields.TransID" Name="textBox6" />
        <TextBox Width="1.59999974568685in" Height="0.199999968210856in" Left="1.29999987284342in" Top="2.64791679382324in" Value="= Fields.Amount" Format="{0:C2}" Name="textBox7">
          <Style>
            <Font Bold="True" />
          </Style>
        </TextBox>
        <TextBox Width="1.59999958674113in" Height="0.199999809265137in" Left="1.29999987284342in" Top="2.34791692097982in" Value="= Fields.DateCreated" Name="textBox8" />
        <TextBox Width="2.79999987284342in" Height="0.300000111262004in" Left="0.100000222524007in" Top="0.247916618982951in" Value="= ToUpper(Fields.TransType) + ' RECEIPT'" Name="textBox9">
          <Style TextAlign="Center">
            <Font Size="14pt" />
          </Style>
        </TextBox>
        <Barcode Width="2.79999987284342in" Height="0.600000063578288in" Left="0.100000222524007in" Top="3.34791660308838in" Value="= 'TR' + Fields.ID" Name="barcode1">
          <Style TextAlign="Center" />
          <Encoder>
            <Code39Encoder />
          </Encoder>
        </Barcode>
        <TextBox Width="1.09999974568685in" Height="0.200000127156576in" Left="0.100000222524007in" Top="0.847916603088379in" Value="Customer:" Name="textBox2">
          <Style TextAlign="Right" />
        </TextBox>
        <TextBox Width="1.09999978542328in" Height="0.200000122189522in" Left="0.100000222524007in" Top="1.14791679382324in" Value="Order ID:" Name="textBox10">
          <Style TextAlign="Right" />
        </TextBox>
        <TextBox Width="1.09999978542328in" Height="0.200000122189522in" Left="0.100000222524007in" Top="1.44791666666667in" Value="Card Number:" Name="textBox11">
          <Style TextAlign="Right" />
        </TextBox>
        <TextBox Width="1.09999978542328in" Height="0.200000122189522in" Left="0.100000222524007in" Top="1.74791669845581in" Value="Auth Code:" Name="textBox12">
          <Style TextAlign="Right" />
        </TextBox>
        <TextBox Width="1.09999978542328in" Height="0.200000122189522in" Left="0.100000222524007in" Top="2.04791673024495in" Value="Transaction ID:" Name="textBox13">
          <Style TextAlign="Right" />
        </TextBox>
        <TextBox Width="1.09999978542328in" Height="0.200000122189522in" Left="0.100000222524007in" Top="2.34791660308838in" Value="Date:" Name="textBox14">
          <Style TextAlign="Right" />
        </TextBox>
        <TextBox Width="1.09999978542328in" Height="0.200000122189522in" Left="0.100000222524007in" Top="2.64791679382324in" Value="Amount:" Name="textBox15">
          <Style TextAlign="Right" />
        </TextBox>
      </Items>
    </DetailSection>
    <PageFooterSection Height="0.100000063578288in" Name="pageFooterSection1" />
  </Items>
  <StyleSheet>
    <StyleRule>
      <Style>
        <Padding Left="2pt" Right="2pt" />
      </Style>
      <Selectors>
        <TypeSelector Type="TextItemBase" />
        <TypeSelector Type="HtmlTextBox" />
      </Selectors>
    </StyleRule>
  </StyleSheet>
  <PageSettings>
    <PageSettings PaperKind="Letter" Landscape="False" ColumnCount="1" ColumnSpacing="0in">
      <Margins>
        <MarginsU Left="1in" Right="1in" Top="1in" Bottom="1in" />
      </Margins>
    </PageSettings>
  </PageSettings>
  <ReportParameters>
    <ReportParameter Name="ID" Type="Integer" AllowBlank="False">
      <Value>
        <String>214</String>
      </Value>
    </ReportParameter>
  </ReportParameters>
</Report>

Commits for ChrisCompleteCodeTrunk/ATTP/Action Tire Payment Processor/Reports/ATC Receipt.trdx

Diff revisions: vs.
Revision Author Commited Message
1 BBDSCHRIS picture BBDSCHRIS Wed 22 Aug, 2018 20:08:03 +0000

History View complete history Commits RSS feed for /ATTP/Action Tire Payment Processor/Reports/ATC Receipt.trdx

Need assistance?   Get in touch, or head to our documentation site.