SuppressRepeatedValues

rbuser

Hi,

I have a very simple report that displays customers.
For every customer (per page), the date of an order and the quantity of the
order is displayed.
This date and quantityfields I put in the detailband of the group
"Customers".

Because a customer can have more then one orders, I set the
"SuppressRepeatedValues" on the DBText of the order date to True (checked).
This way, the date is only shown once for every order.
Like this :

Customer A
date quantity product
04/11/2009 4 x
1 y
2 z
05/11/2009 1 x
NEW PAGE----------------------------
Customer B
date quantity product
04/11/2009 4 x
1 y
2 z
05/11/2009 1 x
NEW PAGE----------------------------
Customer C
date quantity product
04/11/2009 4 x
1 y
2 z
05/11/2009 1 x

The problem that I have is when setting the ReppressRepeatedValue settting
to True (checked) the report only has 2 pages.
Customer A and customer C.
The SQL that gets the data for the report returns data for all 3 the
customers! So I am missing a page for one customer (Customer .
This problem occurs only in combination of setting the ReppressRepeatedValue
to True and setting the property "NewPage" of the customer group to True
(because I want every customer on a new page).

Does anybody can tell me if I am doing something wrong or what I'm missing?

Thanx,

Johan

nicocizik

Hi Johan,

Which version of ReportBuilder and Delphi are you using? If you set the
SuppressRepeatedValues value to False, does the report output correctly
every time? If possible, please send a simple example I can run on my
machine that recreates 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