Hi Brain, Apologies for the confusion, and thanks so much for answering. This is a legacy system which i have inherited. Will try to  answer your queries.

Reading the error,...

• This reply was modified 8 months, 2 weeks ago by  rogue1009.
• This reply was modified 8 months, 2 weeks ago by  rogue1009.

As always i posted this and i figured it out. LOL

You need to select the correct measure group to show the missing measures assigned with a group.#

Believe this is now sorted, thanks Phil

Sorry,  about that this has me really confused and should have explained it better.

Ok so my table of data looks like the below

I need my query to...

Thanks everyone sorted now

Thanks for getting back to me.

What I meant was, if i set user a as the specified credential is it given  db_ddladmin role on the database automatically.

In answer to the question:

Out of interest, if you have administrated an SSRS server before, the reports seem to be neatly grouped within folders, therefore is it common to apply...

Also just found this online

select u.UserName, r.RoleName, r.Description, c.Path, c.Name

from dbo.PolicyUserRole pur

inner join dbo.Users u on pur.UserID = u.UserID

inner join dbo.Roles r on pur.RoleID = r.RoleID

inner join dbo.Catalog c on...

Look at the following tables in the reportserver DB and these should give you the information you need:

Execution log - Tells you who had run what. (this is defaulted to...

I have used power bi and SSRS side by side. My opinion is that most businesses see Power Bi as an evolution of reporting, and I will admit it is...

• This reply was modified 2 years, 8 months ago by  rogue1009.