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 LightSteelBlue 2pt 2pt 2pt 2pt true true amount1 LightSteelBlue 2pt 2pt true true amount2 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 LightGrey 2pt 2pt 2pt 2pt true true =Sum(Fields!amount1.Value) LightGrey 2pt 2pt 2pt 2pt true true =Sum(Fields!amount2.Value) LightGrey 2pt 2pt 2pt 2pt 0.25in true true LightSteelBlue 2pt 2pt 2pt 2pt true true =Sum(Fields!amount1.Value) LightSteelBlue 2pt 2pt 2pt 2pt true true =Sum(Fields!amount2.Value) LightSteelBlue 2pt 2pt 2pt 2pt 0.75in true true Type LightSteelBlue 2pt 2pt 2pt 2pt 0.75644in true true Acct LightSteelBlue 2pt 2pt 2pt 2pt 1.21488in true true Name LightSteelBlue 2pt 2pt 2pt 2pt 0.88361in true true Status LightSteelBlue 2pt 2pt 0.93417in true true dim06 LightSteelBlue 2pt 2pt 2pt 2pt 1.06772in true true dim07 LightSteelBlue 2pt 2pt 2pt 2pt 0.68539in true true dim08 LightSteelBlue 2pt 2pt 2pt 2pt 0.54839in true true Street # LightSteelBlue 2pt 2pt 2pt 2pt 1.09375in true true Street Name LightSteelBlue 2pt 2pt 2pt 2pt 0.46825in true true Apt # LightSteelBlue 2pt 2pt 2pt 2pt 0.79213in true true City LightSteelBlue 2pt 2pt 2pt 2pt 0.39583in true true State LightSteelBlue 2pt 2pt 2pt 2pt 0.47911in true true Zip LightSteelBlue 2pt 2pt 2pt 2pt 0.3827in true true Zip + 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 2pt 2pt 2pt 2pt 0.88361in true true =Fields!Status.Value 2pt 2pt 2pt 2pt 0.93417in true true =Fields!dim06.Value 2pt 2pt 2pt 2pt 1.06772in true true =Fields!dim07.Value 2pt 2pt 2pt 2pt 0.68539in true true =Fields!dim08.Value 2pt 2pt 2pt 2pt 0.54839in true true =Fields!StreetNumber.Value 2pt 2pt 2pt 2pt 1.09375in true true =Fields!StreetName.Value 2pt 2pt 2pt 2pt 0.46825in true true =Fields!Apartment.Value 2pt 2pt 2pt 2pt 0.79213in true true =Fields!AddressCity.Value 2pt 2pt 2pt 2pt 0.39583in true true =Fields!State.Value 2pt 2pt 2pt 2pt 0.47911in true true =Fields!ZipCode.Value 2pt 2pt 2pt 2pt 0.3827in true true =Fields!ZipCodePlus.Value 2pt 2pt 2pt 2pt 1.21488in true true Acct Subtotal LightGrey 2pt 2pt 2pt 2pt 0.88361in true true LightGrey 2pt 2pt 2pt 2pt 0.93417in true true LightGrey 2pt 2pt 2pt 2pt 1.06772in true true LightGrey 2pt 2pt 2pt 2pt 0.68539in true true LightGrey 2pt 2pt 2pt 2pt 0.54839in true true LightGrey 2pt 2pt 2pt 2pt 1.09375in true true LightGrey 2pt 2pt 2pt 2pt 0.46825in true true LightGrey 2pt 2pt 2pt 2pt 0.79213in true true LightGrey 2pt 2pt 2pt 2pt 0.39583in true true LightGrey 2pt 2pt 2pt 2pt 0.47911in true true LightGrey 2pt 2pt 2pt 2pt 0.3827in true true LightGrey 2pt 2pt 2pt 2pt =IIF(CountRows() = 1, True, False) Before 0.75in true true Grand Total LightSteelBlue 2pt 2pt 2pt 2pt 0.75644in true true LightSteelBlue 2pt 2pt 2pt 2pt 1.21488in true true LightSteelBlue 2pt 2pt 2pt 2pt 0.88361in true true LightSteelBlue 2pt 2pt 2pt 2pt 0.93417in true true LightSteelBlue 2pt 2pt 2pt 2pt 1.06772in true true LightSteelBlue 2pt 2pt 2pt 2pt 0.68539in true true LightSteelBlue 2pt 2pt 2pt 2pt 0.54839in true true LightSteelBlue 2pt 2pt 2pt 2pt 1.09375in true true LightSteelBlue 2pt 2pt 2pt 2pt 0.46825in true true LightSteelBlue 2pt 2pt 2pt 2pt 0.79213in true true LightSteelBlue 2pt 2pt 2pt 2pt 0.39583in true true LightSteelBlue 2pt 2pt 2pt 2pt 0.47911in true true LightSteelBlue 2pt 2pt 2pt 2pt 0.3827in true true LightSteelBlue 2pt 2pt 2pt 2pt Before DataSet1 1in 13.32737in 1.02861in