You should be able to use lists.. By grouping the list by name or any other unique identifier for that row.

Regards,

C

Hi,

You can try dynamic query:

declare @id varchar(10) = '500107'

EXEC('SELECT { [Measures].[Amount] } ON COLUMNS, NON EMPTY {(DESCENDANTS([Customer].[Customer Hierarchy].[Level 03].[' + @id + ']) * [Date].[Date].[Day].ALLMEMBERS * [As of Date].[As...

Thanks 🙂

I guess its just a proxy issue then.

Cheers.

Hi,

I am currently working on a report that uses geographical data of UK. But I am unable to access the Bing Layer.

The question is.. Is Bing Layer in SSRS...