You are not logged in.
Dear users of this forum,
we are pleased to inform you that we will be updating the software behind this forum in the near future.
Existing posts, users and categories will remain untouched.
Important:
We will keep you informed in the pinned thread.
Kind regards,
Your ReportServer Team
Liebe Nutzer dieses Forums,
wir freuen uns, euch mitteilen zu können, dass wir in naher Zukunft die Software hinter diesem Forum aktualisieren werden.
Existierende Beiträge, Nutzer und Kategorien bleiben weiterhin bestehen!
Wichtig:
Wir halten euch im angepinnten Beitrag auf dem Laufenden!
Mit vielen Grüßen
Euer ReportServer Team
Pages: 1
I have multiple queries and I would like to set the default alias and description in order to assist my users select the right data. Can this be accomplished through "Metadata datasource properties" or otherwise?
Ideally I want to describe on the schema somewhow what each column represents instead of every query... is that possible?
Offline
Hi George,
to set the default alias/description you need to configure the metadata datasource for the report. (there is currently no way to have a global specification that is used for every dynamic list.) The metadata datasource expects as result a table containing three columns,
column name, default alias, default description.
For example, using a mysql datasource you could use a statement such as
SELECT 'TheColumnA', 'Some Default Alias', 'some description' FROM DUAL
UNION
SELECT 'TheColumnB', 'Some Other Alias', 'some description' FROM DUALDoes this answer your question?
Cheers
-Arno
Offline
Pages: 1