getting all data to fit in report, and calculating averges in repo

D

devon

Questions Below:

I have a report set up:
author
title
publication_year
unitprice
copies
departmentID

grouped by department ID

with author ascending
title:publication_year ascending
publication_year descending

Here's my questions?
can someone tell me how to fix my so all data is visible. Right now I have a
report created where I have a column entitled titles and I can't seem to fit
the entire titles on the screen.

Secondly,

how would I calculate averges for each department
 
Top