Creating reports and dashboards | Stimulsoft community forum

Reporting tool and data analytics tools for creating reports and dashboards in ASP.NET, ASP.NET MVC, .NET Core, Blazor, Angular, PHP, Python, WPF, JavaScript, and Java applications.
https://forum.stimulsoft.com/

Sorting by Count of relation

https://forum.stimulsoft.com/viewtopic.php?t=2224

Page 1 of 1

Sorting by Count of relation

Posted: Mon Jul 20, 2009 6:52 am
by rpooley
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

Sorting by Count of relation

Posted: Tue Jul 21, 2009 6:52 am
by Jan
Hello,

Please attach top topic your report.

Thank you.

Sorting by Count of relation

Posted: Sun Jul 26, 2009 3:33 pm
by rpooley





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

Posted: Wed Jul 29, 2009 6:35 am
by Edward
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.

Sorting by Count of relation

Posted: Tue Aug 04, 2009 3:55 pm
by rpooley
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

Sorting by Count of relation

Posted: Tue Aug 04, 2009 7:01 pm
by Edward
Hi,

Here you are.

Steps required

Please let us know if you need any help.

Thank you.

Sorting by Count of relation

Posted: Wed Aug 05, 2009 8:40 am
by rpooley
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

Sorting by Count of relation

Posted: Wed Aug 05, 2009 8:51 am
by Andrew
Hello,

We use BBFlashBack and Demo Builder.

Thank you.
All times are UTC
Page 1 of 1

Powered by phpBB® Forum Software © phpBB Limited