Ask Your Question
0

Base FormFilter-Result Export?

asked 2017-04-27 12:55:48 +0100

cool gravatar image

Hallo, I have filtered my data. How to export the filter-result to calc? Thanks

edit retag flag offensive close merge delete

3 Answers

Sort by » oldest newest most voted
0

answered 2017-04-28 03:14:55 +0100

EasyTrieve gravatar image

updated 2017-04-28 03:15:53 +0100

You're grabbing and dropping a Form's Table Control. Try grabbing and dropping a Query (from the icon to the left of the name of the query). I think this will give you what you want.

You will have to build your query to show the looked up values, not the keys (i.e. relate the tables in the query).

edit flag offensive delete link more

Comments

Hi, I use a form-based filter, not a query.

cool gravatar imagecool ( 2017-05-02 09:15:38 +0100 )edit
0

answered 2017-04-27 14:07:57 +0100

cool gravatar image

updated 2017-04-28 03:11:36 +0100

EasyTrieve gravatar image

Hi, "Keep the left click and drag-and-drop in Calc" works! But the result does not look the same, see screenshot -> https://www.dropbox.com/s/46g8g7iwyly...

Bauart_fk in base shows the name, in calc it shows the foreign key number.

edit flag offensive delete link more

Comments

@cool Does the data come from a subform?

pierre-yves samyn gravatar imagepierre-yves samyn ( 2017-04-27 14:35:32 +0100 )edit

Yes, from other table.

cool gravatar imagecool ( 2017-04-27 14:39:25 +0100 )edit
0

answered 2017-04-27 13:29:44 +0100

pierre-yves samyn gravatar image

Hi

Click Data Source as Table tool in Form Navigation toolbar: this opens a pane that displays the table data. Click at the intersection of the row and column headers to select all records. Keep the left click and drag-and-drop in Calc.

Regards

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

Stats

Asked: 2017-04-27 12:55:48 +0100

Seen: 67 times

Last updated: Apr 28 '17