Is there any way to export a report from Base to .rtf or .cvs?
In Tools
→ SQL
execute the following command:
SELECT * INTO TEXT "Filename" FROM "Table1"
SET TABLE "Filename" SOURCE OFF
Creates a csv with the name Filename
in the documents directory. See HSQLDB reference. h/t pausas@OOforums
Fixed HSQLDB link.
Hi - Two other ways:
“Save As” the report
- Right click the report> Open (the report opens “read only”)
- File> Save As, choose the format you want (RTF, TXT, etc.)
Modify the output format
- Edit your report,
- Use the report navigator to select the first entry (Report)
- The Properties> Data tab allow to select Text or Spreadsheet