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

Cascading Labels and data controls

edited January 2004 in General
Is there an in built method of cascading labels up over top of empty data?

To be more specific. I have a query that returns a set of contact details
for a person. That person may have multiple sets of contact methods
however and I get a record set like this...

Type Primary
Phone 555 5555
Fax 555 5556
Email nosuchaddress@nosuchaddress.com

Type Secondary
Phone
Fax
Email nomorespam@ih8spam.com

In the second record there are two empty fields. No Phone and no Fax.
Thus I dont want them to print at all. And I should see this...

Type Primary
Phone 555 5555
Fax 555 5556
Email nosuchaddress@nosuchaddress.com

Type Secondary
Email nomorespam@ih8spam.com

With the email cascading back to the position once held by phone

I can do this by putting all the fields into a calc field - a single string
with #13#10 as a delimiter and then into a memo/richedit control which works
but I suspect is overkill. Surely there is inbuilt behaviour in report
builder to achieve this. It would be a very common task in reports....

Amb

Comments

  • edited January 2004
    Hello,

    Unfortunately there is no built in feature like the one you describe below.
    My suggestion would be to use TppMemo objects like in demo 33 (dm0033.pas)
    located in the \RBuilder\Demos\1. Reports\... directory. You could check if
    data actually exists before adding a line to each memo.

    --
    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited January 2004
    That will work fine.

    Is there anywhere this could be raised as a feature for next/newer versions
    of Report Builder. It would not be uncommon behaviour. A system I once
    worked on that used its own internally written report component had a method
    for it and it made life very easy - especially for list type reports...


  • edited January 2004
    Hello,

    Your request has been logged. Thanks for the suggestion.

    --
    Best Regards,

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