report has toomany spaces

N

nydia

There is a survey that goes out every year to our
employees and i created a dba that will run reports based
on the data (ex. do you like working here 33agree,
22disagree)

i created a report that is grouped by question #, so it

question NO. 1, do you like working here
22 disagree
10 disagree
32 total answers
comments from question NO.1


the problem i am having is that not all employees put a
comment, so when the report runs it shows a bunch of
spaces inbetween each comment. if employee 1 and 10 put a
comment in the report employee 1's comment shows then a
big space, then employee 10's comment. how can i have all
the comments below eachother??
 
M

Marshall Barton

nydia said:
There is a survey that goes out every year to our
employees and i created a dba that will run reports based
on the data (ex. do you like working here 33agree,
22disagree)

i created a report that is grouped by question #, so it

question NO. 1, do you like working here
22 disagree
10 disagree
32 total answers
comments from question NO.1


the problem i am having is that not all employees put a
comment, so when the report runs it shows a bunch of
spaces inbetween each comment. if employee 1 and 10 put a
comment in the report employee 1's comment shows then a
big space, then employee 10's comment. how can i have all
the comments below eachother??
Click to expand...


Set the comments text box and the Detail section's CanShrink
property to Yes.
 
Top