xxxxxxxxxx
xxxxxxxxxx
0
SQL
Data Source=xxxxxxx\mssqlserver2017;Initial Catalog=research
true
Integrated
8018cf60-3b4f-498e-9b2e-a6c403cacb65
DataSource1
SELECT
[dim01]
,[dim02]
,[dim03]
,[dim05]
,[Name]
,[Status]
,[dim06]
,[dim07]
,[amount1]
,[amount2]
,[dim08]
,[AddressCity]
,[StreetNumber]
,[StreetName]
,[Apartment]
,[State]
,[ZipCode]
,[ZipCodePlus]
FROM [dbo].[Subtotresearch]
order by dim03,dim05,dim01
dim01
true
dim02
true
dim03
true
dim05
true
Name
true
Status
true
dim06
true
dim07
true
amount1
true
amount2
true
dim08
true
AddressCity
true
StreetNumber
true
StreetName
true
Apartment
true
State
true
ZipCode
true
ZipCodePlus
true
1.275in
0.8in
0.8in
0.25in
true
true
dim01
Textbox56
LightSteelBlue
2pt
2pt
2pt
2pt
true
true
amount1
Textbox61
LightSteelBlue
2pt
2pt
true
true
amount2
Textbox69
LightSteelBlue
2pt
2pt
0.25in
true
true
=Fields!dim01.Value
2pt
2pt
2pt
2pt
true
true
=Fields!amount1.Value
2pt
2pt
2pt
2pt
true
true
=Fields!amount2.Value
2pt
2pt
2pt
2pt
0.25in
true
true
Textbox49
LightGrey
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!amount1.Value)
Textbox50
LightGrey
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!amount2.Value)
Textbox51
LightGrey
2pt
2pt
2pt
2pt
0.25in
true
true
Textbox68
LightSteelBlue
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!amount1.Value)
Textbox70
LightSteelBlue
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!amount2.Value)
Textbox72
LightSteelBlue
2pt
2pt
2pt
2pt
0.75in
true
true
Type
Textbox131
LightSteelBlue
2pt
2pt
2pt
2pt
0.75644in
true
true
Acct
Textbox9
LightSteelBlue
2pt
2pt
2pt
2pt
1.21488in
true
true
Name
Textbox103
LightSteelBlue
2pt
2pt
2pt
2pt
0.88361in
true
true
Status
Textbox99
LightSteelBlue
2pt
2pt
0.93417in
true
true
dim06
Textbox97
LightSteelBlue
2pt
2pt
2pt
2pt
1.06772in
true
true
dim07
Textbox93
LightSteelBlue
2pt
2pt
2pt
2pt
0.68539in
true
true
dim08
Textbox89
LightSteelBlue
2pt
2pt
2pt
2pt
0.54839in
true
true
Street #
Textbox87
LightSteelBlue
2pt
2pt
2pt
2pt
1.09375in
true
true
Street Name
Textbox84
LightSteelBlue
2pt
2pt
2pt
2pt
0.46825in
true
true
Apt #
Textbox82
LightSteelBlue
2pt
2pt
2pt
2pt
0.79213in
true
true
City
Textbox79
LightSteelBlue
2pt
2pt
2pt
2pt
0.39583in
true
true
State
Textbox77
LightSteelBlue
2pt
2pt
2pt
2pt
0.47911in
true
true
Zip
Textbox75
LightSteelBlue
2pt
2pt
2pt
2pt
0.3827in
true
true
Zip +
Textbox71
LightSteelBlue
2pt
2pt
2pt
2pt
After
true
=Fields!dim03.Value
=Fields!dim03.Value
0.75in
true
true
=Fields!dim03.Value
2pt
2pt
2pt
2pt
=Fields!dim05.Value
=Fields!dim05.Value
0.75644in
true
true
=Fields!dim05.Value
2pt
2pt
2pt
2pt
=Fields!ZipCodePlus.Value
=Fields!ZipCode.Value
=Fields!State.Value
=Fields!AddressCity.Value
=Fields!Apartment.Value
=Fields!StreetName.Value
=Fields!StreetNumber.Value
=Fields!dim08.Value
=Fields!dim07.Value
=Fields!dim06.Value
=Fields!Status.Value
=Fields!Name.Value
=Fields!ZipCodePlus.Value
1.21488in
true
true
=Fields!Name.Value
Textbox104
2pt
2pt
2pt
2pt
0.88361in
true
true
=Fields!Status.Value
Textbox102
2pt
2pt
2pt
2pt
0.93417in
true
true
=Fields!dim06.Value
Textbox98
2pt
2pt
2pt
2pt
1.06772in
true
true
=Fields!dim07.Value
Textbox94
2pt
2pt
2pt
2pt
0.68539in
true
true
=Fields!dim08.Value
Textbox92
2pt
2pt
2pt
2pt
0.54839in
true
true
=Fields!StreetNumber.Value
Textbox88
2pt
2pt
2pt
2pt
1.09375in
true
true
=Fields!StreetName.Value
Textbox85
2pt
2pt
2pt
2pt
0.46825in
true
true
=Fields!Apartment.Value
Textbox83
2pt
2pt
2pt
2pt
0.79213in
true
true
=Fields!AddressCity.Value
Textbox80
2pt
2pt
2pt
2pt
0.39583in
true
true
=Fields!State.Value
Textbox78
2pt
2pt
2pt
2pt
0.47911in
true
true
=Fields!ZipCode.Value
Textbox76
2pt
2pt
2pt
2pt
0.3827in
true
true
=Fields!ZipCodePlus.Value
ZipCodePlus1
2pt
2pt
2pt
2pt
1.21488in
true
true
Acct Subtotal
Textbox31
LightGrey
2pt
2pt
2pt
2pt
0.88361in
true
true
Textbox32
LightGrey
2pt
2pt
2pt
2pt
0.93417in
true
true
Textbox33
LightGrey
2pt
2pt
2pt
2pt
1.06772in
true
true
Textbox34
LightGrey
2pt
2pt
2pt
2pt
0.68539in
true
true
Textbox40
LightGrey
2pt
2pt
2pt
2pt
0.54839in
true
true
Textbox41
LightGrey
2pt
2pt
2pt
2pt
1.09375in
true
true
Textbox43
LightGrey
2pt
2pt
2pt
2pt
0.46825in
true
true
Textbox44
LightGrey
2pt
2pt
2pt
2pt
0.79213in
true
true
Textbox45
LightGrey
2pt
2pt
2pt
2pt
0.39583in
true
true
Textbox46
LightGrey
2pt
2pt
2pt
2pt
0.47911in
true
true
Textbox47
LightGrey
2pt
2pt
2pt
2pt
0.3827in
true
true
Textbox48
LightGrey
2pt
2pt
2pt
2pt
=IIF(CountRows() = 1, True, False)
Before
0.75in
true
true
Grand Total
Textbox52
LightSteelBlue
2pt
2pt
2pt
2pt
0.75644in
true
true
Textbox53
LightSteelBlue
2pt
2pt
2pt
2pt
1.21488in
true
true
Textbox54
LightSteelBlue
2pt
2pt
2pt
2pt
0.88361in
true
true
Textbox55
LightSteelBlue
2pt
2pt
2pt
2pt
0.93417in
true
true
Textbox57
LightSteelBlue
2pt
2pt
2pt
2pt
1.06772in
true
true
Textbox58
LightSteelBlue
2pt
2pt
2pt
2pt
0.68539in
true
true
Textbox59
LightSteelBlue
2pt
2pt
2pt
2pt
0.54839in
true
true
Textbox60
LightSteelBlue
2pt
2pt
2pt
2pt
1.09375in
true
true
Textbox62
LightSteelBlue
2pt
2pt
2pt
2pt
0.46825in
true
true
Textbox63
LightSteelBlue
2pt
2pt
2pt
2pt
0.79213in
true
true
Textbox64
LightSteelBlue
2pt
2pt
2pt
2pt
0.39583in
true
true
Textbox65
LightSteelBlue
2pt
2pt
2pt
2pt
0.47911in
true
true
Textbox66
LightSteelBlue
2pt
2pt
2pt
2pt
0.3827in
true
true
Textbox67
LightSteelBlue
2pt
2pt
2pt
2pt
Before
DataSet1
1in
13.32737in
1.02861in
13.5052in
8.5in
14in
8.5in
14in
0.25in
0.25in
0.25in
0.25in
2
11
en-US
true
Inch
8cd208b4-d044-4de2-806f-256775d45c88