Ask Your Question
1

Export a report from Base

asked 2015-02-25 21:27:46 +0200

otterit gravatar image

updated 2018-10-28 09:31:10 +0200

EasyTrieve gravatar image

Is there any way to export a report from Base to .rtf or .cvs?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
1

answered 2015-02-26 08:44:43 +0200

pierre-yves samyn gravatar image

Hi - Two other ways:

"Save As" the report

  1. Right click the report> Open (the report opens "read only")
  2. File> Save As, choose the format you want (RTF, TXT, etc.)

Modify the output format

  1. Edit your report,
  2. Use the report navigator to select the first entry (Report)
  3. The Properties> Data tab allow to select Text or Spreadsheet
edit flag offensive delete link more
1

answered 2015-02-26 04:51:19 +0200

doug gravatar image

updated 2018-10-28 08:57:45 +0200

EasyTrieve gravatar image

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

edit flag offensive delete link more

Comments

Fixed HSQLDB link.

EasyTrieve gravatar imageEasyTrieve ( 2018-10-28 08:58:14 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2015-02-25 21:27:46 +0200

Seen: 265 times

Last updated: Oct 28 '18