I just followed the instructions above and it worked for me also.

First this: https://msdn.microsoft.com/en-us/library/hh213130%28v=sql.110%29.aspx

Followed by the 2nd post above. I was missing the step about COM...

I'm getting the same error on A SQL 2012 SP1 instance with a large ETL Merge statement.

Adding ORDER BY made no difference, but adding select DISTINCT seemed to get around...

If you double click on a measure in Visual Studio a window pops up called "Edit Measure"

The window has 3 controls(?)

Usage: "Count all rows" is selected in the drop...

Hi.

That doesn't sound good. :blink:

Personally I'd be trying to restore the file to a working version rather than trying to fix it. Do you have a backup of the...

mister.magoo (3/16/2014)

---

You could inspect the CLR with a tool such as ILSpy,

but it looks like it is working out the number of ten millionths of a second since 1/1/0000...

Great thread.

This gave me the hint to run the executable from the command line. Took me a while to find it and figure it out but I got there.

For...

Thanks for your reply Jeff.

You are absolutely right. I found the answer myself, by thinking "they must do this.. I wonder if they have already a function for it?" I...

Woohoo!!! I think I have it sorted. 😀

Here's my query:

SELECT NON EMPTY { [Measures].[Actuals], [Measures].[Forecast] } ON COLUMNS,

NON EMPTY lastperiods(3,exists([Financial Periods].[Financial Periods].[Financial Year].members,[Financial Periods].[Financial Year Status].&[Current]).item(0))...

I'm still thinking in SQL terms.. and so what I want to do is this... in MDX... (I know the syntax below won't work but im just trying to illustrate...

I had a simlar experince using an MS-Access front end that worked well on one server and terrible on another.

I spent hours trying to figure out the difference. In my...

Hi

I had a similar problem, with the same error message, and found it was caused by a corrupted reportserver.config file.

I have described what I found and how it looked...

Thanks for that. I'll have a read. 🙂

Found the answer...

I changed the database compatibility from 2000 to 2008 and it now works. :blink:

Carolyn Richardson (1/24/2008)

---

There is a simpler way, by default reporting services are installed using English (United States) as the default date format adjust the Report properties language to English (United...

Hi.

I've just done the Microsoft SSRS training course, and now that I'm back an work I'm trying to put a few things into practice.

I've downloaded the Adventureworks2008R2 and AdventureWorkDW2008R2...