Archive for the ‘Microsoft Word’ Category

15 Things Sunset Reports can do with Microsoft Office

February 8, 2014 Leave a comment

If you are a Microsoft Office user, you will be interested to know that Sunset Reports can:

  1. connect to Microsoft Access databases
  2. replace the query designer in Access
  3. replace the report designer in Access
  4. import report designs from Access
  5. connect to Microsoft Excel worksheet ranges as a data source for reports
  6. import Excel worksheet ranges as report designs
  7. export reports to Excel
  8. import Microsoft Word documents as RTF files into a report design
  9. export reports to RTF files that can be loaded into Microsoft Word
  10. distribute any Microsoft Office file as part of a report definition utilizing the queue and delivery service.  This includes Word, Excel, Powerpoint, Visio, Project, etc.
  11. create reports from Outlook data.   If you have synchronized your Outlook with iCloud, you can create reports from iCloud data.
  12. using OneNote, link to a report file
  13. using OneNote, attach a report file
  14. using OneNote, insert a report printout
  15. integrate with InfoPath to create a custom application

So if you are working with Microsoft Office, Sunset Reports is a great add-on.

Report Templates from Office

April 20, 2012 Leave a comment

If you use Microsoft Word or Microsoft Excel, you have access to many templates.   These templates can be imported into Sunset Reports as a starting point for reports.

For Word, create a document from a template, and save the document as an RTF file.   Then import the RTF file into the RTF control in the report designer.

For Excel, use the import report design from Microsoft Excel menu item when in the Report Designer.

Import Word Documents

June 14, 2011 Leave a comment

Another hidden gem in the report designer of Sunset Reports is the RTF control. The control is like the label control to display text, but you can also apply formatting to any part of the text. Formatting includes anything you can set for a font. But this control does a lot more. You can import an RTF or HTML file. This means, if you created a document in a word processor like Microsoft Word, and saved it as an RTF file, you can then import it into this control when you design your report. And it will import character and paragraph formatting, bulleted and numbered lists, images, tables, and more. And once you have imported it, you can edit the contents if you want. There is also a field replacement feature for mail merge or whatever your report needs.

Categories: Features, Microsoft Word