SuppressRepeatedValues fails in RB 11.0/Delphi 7

rbuser

Hi,

We just upgraded to RB 11.0 for use in our Delphi 7 environment. Our reports
converted fine from RB 10.09, but I noticed unusual behaviour in a few of
them.

It seems that the SuppressRepeatedValues property of a TppDBText field is
not handled properly: If set to TRUE, no output of the associated field
occurs at all. So, if we had a data pipeline providing two values, say
"Name" and "Score", and the values were:

John,5
John,8
John,11
John,3
Dave,10
Dave,14
Dave,12
Dave,190

A simple report listing names and scores, with SuppressRepeatedValues set to
true for "Name" should result in:

John 5
8
11
3
Dave 10
14
12
190

However, it results in:

5
8
11
3
10
14
12
190

With no output at all of the field that has SuppressRepeatedValues set. I
have confirmed this with a simple stand-alone test report with a two-field
data pipeline from a text file, and can provide the source as needed.

Can you reproduce this, and, if so, do you have a workaround or patch for
this?

Thanks,


John Bennett,
ThoughtWorks

nicocizik

Hi John,

There is now a patch available that fixes this issue. Please send a small
email to support@digital-metaphors.com requesting the patch and we'll send
it to you as soon as possible.

--
Regards,

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

rbuser

Hi, Nico,

Thanks for the patch. The new unit now works correctly in some
circumstances, but seems to fail on columnar reports. I have a multi-column
report, with the first field marked as SuppressRepeatedValues. The field is
*not* suppressed on the first row of a multi-column report. But it is
properly suppressed on subsequent rows.

To make it more clear: I have a seven-column calendar report, with an
employee name being repeated across columns. The employee name is marked as
SuppressRepeatedValues. It should result in the employee name only being in
the first column, and did so in RB 10.09. The correct report looks like:

Mon Tue Wed Thu Fri Sat Sun
John
6 hrs 3 hrs 1 hr 9 hrs 4 hrs 2 hrs 1 hr
Dave
6 hrs 3 hrs 1 hr 9 hrs 4 hrs 2 hrs 1 hr
Jo-Anne
6 hrs 3 hrs 1 hr 9 hrs 4 hrs 2 hrs 1 hr



In RB 11, we get the first row's entries non-supressed, resulting in:

Mon Tue Wed Thu Fri Sat Sun
John John John John John John John
6 hrs 3 hrs 1 hr 9 hrs 4 hrs 2 hrs 1 hr
Dave
6 hrs 3 hrs 1 hr 9 hrs 4 hrs 2 hrs 1 hr
Jo-Anne
6 hrs 3 hrs 1 hr 9 hrs 4 hrs 2 hrs 1 hr

Notice the first occurence of the repeated, suppressed field ("John") is
incorrectly treated as not-supressed. The remaining occurences are
suppressed.

Any ideas or patches?

Thanks,

John Bennett

nicocizik

Hi John,

In my quick testing with the patched code I was unable to recreate this
issue.

If possible, please send a simple example that demonstrates this issue in
.zip format to support@digital-metaphors.com and I'll take a look at it for
you.

--
Regards,

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

rbuser

Hi, Nico,

I did some further testing, and it seems that I had inadvertently set the
ReprintOnSubsequent property of the field that was repeating, in addition to
the SuppressRepeatedValues. I have unchecked the ReprintOnSubsequent
property, and the report works fine.

Thanks for your quick responses to my questions.

John