Crystal Report show group title with no records.

In Crystal Report I have two groups.
Group 1 is Club Name.
Group 2 is Club Role.
Then I have members in those club roles.

User wants to see always all 10 Club Role groups on report, does not matter if there is member in or not in group.
If there is no member for Club Role group then show Club Role Title and empty space for detail records.
Any idea?
I can not insert new query or table in report or do Union on existing tables.
TarasAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
Check the attached report.

mlmcc
Q-28230032.xls
Q-28230032.rpt
0
mlmccCommented:
The trick is to use formulas to watch for missing roles and display them in the group header before the next role

Similarly at the end of the report or outer group to look for roles that are still to be displayed

mlmcc
0
TarasAuthor Commented:
clmcc.
 In the formula DisplayMissingLeadingRole

This part

While  CurrentRoleIndex <= UBound(ClubRolesList) AND {Sheet1_.ClubRole} > ClubRolesList[CurrentRoleIndex]  do

What "{Sheet1_.ClubRole}" in my case is? Is that GroupName or  field Name that group is based on or what?.
And
Should not  it be :
While  CurrentRoleIndex <= UBound(ClubRolesList) AND {Sheet1_.ClubRole} < > ClubRolesList[CurrentRoleIndex]  do
0
Become a Certified Penetration Testing Engineer

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

mlmccCommented:
It is the field/formula you selected for the group

For the > vs <>
You want to show the ones that are between the one you just printed and the one you have now.  Either should work.

mlmcc
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
TarasAuthor Commented:
Is the sort order of Role groups as in DeclareVariables?
Should I remove sort order specified from my Group Sort order.
0
TarasAuthor Commented:
Thanks a lot.
0
TarasAuthor Commented:
clmcc
It is not working  I saw that your source file is sorted my query is not. I am getting some roles 2 times in a club some roles missing not showing on report??.
0
mlmccCommented:
For that to work they need to be sorted in ascending order.  If you have specified the order the testing will need to change.

Try using <> in the test

The Array values MUST be in the order you expect them to appear on the report

mlmcc
0
TarasAuthor Commented:
My ClubRoles Have diferent names not Role1, Role2
0
mlmccCommented:
Change the array value list to be the names of your roles

mlmcc
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.