ReportServer Forum

aditi.raiter

Member

Registered: 2018-05-01

Metadata in a DL

Hi Eduardo

Is it necessary for a report (DL) to be of the below form to add metadata

Select * from my_table

I have a report of the form

Select * from
( Select OD.column1,
OF.column2
From OD
JOIN OF on ...
)

When I use metadata in the below form, applying metadata on the report does not update although it says report updated.

COLUMN_NAME; DEFAULT_ALIAS; DESCRIPTION
OD.column1; Extraction Time; When the data was extracted

When I refresh the report after applying, the above column_name information is deleted.
No wonder, the report ends up throwing at me a Null Pointer exception on running, as there is no data information

The metadata data source is of the form -
Quotes "
Separator ;
and Argument connector.

How do I let the below information stick to the data textbox when applied?
COLUMN_NAME; DEFAULT_ALIAS; DESCRIPTION
OD.column1; Extraction Time; When the data was extracted

Last edited by aditi.raiter (2020-05-05 22:35:27)

aditi.raiter

Member

Registered: 2018-05-01

Re: Metadata in a DL

It works the other way using a Datasource -  https://reportserver.net/en/guides/admi … amic-List/

The intent was to see if the columns can be cached. So that select columns screen does not take minutes to load for my sql.

With the metadata data source approach, it does take a while to populate the select columns screen.

Last edited by aditi.raiter (2020-05-05 22:30:19)

aditi.raiter

Member

Registered: 2018-05-01

Re: Metadata in a DL

Variants seem the only option to cache select parameters

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Metadata in a DL

Hi aditi.raiter,

I don't quite understand the problem.

Can you please some screenshots e.g. by http://imgbb.com ?

Regards,
Eduardo