ReportServer Forum

georgeCh

Member

Registered: 2014-11-12

Default alias / Description

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?

Arno Mittelbach

datenwerke

Registered: 2012-02-14

Re: Default alias / Description

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 DUAL

Does this answer your question?

Cheers
-Arno