Crystal Report show group with no records

I attached here source file that report is based on. Two groups are present first group is Club and second group is Club_Role.
One club could have up to 10 club roles.
My real name of  groups is different than in the attached file,  this is just example. In my case every club role has different name not Role1, Role2 ….
Club_ Role group could have more members, and report layout should be with two detail columns.
I need to show club role even if no member is in that group. Club_ Role group should be sorted on specific order.
Q-28230032-adjusted.xls
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:
Why are you asking this again?

The method I gave you in the other question should work so long as you put the club role values in the correct order.

mlmcc
0
mlmccCommented:
Therre was a minor error in the original solution.  I have fixed it and it now works for specified order.

I used specified order of
1,3,5,7,9,10,8,6,4,2 for the roles

mlmcc
Q-28230032-Adjusted-DataSpecifie.rpt
Q-28230032-adjusted.xls
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:
mlmcc
It is not working.

 I checked sort order in group Club_Roles and  order in variable DeclereVariable. All items match. I did this several times.
I put club roles values in array the same order as I sorted Club_Roles  group in specified order.

 In  selection expert I have criteria to select only those club roles as they are in array.

To test CurrentRole index I put a test CurrentRoleIndex in ClubRoles_a  section(section for dummy Club_Roles titles).
I expected that it’s values should go from 1 to 10 as there 10 club_roles in array var.
I pick up one a particular Club that have eight roles 1 4,5,6,7,8,9,10.
Club_Role2  and Club_Role3  are not present.

 In report I have  proper records and group title for Club_Role 1.
Club_Role2 - dummy title is not shown  at all and no CurrentRoleIndex there.
Club_Role3 dummy title is shown ok. Forth group and rest are ok.
However CurrentRoleindex in Dummy title for Club_Role 3 showing  4.
I think something is wrong with re-setting this index.
0
Introduction to Web Design

Develop a strong foundation and understanding of web design by learning HTML, CSS, and additional tools to help you develop your own website.

TarasAuthor Commented:
I have to check your new solution.
0
TarasAuthor Commented:
That is just what I did and is not working.
0
TarasAuthor Commented:
It looks that it should work but is not working. I am getting out of my mind.
I am going to check orders and spellings again.
0
James0628Commented:
There's an error in @DislayMissingTrailingGroups.  The first line in the While is:

   strOut := Space(8) + ClubRolesList[CurrentRoleIndex] & chr(13);


 It should be:

   strOut := strOut + Space(8) + ClubRolesList[CurrentRoleIndex] & chr(13);


 Without that change, you only see the last missing trailing value.

 James
0
TarasAuthor Commented:
I corrected it still the same.
0
TarasAuthor Commented:
Thanks a lot mlmcc for you help and patient.
You are master.
0
TarasAuthor Commented:
It worked but i needed to change it in both formulas!!
0
James0628Commented:
You probably meant to give the points to mlmcc, since he provided the formulas.  I just made a correction to one of them.

 You can use the "Request Attention" link and ask to have the question re-opened.

 James
0
TarasAuthor Commented:
Thanks James, yes you are wright I made mistake.
0
TarasAuthor Commented:
thanks a lot
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.