How to name the labels

hector.bastien posted 12 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 12 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 12 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 12 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 12 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 12 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 12 months ago

Thank you!! good idea

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