I dont know. How can I tell if its a Contained Database?

The database in in Azure and is a standard SQL Database

Thank you for that. For a start your expression is way better that the over complicated one I was using so its already quicker. And I definitely have less white...

I will certainly have a look at that. I didn't know you could use the Sql command when you are using an excel destination source. I thought you could only...

It will always be the same. I'm not quite sure where you would set that information though.

I have set all the reports to an interactive size of 0 which means that as you are looking at them in the browser they are as big as they...

It would appear that the order of the data sets is important.

I created the first on and tested

Then the next. For example making sure any drill downs of data reports...

Ah, all you need to do is the usual. Exec USP_AdminProc 'Test','Area' and it works.

How obvious. Thanks

Debbie

Ive got that set up. I have both my parameters

User::SP ...

As an extra to this. I made two brand new reports, very simple and added the demographics table and the drill down works fine. Its when you introduce more that...

Thank you.....

In the end I went with:

Fact table (FK) to Group Table (PK) to bridge table (FK using the parent ID) to Dimension table (PK)

I just used an example (Healthcare)...

I think I can definitely use that documentation to sort my problem out.

Great! Thank you

Debbie

Im talking about an SSRS report attatched to An Analysis Services Cube.

I thought I could sort the issue out in Analysis Services. the MDX query is built when you drag...

PB_BI (2/11/2015)

---

Well if the report is using the name (which is WCHAR) and ordering by it (I take it you are ordering in SSRS via the rendering) then it will...

Aghhhhhh How can a sort order be so hard.

I can confirm that if you look at the data item in Analysis Services it says int against it.

Name Column Service_SEN.Days_Between_Workflow_Start_and_Issued (Integer)

I...

Another failed attempt. 🙁

Over the Int source column in Analysis Services I applied a convert(int, in the analysis services data source. Updated everything in Analysis Services and Refreshed the Reports...