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
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
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
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.
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
I have to check your new solution.
ASKER
That is just what I did and is not working.
ASKER
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.
I am going to check orders and spellings again.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
I corrected it still the same.
ASKER
Thanks a lot mlmcc for you help and patient.
You are master.
You are master.
ASKER
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
You can use the "Request Attention" link and ask to have the question re-opened.
James
ASKER
Thanks James, yes you are wright I made mistake.
ASKER
thanks a lot
Crystal Reports
Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.
36K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
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