Cascading Labels and data controls
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
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
This discussion has been closed.
Comments
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.
--
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
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...
Your request has been logged. Thanks for the suggestion.
--
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com