K
K. Morris
I am creating a report which is based on a simple query.
The report has 5 grouping levels. In the 4th grouping
level header, I want to do some text manipulation to a
field.
What I want to do is this: =Right([Requirement Type],Len
([Requirement Type])-10) This should take the first 10
characters off the start of the field 'Requirement Type'.
However, when I do this, it does not work correctly. To
troubleshoot this, I tried entering just =[Requirement
Type]. When I did this, a field used in the 3rd grouping
level was displayed as the result.
With no modification, the report works as desired..
1,2,3,4,5. However, once I use any '=...' expression in
the 4th level, the grouping stays 1,2,3,4,5, but the
field used in the 4th level is changed, which gives the
grouping an appearance of 1,2,3,3,5.
The 3rd level consists of 2 fields, one with no
manipulation, and one with a simple =IIf([Field]
=0,"Summary",[Field]), which substitutes Summary if 0 is
present in the field. In fact, something I just realized
now is that it is not the 3rd level field that is being
erroneously entered in the 4th level. It is the result of
the 3rd level IIf statement that gets put into the 4th
level, if I use any '=...' statement in the 4th level. I
can think of no reason why this behavior should occur.
I realize this is probably a little unclear. If anyone
needs clarification or more information, please ask.
The report has 5 grouping levels. In the 4th grouping
level header, I want to do some text manipulation to a
field.
What I want to do is this: =Right([Requirement Type],Len
([Requirement Type])-10) This should take the first 10
characters off the start of the field 'Requirement Type'.
However, when I do this, it does not work correctly. To
troubleshoot this, I tried entering just =[Requirement
Type]. When I did this, a field used in the 3rd grouping
level was displayed as the result.
With no modification, the report works as desired..
1,2,3,4,5. However, once I use any '=...' expression in
the 4th level, the grouping stays 1,2,3,4,5, but the
field used in the 4th level is changed, which gives the
grouping an appearance of 1,2,3,3,5.
The 3rd level consists of 2 fields, one with no
manipulation, and one with a simple =IIf([Field]
=0,"Summary",[Field]), which substitutes Summary if 0 is
present in the field. In fact, something I just realized
now is that it is not the 3rd level field that is being
erroneously entered in the 4th level. It is the result of
the 3rd level IIf statement that gets put into the 4th
level, if I use any '=...' statement in the 4th level. I
can think of no reason why this behavior should occur.
I realize this is probably a little unclear. If anyone
needs clarification or more information, please ask.