control layout on a report at runtime

[Guest]

Hi all,

on my report, I display a combination of clientname/year/indicator, and I
only want to display comment at the first line of a year like following:

clientA 2002 indicator1 comment for clientA
clientA 2002 indicator2
clientB 2002 indicator3 comments for ClientB
clientB 2003 indicator4 continued comments for
clientB 2004 indicator5 ClientB

How can I do it? Can I go further to make a comment overlap different lines
in its own column?


Clara

thank you so much for your help

 

[Al Campagna]

Clara,
I assume that a Comment stays the same for the year, so in the case of ClientA 2002 you
would see 2 lines of "comment for clientA"
You should be able to set the HideDuplicates for Comments to Yes.
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

 

[Guest]

Hi Al,

Thank you very much. Comments are usually a little longer, so it should span
several rows to display whole contents. Beacuse a comment is same for a
year, after i erase the duplication, there will be some space below the
comment column corresponding to the same year, how can I make use of that
space.
like the following: CommentLine + CommentLine2 + CommentLine3 is the whole
content of a comments.


clientB 2002 indicator3 CommentLine1
clientB 2002 indicator4 CommentLine2
clientB 2002 indicator5 CommentLine3

if I use the Can Grow, whole content will be displayed but there will be a
blank line between clientB 2002 indicator3 and clientb 2002 indicator4
How can I include the whole comment without incurring the extra blank line?

Clara
thank you so much for your help