Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

How to make same following values invisible

edited April 2011 in General
Hello,
I'm programming a Report, which shows me the bookings (Comming, leaving,
break, ...) for every day in a month like this:
Date Bookings What? Hours of Working extra work
01.04.2011 Fr 15:00 - 16:00 Work 01:00 1,00 -07,00 -7,00
02.04.2011 Sa
03.04.2011 So
-----------------------------------------------------------------
04.04.2011 Mo
05.04.2011 Di
06.04.2011 Mi 08:00 - 13:00 Work 08:00 8,00
13:00 - 14:00 Break
14:00 - 17:00 Work
07.04.2011 Do 09:00 - 18:00 Work 09:00 9,00 01:00 1,00

My question is, how can I implement, if I have more bookings on a day,
that only the first date in my case 06.04.2011 will be shown, the others
dates should be hide.

Regards David Wolf

Comments

  • edited April 2011
    Hi David,

    Try setting the SuppressRepeatedValues property of the DBText that holds
    the date to True.


    Regards,

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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited April 2011
    Hi Nico,
    First I delete all code out of my variable. There is now only Value :=
    DataPipeline1['Date']
    After this I set the proberty SuppressRepeatedValues (True) of the variable.
    But when I run my report only the 01.04.2011 is shown, all other dates
    are invisible. Thats the first problem.
    The second problem is, how can I check in a variable if the next value
    is the same, to make some values invisible
    if I ask, "if variable1.SuprresRepeatedValues = True then
    begin
    Date.Visible := false;
    Hours of Working.Visible := False;
    extra work.Visible := False;"
    it won't be work, because in this case I check only, if the Property is
    true?
  • edited April 2011
    Hi David,

    Which version of ReportBuilder and Delphi are you using? The
    Variable.SupressRepeatedValues feature is working as designed with the
    latest version.

    I'm a bit unclear about why you are using a TppVariable in the first
    place. Why not simply assign the Date field to a DBText with
    SuppressRepeatedValues set to True. The same could be done for any
    other fields you wish to suppress.


    Regards,

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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited April 2011
    Hi Nico,
    now I use a normal DBlabel which shows me the date.
    The SuppressRepeatedValues property works fine.
    Further on I don't know how to set the working hours and the extra work
    invisible, if the date is the same as the prior date value.

    Regards David
  • edited April 2011
    Hi David,

    Are these values the same as well? If so, the SuppressRepeatedValues
    property should work for them too. ReportBuilder does not have a
    built-in feature to hide multiple components based on a single value
    repeating. In order to do this you will need to perhaps take complete
    control over the hiding of the components based on the previous value of
    a field.


    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.