Avatar of Taras
TarasFlag for Canada asked on

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
Crystal Reports

Avatar of undefined
Last Comment
Taras

8/22/2022 - Mon
Mike McCracken

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
ASKER CERTIFIED SOLUTION
Mike McCracken

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
Taras

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

I have to check your new solution.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
ASKER
Taras

That is just what I did and is not working.
ASKER
Taras

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.
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
Taras

I corrected it still the same.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
Taras

Thanks a lot mlmcc for you help and patient.
You are master.
ASKER
Taras

It worked but i needed to change it in both formulas!!
James0628

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
Your help has saved me hundreds of hours of internet surfing.
fblack61
ASKER
Taras

Thanks James, yes you are wright I made mistake.
ASKER
Taras

thanks a lot