Contents
- Index
Working in Exported Reports (Tips)
Excel:
Reports that have complicated groupings come into Excel with what looks like extraneous columns. You will notice report headers and footers make up extra rows. Simple copy the "core data" to a new sheet or delete these extra column and rows till your data looks easily manageable.
Sometimes, exporting a report to an RTF document, then pasting the core data into Excel is easier.
Word:
After you have exported to Rich Text Format you will want to re-save your file as a .doc.
Why? Some users have settings in Windows where the window defaults to look for "Word" rather than "all." They will not see RTF documents and may not know why.
When you have your document in Word, you may find that the spacing looks off.
The easiest way to reformat all the spacing is to:
1. Get rid of headers and footers form the access report by selecting and deleting them.
2. Select all the remain text and under the Format Menu select Paragraph.
3. Go back into word and insert line breaks using enter between the sections where you want them.