Crystal Report show group with no records

Taras
Taras used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
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
Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
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

Author

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.
Exploring SharePoint 2016

Explore SharePoint 2016, the web-based, collaborative platform that integrates with Microsoft Office to provide intranets, secure document management, and collaboration so you can develop your online and offline capabilities.

Author

Commented:
I have to check your new solution.

Author

Commented:
That is just what I did and is not working.

Author

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.
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

Author

Commented:
I corrected it still the same.

Author

Commented:
Thanks a lot mlmcc for you help and patient.
You are master.

Author

Commented:
It worked but i needed to change it in both formulas!!
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

Author

Commented:
Thanks James, yes you are wright I made mistake.

Author

Commented:
thanks a lot

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial