report has toomany spaces

  • Thread starter Thread starter nydia
  • Start date Start date
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??
 
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.
 
Back
Top