How to name the labels

hector.bastien posted 3 months ago in General

Hello.

I was wondering if there is a way to name the labels on a multiple query result. I attach an image.

1 attachment(s):
  • Screenshot_2
ansgar posted 3 months ago

The tab captions get the name of the table name, if there is any. In all other cases they get automatically named ("Result x").

hector.bastien posted 3 months ago

The tab captions get the name of the table name, if there is any. In all other cases they get automatically named ("Result x").

But what can I do if I want to name the tab with "result X"? nothing? :(

ansgar posted 3 months ago

Correct, you can't rename it. But why would you want to do that? It's a temporary tab caption, nothing which gets stored afterwards.

hector.bastien posted 3 months ago

Correct, you can't rename it. But why would you want to do that? It's a temporary tab caption, nothing which gets stored afterwards.

Well... There is a report that has to be sent everyday and there are between 5 and 8 employees in charge of that but they have no idea about SQL. I give them the query and they only changes dates, copy and paste to excel and send it. The report has about 6 o 7 labels and they always have problems to remeber where to paste the info, I want to name the labels on Heidi and Excel with the same name to solve it.

ansgar posted 3 months ago

You could write the results to a named temporary table before selecting it:

CREATE TEMPORARY TABLE foobar SELECT ...;
SELECT * FROM foobar;

That would give the tab the caption "foobar".

hector.bastien posted 3 months ago

Thank you!! good idea

Please login to leave a reply, or register at first.