0 SQL Data Source=.;Initial Catalog=BuddyFinanceDB_QA true Integrated e64da7d6-84ee-4337-84ab-dbb5315c5a0f BuddyFinanceDb =Parameters!profileId.Value true =Parameters!startDate.Value true =Parameters!endDate.Value true StoredProcedure ProfileTransactions true Id System.Int32 ProfileId System.Int32 TransactionDate System.DateTime Description System.String Reference System.String Type System.String StatusType System.String Amount System.Double FeeTypeDescription System.String FeeAmount System.Double BuddyFinanceDb =Parameters!profileId.Value SELECT Profile.ProfileNumber, Profile.Name, Profile.Surname, ProfileType.Description AS ProfileType, Profile.Id FROM Profile INNER JOIN ProfileType ON Profile.ProfileTypeId = ProfileType.Id WHERE (Profile.Id = @profileId) ProfileNumber System.String Name System.String Surname System.String ProfileType System.String Id System.Int32 BuddyFinanceDb =Parameters!profileId.Value =Parameters!startDate.Value =Parameters!endDate.Value SELECT [Transaction].Id ,[Transaction].TransactionDate ,[Transaction].Description AS [Transaction Description] ,[Transaction].Reference ,[Transaction].Amount ,TransactionType.Description AS [TransactionType Description] FROM TransactionType INNER JOIN [Transaction] ON TransactionType.Id = [Transaction].TransactionTypeId WHERE [Transaction].ProfileId = @profileId AND ((@startDate is null OR [Transaction].TransactionDate > @startDate) AND ( @endDate is null OR [Transaction].TransactionDate <= @endDate)) true Id System.Int32 TransactionDate System.DateTime Transaction Description System.String Reference System.String Amount System.Double TransactionType Description System.String BuddyFinanceDb =Parameters!startDate.Value =Parameters!profileId.Value select IsNull(sum(case when [TransactionTypeId] = 1 and [TransactionDate] <= @startDate then amount end) - sum(case when [TransactionTypeId] = 2 and [TransactionDate] <= @startDate then amount end), 0)[Opening Balance] from [dbo].[Transaction] WHERE [ProfileId] = @profileId Opening Balance System.Double BuddyFinanceDb =Parameters!endDate.Value =Parameters!profileId.Value select IsNull(sum(case when [TransactionTypeId] = 1 and [TransactionDate] <= @endDate then amount end) - sum(case when [TransactionTypeId] = 2 and [TransactionDate] <= @endDate then amount end), 0)[Closing Balance] from [dbo].[Transaction] WHERE [ProfileId] = @profileId Closing Balance System.Double true true Statement of Transactions textbox1 0.07985in 12.14016cm 0.31541in 2.52084in 2pt 2pt 2pt 2pt Embedded logofull Fit 0.0454in 1.42916in 1.54891in 1 true true =Globals!ExecutionTime 2pt 2pt 2pt 2pt true true =First(Fields!ProfileType.Value, "ProfileData") + ": " + First(Fields!ProfileNumber.Value, "ProfileData") + vbcrlf + First(Fields!Name.Value, "ProfileData") + " " + First(Fields!Surname.Value, "ProfileData") 2pt 2pt 2pt 2pt true true 20 Phooko Street Kwa-Thema Ekurhuleni 1575 011 737 7028 info@thoroughcapital.co.za Textbox13 0.39526in 4.7796in 1.17306in 2.52084in 4 2pt 2pt 2pt 2pt 1.43805in 2.21206in 1.25372in 1.33706in 1.01414in 0.25in true true Date Textbox2 2pt 2pt 2pt 2pt true true Description Textbox4 2pt 2pt 2pt 2pt true true Reference Textbox6 2pt 2pt 2pt 2pt true true Amount Textbox8 2pt 2pt 2pt 2pt true true Type Textbox10 2pt 2pt 2pt 2pt 0.25in true true =Fields!TransactionDate.Value TransactionDate 2pt 2pt 2pt 2pt true true =Fields!Transaction_Description.Value 2pt 2pt 2pt 2pt true true =Fields!Reference.Value Reference 2pt 2pt 2pt 2pt true true =Fields!Amount.Value Amount 2pt 2pt 2pt 2pt en-ZA true true =Fields!TransactionType_Description.Value TransactionType_Description 2pt 2pt 2pt 2pt After Transactions 2.42943in 0.04541in 0.5in 7.25503in 5 4.90384in 1.33705in 1in 0.25in true true Closing Balance - =Parameters!endDate.Value 2pt 2pt 2pt 2pt true true =Fields!Closing_Balance.Value Closing_Balance 2pt 2pt 2pt 2pt en-ZA true true Textbox22 2pt 2pt 2pt 2pt =Fields!Closing_Balance.Value =Fields!Closing_Balance.Value ClosingBalance 2.94332in 0.0454in 0.25in 7.24089in 6 4.90384in 1.33704in 1in 0.25in true true Opening Balance - =Parameters!startDate.Value 2pt 2pt 2pt 2pt true true =Fields!Opening_Balance.Value Opening_Balance 2pt 2pt 2pt 2pt en-ZA true true Textbox23 2pt 2pt 2pt 2pt =Fields!Opening_Balance.Value =Fields!Opening_Balance.Value OpeningBalance 2.16554in 0.0454in 0.25in 7.24088in 7 8.85187cm 18.6825cm 0.40957in true true 11.69291in 8.26772in 0.3937in 0.3937in 0.3937in 0.3937in