Grouping Issue

rbuser

Hi

I have a report with a group on an Employee code.
I Display the employees name in the header of the group.
In some cases, when the employees surname has the following characters:
O'LO
OLL

The second persons header does not display and the values for that employee
are lumped into the first employees details.

Does anyone know what could be causing this?

I am using D7 and this happens on RB7 and RB9.

Thanks

nicocizik

Hi Jason,

Are you grouping on a unique foreign key field? Also be sure you are
ordering your dataset on this field. ReportBuilder simply looks at the
grouping field and continues to print the group until the record changes in
the breaking field. For example...

ID EmpCode Name
1 100 John
2 100 John
3 100 John
4 200 Paul
5 200 Paul
6 300 George
7 300 George
8 400 Ringo

If your dataset is ordered on the EmpCode, the report will print a group for
each unique value.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Hi Nico,

The Data is correctly ordered and the group is on the EmpCode.
Can the pipeline make though when it comes to the grouping?

The pipeline is setup in master/details.

The data is ordered 100% correctly, it is just the result that shows on the
report that is weird.

Thanks.

nicocizik

Hi Jason,

If you are grouping on the EmpCode field, then the Surname should not have
an effect on the group. Are you certain that the data entries with O'LO and
OLL have unique EmpCode entries? Take a look at Demo 61 in the
\RBuilder\Demos\1. Reports\... directory (dm0061.pas). How does your setup
differ from this demo (master-detail with groups)?

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Hi Nico,

I an 100% certain that the codes are different.
I will have a look at the demo and see what I find.

Thanks for all the help.

rbuser

Hi Nico,

I have had a look at the Demo.
What we have in our report is the master detail setup in the Pipeline, not
in the data source itself.
What sort of difference does this make?
Currently, we have to reorganise the pipeline master detail setup when we
change the sort order in the report.
Could this be what is causing the problems?

Thanks.

nicocizik

Hi Jason,

The pipeline linking should not have an effect as long as your detail
dataset is ordered on the linking field. Are you grouping on a field in the
detail or master dataset? Which field are you linking your master and
detail datsets with?

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Hi Nico

I am linking on the employee code and the name that is in both the master
and detail datasets.
Both datasets are ordered the same.

nicocizik

Hi Jason,

From your descriptions, everything should be working correctly. We have no
known issues of this kind currently in ReportBuilder. Take a look at the
example below which successfully creates a group in a master-detail report
using datapipeline linking. Perhaps you can compare this to your setup and
alter it to cause an error.

http://www.digital-metaphors.com/tips/MasterDetailGroupingTest.zip

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

I Will try,

Thanks for all your help Nico