True ClubManager Initial Catalog=GymManager;data source=.;User Id=w1bbl3;Password=0dyssey; ClubManager False Attendance AttendanceId,System.Int32 Date,System.DateTime MemberId,System.Int32 30 Attendance ClubManager _x0040_BranchId,_x0031_,0,0 SELECT [Attendance].[AttendanceId],[Attendance].[Date],[Attendance].[MemberId] FROM [Attendance] INNER JOIN [Member] AS [FK_Attendance_Member] ON [FK_Attendance_Member].[MemberId] = [Attendance].[MemberId] INNER JOIN [Branch] AS [FK_Attendance_Member_FK_Member_Branch] ON [FK_Attendance_Member_FK_Member_Branch].[BranchId] = [FK_Attendance_Member].[BranchId] AND [FK_Attendance_Member].[BranchId] = @BranchId Branch BranchId,System.Int32 CompanyAddress,System.String CompanyName,System.String CompanyOfficialName,System.String DirectDebitReference,System.String FastDDReference,System.String Name,System.String PaymentStartDate,System.DateTime Prefix,System.String PublicKey,System.Guid Style,System.String 30 Branch ClubManager _x0040_BranchId,_x0031_,0,0 SELECT [Branch].[BranchId],[Branch].[CompanyAddress],[Branch].[CompanyName],[Branch].[CompanyOfficialName],[Branch].[DirectDebitReference],[Branch].[FastDDReference],[Branch].[Name],[Branch].[PaymentStartDate],[Branch].[Prefix],[Branch].[PublicKey],[Branch].[Style] FROM [Branch] WHERE [Branch].[BranchId] = @BranchId DailyAccount BranchId,System.Int32 DailyAccountId,System.Int32 Date,System.DateTime GuestVisits,System.Int32 Workouts,System.Int32 30 DailyAccount ClubManager _x0040_BranchId,_x0031_,0,0 SELECT [DailyAccount].[BranchId],[DailyAccount].[DailyAccountId],[DailyAccount].[Date],[DailyAccount].[GuestVisits],[DailyAccount].[Workouts] FROM [DailyAccount] INNER JOIN [Branch] AS [FK_DailyAccount_Branch] ON [FK_DailyAccount_Branch].[BranchId] = [DailyAccount].[BranchId] AND [DailyAccount].[BranchId] = @BranchId Enrolment DirectDebitDate,System.DateTime DirectDebitPayment,System.Decimal EndDate,System.DateTime EnrolmentFee,System.Decimal EnrolmentId,System.Int32 InductionFee,System.Decimal MemberId,System.Int32 MembershipFee,System.Decimal Payment1Date,System.DateTime Payment1Fee,System.Decimal Payment1Method,System.Int32 Payment1Type,System.Int32 Payment2Date,System.DateTime Payment2Fee,System.Decimal Payment2Method,System.Int32 Payment2Type,System.Int32 Payment3Date,System.DateTime Payment3Fee,System.Decimal Payment3Method,System.Int32 Payment3Type,System.Int32 PromotionId,System.Int32 RefererMemberId,System.Int32 StartDate,System.DateTime 30 Enrolment ClubManager _x0040_BranchId,_x0031_,0,0 SELECT [Enrolment].[DirectDebitDate],[Enrolment].[DirectDebitPayment],[Enrolment].[EndDate],[Enrolment].[EnrolmentFee],[Enrolment].[EnrolmentId],[Enrolment].[InductionFee],[Enrolment].[MemberId],[Enrolment].[MembershipFee],[Enrolment].[Payment1Date],[Enrolment].[Payment1Fee],[Enrolment].[Payment1Method],[Enrolment].[Payment1Type],[Enrolment].[Payment2Date],[Enrolment].[Payment2Fee],[Enrolment].[Payment2Method],[Enrolment].[Payment2Type],[Enrolment].[Payment3Date],[Enrolment].[Payment3Fee],[Enrolment].[Payment3Method],[Enrolment].[Payment3Type],[Enrolment].[PromotionId],[Enrolment].[RefererMemberId],[Enrolment].[StartDate] FROM [Enrolment] LEFT JOIN [Member] AS [FK_Enrolment_RefererMember] ON [FK_Enrolment_RefererMember].[MemberId] = [Enrolment].[RefererMemberId] LEFT JOIN [Branch] AS [FK_Enrolment_RefererMember_FK_Member_Branch] ON [FK_Enrolment_RefererMember_FK_Member_Branch].[BranchId] = [FK_Enrolment_RefererMember].[BranchId] AND [FK_Enrolment_RefererMember].[BranchId] = @BranchId INNER JOIN [Member] AS [FK_Enrolment_Member] ON [FK_Enrolment_Member].[MemberId] = [Enrolment].[MemberId] INNER JOIN [Branch] AS [FK_Enrolment_Member_FK_Member_Branch] ON [FK_Enrolment_Member_FK_Member_Branch].[BranchId] = [FK_Enrolment_Member].[BranchId] AND [FK_Enrolment_Member].[BranchId] = @BranchId LEFT JOIN [Promotion] AS [FK_Enrolment_Promotion] ON [FK_Enrolment_Promotion].[PromotionId] = [Enrolment].[PromotionId] LEFT JOIN [Branch] AS [FK_Enrolment_Promotion_FK_Promotion_Branch] ON [FK_Enrolment_Promotion_FK_Promotion_Branch].[BranchId] = [FK_Enrolment_Promotion].[BranchId] AND [FK_Enrolment_Promotion].[BranchId] = @BranchId Fee Amount,System.Decimal DueDate,System.DateTime EnrolmentId,System.Int32 FeeId,System.Int32 PaymentMethod,System.Int32 PaymentType,System.Int32 TransactionId,System.Int32 30 Fee ClubManager _x0040_BranchId,_x0031_,0,0 SELECT [Fee].[Amount],[Fee].[DueDate],[Fee].[EnrolmentId],[Fee].[FeeId],[Fee].[PaymentMethod],[Fee].[PaymentType],[Fee].[TransactionId] FROM [Fee] INNER JOIN [Enrolment] AS [FK_Fee_Enrolment] ON [FK_Fee_Enrolment].[EnrolmentId] = [Fee].[EnrolmentId] LEFT JOIN [Member] AS [FK_Fee_Enrolment_FK_Enrolment_RefererMember] ON [FK_Fee_Enrolment_FK_Enrolment_RefererMember].[MemberId] = [FK_Fee_Enrolment].[RefererMemberId] LEFT JOIN [Branch] AS [FK_Fee_Enrolment_FK_Enrolment_RefererMember_FK_Member_Branch] ON [FK_Fee_Enrolment_FK_Enrolment_RefererMember_FK_Member_Branch].[BranchId] = [FK_Fee_Enrolment_FK_Enrolment_RefererMember].[BranchId] AND [FK_Fee_Enrolment_FK_Enrolment_RefererMember].[BranchId] = @BranchId LEFT JOIN [Member] AS [FK_Fee_Enrolment_FK_Enrolment_Member] ON [FK_Fee_Enrolment_FK_Enrolment_Member].[MemberId] = [FK_Fee_Enrolment].[MemberId] LEFT JOIN [Branch] AS [FK_Fee_Enrolment_FK_Enrolment_Member_FK_Member_Branch] ON [FK_Fee_Enrolment_FK_Enrolment_Member_FK_Member_Branch].[BranchId] = [FK_Fee_Enrolment_FK_Enrolment_Member].[BranchId] AND [FK_Fee_Enrolment_FK_Enrolment_Member].[BranchId] = @BranchId LEFT JOIN [Promotion] AS [FK_Fee_Enrolment_FK_Enrolment_Promotion] ON [FK_Fee_Enrolment_FK_Enrolment_Promotion].[PromotionId] = [FK_Fee_Enrolment].[PromotionId] LEFT JOIN [Branch] AS [FK_Fee_Enrolment_FK_Enrolment_Promotion_FK_Promotion_Branch] ON [FK_Fee_Enrolment_FK_Enrolment_Promotion_FK_Promotion_Branch].[BranchId] = [FK_Fee_Enrolment_FK_Enrolment_Promotion].[BranchId] AND [FK_Fee_Enrolment_FK_Enrolment_Promotion].[BranchId] = @BranchId LEFT JOIN [Transaction] AS [FK_Fee_Transaction] ON [FK_Fee_Transaction].[TransactionId] = [Fee].[TransactionId] LEFT JOIN [TransactionHeader] AS [FK_Fee_Transaction_FK_Transaction_TransactionHeader] ON [FK_Fee_Transaction_FK_Transaction_TransactionHeader].[TransactionHeaderId] = [FK_Fee_Transaction].[TransactionHeaderId] LEFT JOIN [Branch] AS [FK_Fee_Transaction_FK_Transaction_TransactionHeader_FK_TransactionHeader_Branch] ON [FK_Fee_Transaction_FK_Transaction_TransactionHeader_FK_TransactionHeader_Branch].[BranchId] = [FK_Fee_Transaction_FK_Transaction_TransactionHeader].[BranchId] AND [FK_Fee_Transaction_FK_Transaction_TransactionHeader].[BranchId] = @BranchId Image BranchId,System.Int32 ImageId,System.Int32 Name,System.String Path,System.String 30 Image ClubManager _x0040_BranchId,_x0031_,0,0 SELECT [Image].[BranchId],[Image].[ImageId],[Image].[Name],[Image].[Path] FROM [Image] INNER JOIN [Branch] AS [FK_Image_Branch] ON [FK_Image_Branch].[BranchId] = [Image].[BranchId] AND [Image].[BranchId] = @BranchId Member Address1,System.String Address2,System.String BranchId,System.Int32 CardNumber,System.String City,System.String County,System.String DateOfBirth,System.DateTime DirectDebitAccountHolder,System.String DirectDebitAccountNumber,System.String DirectDebitBankAddress,System.String DirectDebitSortCode,System.String EmailAddress,System.String ExternalReference,System.String Forenames,System.String FullName,System.String HomePhone,System.String JoinedDate,System.DateTime Marketing,System.Boolean MemberId,System.Int32 MembershipNumber,System.String MemberType,System.Int32 MobilePhone,System.String Photo,System.Byte[] Postcode,System.String ShareWithFrachisor,System.Boolean Surname,System.String Title,System.String 30 Member ClubManager _x0040_BranchId,_x0031_,0,0 SELECT [Member].[Address1],[Member].[Address2],[Member].[BranchId],[Member].[CardNumber],[Member].[City],[Member].[County],[Member].[DateOfBirth],[Member].[DirectDebitAccountHolder],[Member].[DirectDebitAccountNumber],[Member].[DirectDebitBankAddress],[Member].[DirectDebitSortCode],[Member].[EmailAddress],[Member].[ExternalReference],[Member].[Forenames],[Member].[FullName],[Member].[HomePhone],[Member].[JoinedDate],[Member].[Marketing],[Member].[MemberId],[Member].[MembershipNumber],[Member].[MemberType],[Member].[MobilePhone],[Member].[Photo],[Member].[Postcode],[Member].[ShareWithFrachisor],[Member].[Surname],[Member].[Title] FROM [Member] INNER JOIN [Branch] AS [FK_Member_Branch] ON [FK_Member_Branch].[BranchId] = [Member].[BranchId] AND [Member].[BranchId] = @BranchId Preference BranchId,System.Int32 Key,System.String PreferenceId,System.Int32 Value,System.String 30 Preference ClubManager _x0040_BranchId,_x0031_,0,0 SELECT [Preference].[BranchId],[Preference].[Key],[Preference].[PreferenceId],[Preference].[Value] FROM [Preference] INNER JOIN [Branch] AS [FK_Preference_Branch] ON [FK_Preference_Branch].[BranchId] = [Preference].[BranchId] AND [Preference].[BranchId] = @BranchId Product BranchId,System.Int32 Description,System.String Name,System.String Price,System.Decimal ProductId,System.Int32 ProductType,System.Int32 TotalPrice,System.Decimal VAT,System.Decimal 30 Product ClubManager _x0040_BranchId,_x0031_,0,0 SELECT [Product].[BranchId],[Product].[Description],[Product].[Name],[Product].[Price],[Product].[ProductId],[Product].[ProductType],[Product].[TotalPrice],[Product].[VAT] FROM [Product] INNER JOIN [Branch] AS [FK_Product_Branch] ON [FK_Product_Branch].[BranchId] = [Product].[BranchId] AND [Product].[BranchId] = @BranchId Promotion BranchId,System.Int32 Name,System.String PromotionId,System.Int32 30 Promotion ClubManager _x0040_BranchId,_x0031_,0,0 SELECT [Promotion].[BranchId],[Promotion].[Name],[Promotion].[PromotionId] FROM [Promotion] INNER JOIN [Branch] AS [FK_Promotion_Branch] ON [FK_Promotion_Branch].[BranchId] = [Promotion].[BranchId] AND [Promotion].[BranchId] = @BranchId Purchase BranchId,System.Int32 Date,System.DateTime MemberId,System.Int32 PaymentMethod,System.Int32 ProductId,System.Int32 ProductPrice,System.Decimal ProductVAT,System.Decimal PurchaseId,System.Int32 Quantity,System.Decimal Total,System.Decimal TotalPrice,System.Decimal TotalVAT,System.Decimal 30 Purchase ClubManager _x0040_BranchId,_x0031_,0,0 SELECT [Purchase].[BranchId],[Purchase].[Date],[Purchase].[MemberId],[Purchase].[PaymentMethod],[Purchase].[ProductId],[Purchase].[ProductPrice],[Purchase].[ProductVAT],[Purchase].[PurchaseId],[Purchase].[Quantity],[Purchase].[Total],[Purchase].[TotalPrice],[Purchase].[TotalVAT] FROM [Purchase] INNER JOIN [Branch] AS [FK_Purchase_Branch] ON [FK_Purchase_Branch].[BranchId] = [Purchase].[BranchId] AND [Purchase].[BranchId] = @BranchId LEFT JOIN [Member] AS [FK_Purchase_Member] ON [FK_Purchase_Member].[MemberId] = [Purchase].[MemberId] LEFT JOIN [Branch] AS [FK_Purchase_Member_FK_Member_Branch] ON [FK_Purchase_Member_FK_Member_Branch].[BranchId] = [FK_Purchase_Member].[BranchId] AND [FK_Purchase_Member].[BranchId] = @BranchId LEFT JOIN [Product] AS [FK_Purchase_Product] ON [FK_Purchase_Product].[ProductId] = [Purchase].[ProductId] LEFT JOIN [Branch] AS [FK_Purchase_Product_FK_Product_Branch] ON [FK_Purchase_Product_FK_Product_Branch].[BranchId] = [FK_Purchase_Product].[BranchId] AND [FK_Purchase_Product].[BranchId] = @BranchId Transaction Amount,System.Decimal Date,System.DateTime ExternalReference,System.String InternalReference,System.String Name,System.String Status,System.Int32 TransactionHeaderId,System.Int32 TransactionId,System.Int32 30 Transaction ClubManager _x0040_BranchId,_x0031_,0,0 SELECT [Transaction].[Amount],[Transaction].[Date],[Transaction].[ExternalReference],[Transaction].[InternalReference],[Transaction].[Name],[Transaction].[Status],[Transaction].[TransactionHeaderId],[Transaction].[TransactionId] FROM [Transaction] INNER JOIN [TransactionHeader] AS [FK_Transaction_TransactionHeader] ON [FK_Transaction_TransactionHeader].[TransactionHeaderId] = [Transaction].[TransactionHeaderId] INNER JOIN [Branch] AS [FK_Transaction_TransactionHeader_FK_TransactionHeader_Branch] ON [FK_Transaction_TransactionHeader_FK_TransactionHeader_Branch].[BranchId] = [FK_Transaction_TransactionHeader].[BranchId] AND [FK_Transaction_TransactionHeader].[BranchId] = @BranchId TransactionHeader BranchId,System.Int32 TransactionHeaderId,System.Int32 UploadDate,System.DateTime 30 TransactionHeader ClubManager _x0040_BranchId,_x0031_,0,0 SELECT [TransactionHeader].[BranchId],[TransactionHeader].[TransactionHeaderId],[TransactionHeader].[UploadDate] FROM [TransactionHeader] INNER JOIN [Branch] AS [FK_TransactionHeader_Branch] ON [FK_TransactionHeader_Branch].[BranchId] = [TransactionHeader].[BranchId] AND [TransactionHeader].[BranchId] = @BranchId WeeklyAccount BranchId,System.Int32 Date,System.DateTime Expenses,System.Decimal GuestVisitsBooked,System.Int32 Income,System.Decimal WeeklyAccountId,System.Int32 30 WeeklyAccount ClubManager _x0040_BranchId,_x0031_,0,0 SELECT [WeeklyAccount].[BranchId],[WeeklyAccount].[Date],[WeeklyAccount].[Expenses],[WeeklyAccount].[GuestVisitsBooked],[WeeklyAccount].[Income],[WeeklyAccount].[WeeklyAccountId] FROM [WeeklyAccount] INNER JOIN [Branch] AS [FK_WeeklyAccount_Branch] ON [FK_WeeklyAccount_Branch].[BranchId] = [WeeklyAccount].[BranchId] AND [WeeklyAccount].[BranchId] = @BranchId MemberJournal Comment,System.String ForeignKeyId,System.Int32 JournalDate,System.DateTime JournalId,System.Int32 JournalType,System.Int32 MessageType,System.Int32 Title,System.String UserName,System.String 30 MemberJournal ClubManager _x0040_MessageType,_x0031_,0,0 _x0040_BranchId,_x0031_,0,0 SELECT [Journal].[Comment],[Journal].[ForeignKeyId],[Journal].[JournalDate],[Journal].[JournalId],[Journal].[JournalType],[Journal].[MessageType],[Journal].[Title],[Journal].[UserName] FROM [Journal] INNER JOIN [Member] AS [FK_Journal_Member] ON [FK_Journal_Member].[MemberId] = [Journal].[ForeignKeyId] INNER JOIN [Branch] AS [FK_Journal_Member_FK_Member_Branch] ON [FK_Journal_Member_FK_Member_Branch].[BranchId] = [FK_Journal_Member].[BranchId] AND [FK_Journal_Member].[BranchId] = @BranchId WHERE [Journal].[MessageType] = @MessageType DataSource1 MembershipNumber,System.String MembershipNumber.Count,System.Decimal MembershipNumber DataSource1 Member MembershipNumber Count MembershipNumber.Count Member MemberId Member FK_Attendance_Member MemberId Branch BranchId Branch FK_DailyAccount_Branch BranchId RefererMember RefererMemberId RefererMember FK_Enrolment_RefererMember MemberId Member MemberId Member FK_Enrolment_Member MemberId Promotion PromotionId Promotion FK_Enrolment_Promotion PromotionId Enrolment EnrolmentId Enrolment FK_Fee_Enrolment EnrolmentId Transaction TransactionId Transaction FK_Fee_Transaction TransactionId Branch BranchId Branch FK_Image_Branch BranchId Branch BranchId Branch FK_Member_Branch BranchId Branch BranchId Branch FK_Preference_Branch BranchId Branch BranchId Branch FK_Product_Branch BranchId Branch BranchId Branch FK_Promotion_Branch BranchId Branch BranchId Branch FK_Purchase_Branch BranchId Member MemberId Member FK_Purchase_Member MemberId Product ProductId Product FK_Purchase_Product ProductId Branch BranchId Branch FK_Template_Branch BranchId TransactionHeader TransactionHeaderId TransactionHeader FK_Transaction_TransactionHeader TransactionHeaderId Branch BranchId Branch FK_TransactionHeader_Branch BranchId Branch BranchId Branch FK_WeeklyAccount_Branch BranchId Member ForeignKeyId Member FK_Journal_Member MemberId NewRelation MembershipNumber NewRelation Relation MembershipNumber EngineV2 None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.4,19,0 DataSource1 0 0 DataDataSource1 ASC MembershipNumber_Count Transparent 0,1.2,19,0.8 Transparent True 0,0,2.2,0.8 Arial,8 None 0,0,0,0 0,0 0,0 DataMember_MembershipNumber {Member.MembershipNumber} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Center Transparent True 2.2,0,9.4,0.8 Arial,8 None 0,0,0,0 0,0 0,0 DataMember_FullName {Member.FullName} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Center Relation Member 0 0 DataMember ASC {DataEnrolment.Count} Transparent 0,2.8,19,0.8 Transparent True 2.2,0,2.2,0.8 Arial,8 None 0,0,0,0 0,0 0,0 DataEnrolment_Member_MembershipNumber {Enrolment.Member.MembershipNumber} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Center Transparent True 4.4,0,9.4,0.8 Arial,8 None 0,0,0,0 0,0 0,0 DataEnrolment_Member_FullName {Enrolment.Member.FullName} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Center FK_Enrolment_RefererMember Enrolment 0 0 DataEnrolment e6098c5a59db477b8ab58a2e48e06a9d 1,1,1,1 Page1 29.7 21 Arial,100 [50:0:0:0] System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Controls.Dll Stimulsoft.Base.Dll Stimulsoft.Report.Dll Report 8/5/2009 1:00:19 AM 7/26/2009 8:35:43 PM 4563aa65a4a34042b88b29dd0ed42238 Report Centimeters 2008.2.300 CSharp