Home General

SuppressRepeatedValues

edited May 2010 in General
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 B) .
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




Comments

  • edited May 2010
    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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.