Look Ahead
Hello,
I am trying to use a look ahead calculated field in the detail band (either
ppVar or ppDBCalc) to make a determination of whether a group will contain
more than one record. If it does, I need to enable the visibility of a
horizontal line divider within each detail band of that group. If the group
has only 1 record, I need to disable visibility. I am counting a particular
field in the detail band.
My problem is, that even though the look ahead variable displays a count
greater than 1, the first record in the group has the divider line disabled.
The remainder of the lines in that group has the lines enabled.
I hope I've described my problem well enough.
--
Michael Malinowski
GIS Ltd.
I am trying to use a look ahead calculated field in the detail band (either
ppVar or ppDBCalc) to make a determination of whether a group will contain
more than one record. If it does, I need to enable the visibility of a
horizontal line divider within each detail band of that group. If the group
has only 1 record, I need to disable visibility. I am counting a particular
field in the detail band.
My problem is, that even though the look ahead variable displays a count
greater than 1, the first record in the group has the divider line disabled.
The remainder of the lines in that group has the lines enabled.
I hope I've described my problem well enough.
--
Michael Malinowski
GIS Ltd.
This discussion has been closed.
Comments
Personally I would create a summary dataset that keeps track of how many
records are in a group of data and use that summary dataset as a lookup
table to determine whether the horizontal line is visible or not.
If this solution will not work for you... you can check out the following
example. This example uses a two pass report to calculate the percentage of
the grand total before the report has been completely generated. You could
do something similar by finding out how many records are to be printed
before the report finishes and use that to determine whether you need the
line or not.
http://www.digital-metaphors.com/tips/UseLookAheadValueInCalc.zip
--
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Michael Malinowski