ChrisCompleteCodeTrunk
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
91
|
<?xml version="1.0" encoding="utf-8"?>
<Report DataSourceName="sqlDataSource2" Width="3in" Name="ATC Loyalty Receipt" xmlns="http://schemas.telerik.com/reporting/2012/3.8">
<DataSources>
<SqlDataSource ConnectionString="ATPP" SelectCommand="SELECT
	[Gift_Card_Transactions].[ID], 
	[Gift_Card_Transactions].[StoreID], 
	[Gift_Card_Transactions].[OrderID], 
	[Gift_Card_Transactions].[TransType], 
	[Gift_Card_Transactions].[Amount], 
	[Gift_Card_Transactions].[CardNbr], 
	[Gift_Card_Transactions].[CardType], 
	[Gift_Card_Transactions].[FirstName], 
	[Gift_Card_Transactions].[LastName], 
	[Gift_Card_Transactions].[Address], 
	[Gift_Card_Transactions].[City], 
	[Gift_Card_Transactions].[State], 
	[Gift_Card_Transactions].[Zip], 
	[Gift_Card_Transactions].[Phone], 
	[Gift_Card_Transactions].[Fax], 
	[Gift_Card_Transactions].[Email], 
	[Gift_Card_Transactions].[DateCreated], 
	[Gift_Card_Transactions].[CreatedBy]
FROM [Gift_Card_Transactions]
WHERE [Gift_Card_Transactions].[ID] = @Transactions_ID" Name="sqlDataSource2" ParameterValues="{"@Transactions_ID":"10000056"}" QueryDesignerState="<?xml version="1.0" encoding="utf-16"?><DM xmlns:z="http://schemas.microsoft.com/2003/10/Serialization/" xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Telerik.Reporting.Design.QueryDesigner"><Es><E z:Id="i1"><MBN>Gift_Card_Transactions</MBN><MBP z:Id="i2" i:type="Namespace"><MBN></MBN><MOC><MB z:Ref="i1" /></MOC></MBP><MOC><MB z:Id="i3" i:type="P"><MBN>ID</MBN><MBP z:Ref="i1" /><PO>true</PO></MB><MB z:Id="i4" i:type="P"><MBN>StoreID</MBN><MBP z:Ref="i1" /><PO>true</PO></MB><MB z:Id="i5" i:type="P"><MBN>OrderID</MBN><MBP z:Ref="i1" /><PO>true</PO></MB><MB z:Id="i6" i:type="P"><MBN>TransType</MBN><MBP z:Ref="i1" /><PO>true</PO></MB><MB z:Id="i7" i:type="P"><MBN>Amount</MBN><MBP z:Ref="i1" /><PO>true</PO></MB><MB z:Id="i8" i:type="P"><MBN>CardNbr</MBN><MBP z:Ref="i1" /><PO>true</PO></MB><MB z:Id="i9" i:type="P"><MBN>CardType</MBN><MBP z:Ref="i1" /><PO>true</PO></MB><MB z:Id="i10" i:type="P"><MBN>FirstName</MBN><MBP z:Ref="i1" /><PO>true</PO></MB><MB z:Id="i11" i:type="P"><MBN>LastName</MBN><MBP z:Ref="i1" /><PO>true</PO></MB><MB z:Id="i12" i:type="P"><MBN>Address</MBN><MBP z:Ref="i1" /><PO>true</PO></MB><MB z:Id="i13" i:type="P"><MBN>City</MBN><MBP z:Ref="i1" /><PO>true</PO></MB><MB z:Id="i14" i:type="P"><MBN>State</MBN><MBP z:Ref="i1" /><PO>true</PO></MB><MB z:Id="i15" i:type="P"><MBN>Zip</MBN><MBP z:Ref="i1" /><PO>true</PO></MB><MB z:Id="i16" i:type="P"><MBN>Phone</MBN><MBP z:Ref="i1" /><PO>true</PO></MB><MB z:Id="i17" i:type="P"><MBN>Fax</MBN><MBP z:Ref="i1" /><PO>true</PO></MB><MB z:Id="i18" i:type="P"><MBN>Email</MBN><MBP z:Ref="i1" /><PO>true</PO></MB><MB z:Id="i19" i:type="P"><MBN>DateCreated</MBN><MBP z:Ref="i1" /><PO>true</PO></MB><MB z:Id="i20" i:type="P"><MBN>CreatedBy</MBN><MBP z:Ref="i1" /><PO>true</PO></MB></MOC><ER /></E></Es><Fs><F><Op>Equals</Op><Pn>@Transactions_ID</Pn><Py z:Ref="i3" /><Ve>1000056</Ve></F></Fs><Ps><P z:Ref="i3" /><P z:Ref="i4" /><P z:Ref="i5" /><P z:Ref="i6" /><P z:Ref="i7" /><P z:Ref="i8" /><P z:Ref="i9" /><P z:Ref="i10" /><P z:Ref="i11" /><P z:Ref="i12" /><P z:Ref="i13" /><P z:Ref="i14" /><P z:Ref="i15" /><P z:Ref="i16" /><P z:Ref="i17" /><P z:Ref="i18" /><P z:Ref="i19" /><P z:Ref="i20" /></Ps><Rs /></DM>">
<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.59999974568685in" Height="0.199999968210856in" Left="1.29999987284342in" Top="2.04791673024495in" Value="= Fields.ID" 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.700000127156576in" Left="0.100000222524007in" Top="3.24791685740153in" Value="= 'GLTR' + 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="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>
<TextBox Width="1.09999978542328in" Height="0.200000122189522in" Left="0.100000381469727in" Top="1.74791669845581in" Value="Card Type:" Name="textBox5">
<Style TextAlign="Right" />
</TextBox>
<TextBox Width="1.60000026226044in" Height="0.19999997317791in" Left="1.29999923706055in" Top="1.74791669845581in" Value="= Parameters.CardType.Value" Name="textBox12" />
</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>
<ReportParameter Name="CardType" />
</ReportParameters>
</Report>
|
Revision |
Author |
Commited |
Message |
1
|
BBDSCHRIS
|
Wed 22 Aug, 2018 20:08:03 +0000 |
|