Unusual grouping problem

rbuser

I have a situation where I'm grouping my report on a calculated field. The
calculated field is the result of concatenating two string fields together,
like this:

Field_One String 6 (DB type = CHAR(6))
Field_Two String 3 (DB type = CHAR(3))
Group_Field String (Field_One || Field_Two)

My problem is that when the value of Field_One changes, and the starting
character goes from an alpha character ('a'..'z', 'A'..'Z') to a numeric
character ('0'..'9'), the group does not break correctly. Here's an example:

Group_Field = 'ALPHA1'
== ^ Group Header[0]: Group_Field =============
Details related to 'ALPHA1' (a subreport)
== ^ Detail ===================================
Summary for 'ALPHA1' (a subreport)
== ^ Group Footer[0]: Group_Field =============



Group_Field = 'ALPHA2'
== ^ Group Header[0]: Group_Field =============
Details related to 'ALPHA2'
Details related to '200'

Group_Field = '200'
== ^ Group Header[0]: Group_Field =============
Details related to '200' do not appear here

This is with RB 6.03 and Delphi 4.02, accessing data on an AS/400 via IBM's
Client Access ODBC driver (and the BDE).

Does anyone know why this is occurring? If my example is not clear enough,
I'll be happy to send a PDF that shows the problem, along with anything else
that may be helpful in finding the trouble.

Thanks a lot!
Jef Duncan

nicocizik

Hi Jef,

I am having a bit of a hard time understanding what is happening. Would it
be possible for you to create a small Delphi example demonstrating the
problem along with a description of how you would like your report to look
to support@digital-metaphors.com?

--