Sorting by Count of relation
Sorting by Count of relation
I have created a report that shows a list of Members and a relation to the Members they have referred.
The report outputs the following as an example:
Russell Pooley - 1
John Thomas
James Blewitt - 2
Bob Jones
David Caller
Richard Egbert - 4
Pamela Eggbert
Trevor Tammy
Tom Ford
Andrew Smith
Ellena Eggbert - 1
Tina Jones
All i need to do now is get them to sort in count order e.g. Richard Would be first then James Blewitt and so on.
What would the expression be to sort them.
I have two data sources on the report the second one being related to the first.
Regards
Russell
The report outputs the following as an example:
Russell Pooley - 1
John Thomas
James Blewitt - 2
Bob Jones
David Caller
Richard Egbert - 4
Pamela Eggbert
Trevor Tammy
Tom Ford
Andrew Smith
Ellena Eggbert - 1
Tina Jones
All i need to do now is get them to sort in count order e.g. Richard Would be first then James Blewitt and so on.
What would the expression be to sort them.
I have two data sources on the report the second one being related to the first.
Regards
Russell
Sorting by Count of relation
Hello,
Please attach top topic your report.
Thank you.
Please attach top topic your report.
Thank you.
Sorting by Count of relation
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
Template
BranchId,System.Int32
Description,System.String
TemplateHtml,System.String
TemplateId,System.Int32
TemplateType,System.Int32
30
Template
ClubManager
_x0040_BranchId,_x0031_,0,0
SELECT [Template].[BranchId],[Template].[Description],[Template].[TemplateHtml],[Template].[TemplateId],[Template].[TemplateType] FROM [Template]
INNER JOIN [Branch] AS [FK_Template_Branch] ON [FK_Template_Branch].[BranchId] = [Template].[BranchId] AND [Template].[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
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
EngineV2
None;Black;2;Solid;False;4;Black
Transparent
Transparent
0,0.4,19,0.8
Transparent
True
0,0,2.2,0.8
Arial,8
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
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
Member
DataMember
ASC
{DataEnrolment.Count}
Transparent
0,2,19,0.8
Transparent
True
2.2,0,2.2,0.8
Arial,8
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
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
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
7/26/2009 8:46:51 PM
7/26/2009 8:35:43 PM
C:\Users\Russell\Desktop\Report.mrt
049dc50a94d341e69c5ca559a1540cf2
Report
Centimeters
2009.2.457
using System;
using System.Drawing;
using System.Windows.Forms;
using System.Data;
using Stimulsoft.Controls;
using Stimulsoft.Base.Drawing;
using Stimulsoft.Report;
using Stimulsoft.Report.Dialogs;
using Stimulsoft.Report.Components;
namespace Reports
{
public class Report : StiReport
{
public Report()
{
this.InitializeComponent();
}
#region StiReport Designer generated code - do not modify#endregion StiReport Designer generated code - do not modify
}
}
CSharp
Sorting by Count of relation
Hi Russel,
Please do as follows:
Add a 'data from other datasource' based on 'Member' datasource. Or you can add another sql datasource with the following information you need:
MemberShipNumber, Count of referred people by this member.
This DataSource will be a master for the 'Member' datasource, so you can create a datarelation between this new datasource and Member datasource.
Then place a databand for this new datasource before those bands you already have got in your report and set its height to zero.
There is an ability to sort by certain DataColumn using a DataBand sorting features.
Thank you.
Please do as follows:
Add a 'data from other datasource' based on 'Member' datasource. Or you can add another sql datasource with the following information you need:
MemberShipNumber, Count of referred people by this member.
This DataSource will be a master for the 'Member' datasource, so you can create a datarelation between this new datasource and Member datasource.
Then place a databand for this new datasource before those bands you already have got in your report and set its height to zero.
There is an ability to sort by certain DataColumn using a DataBand sorting features.
Thank you.
Sorting by Count of relation
Apologies for the delay, maybe I'm being a bit of a dumb ass but I cannot get it to work. Any chance you could modify my report and then post it back.
Then I will have a good example I can use moving forward.
Thanks.
Russell
Then I will have a good example I can use moving forward.
Thanks.
Russell
Sorting by Count of relation
- Attachments
-
- 202.report_modified.mrt
- (45.94 KiB) Downloaded 223 times
Sorting by Count of relation
A picture paints a thousand words. I shall try that this evening.
Love the flash movie, what do you use to create them?
Thanks again.
Russell
Love the flash movie, what do you use to create them?
Thanks again.
Russell
Sorting by Count of relation
Hello,
We use BBFlashBack and Demo Builder.
Thank you.
We use BBFlashBack and Demo Builder.
Thank you.