As soon as you set anonymous on within your virtual directory, all windows authentication is ignored, it's like it checks anonymous first, sees it's on and then proceeds without any...

I think tis was a documented issue after uprading to SP3.  You may want to check the readme for the service pack/s that you've applied, or alternatively do a quick...

Check to ensure that you've got at least SP1 installed, and pref SP2 (these are the Reporting Services service packs, seperate to the SQL ones). 

Also, if you google the...

Assuming you're using visual studio (not command-line) right click on your project in the Solution Exploerer window, and select Properties.  Look for the 'TargetServerURL' property, ensure that this si set...

Have you tried putting only the measures on the columns and nesting (crossjoin-ing) your other dimensions on the rows? Keep in mind it will still come back as a flat rowset...

Hi Evan,

Sorry about the acronyms, I'm a lazy typer

NB means (something like) Note Benne, basically "Note Well" in English.

AS2K5 is Analysis Services 2005...

This earlier post has details on how to use IsNothing() and also the switch statement (scroll down to the reply from pg53).

Evan,

There's a few ways to do it, some a lot harder than others.

If you want, you can add Calculated Members to your Measures, so you will have a 'Previous Year...

Can you post both of your MDX queries for us to look at?

I would say you're close already, don't you just need to add *something* to be formatted to the Format function?  I can't remember the syntax but something like ="today is...

One thing to watch with the 'hh:mm.ss.nnn' approach, check your datatype first, if it's a smalldatetime, this will bite you because it only goes down to the minute - last...

Is it possible you have spaces (or other chracters) in your 'Sell' string?  I would be temtped to do the VB.net equivalent of a LTRIM(RTRIM(....Value)) over the value to ensure...

Thanks David for the information.  It's a bit worrying that the fix doesn't appeared to have fixed the problem.  We have many reports with many grouping sections, so I guess...

both properties should be set in the connection string.  If you're using excel, this will normally mean searching the 'Documents and Settings' directory (normally off your c:\) for *.oqy files. ...

You may want to look at your client cache size, and probably more relevant the 'LargeLeve' setting (both set on the connection string oth with defaults). You may not be getting...