You could try casting the numeric measure to a string and then appending, e.g.

CStr([Measures].[MyMeasure]) & "%"

You may also want to skim through the Operations guide (http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx) .You may also get some ideas from the Performance Guide (http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ansvcspg.mspx)

From our point of view, disk space...

Firstly, I've not done this on a 64bit server, hey, i haven't done this on a 32 bit machine either.  But, from info gleaned from the Ops Guide (thanks Dvae...

What was the exact problem with your left outer join attempt?  If you had two tables, one containing a claendar the other the transactional data, then your approach should work. ...

Hey Wajih,

THe 'WHERE' is a little different in MDX when compared to the of TSQL.  You need a tuple in the where clause, so based on what you've posted so...

Hi Jan,

Based on your screenshot3, I'd be a bit concerned - I can't see an entry there for Reporting Services, in fact, I have exactly the same list as you...

Forgot to mention, in case you need it later (or want to stick with dynamic sql with this one), instead of using the nested Iif's, you coudl try a switch...

Hey Greg,

Not sure why i missed this but you could make this a lot simpler by using 'OR' statements.

it's no longer a dynamic sql statement, it's back to standard sql,...

you could try dynamic sql...sooo, sort of like the following...  Note that I've assumed you're talking string parms so have single quoted them accordingly.  Either approach below will work, probably...

Just a quick follow-up, i just dialled into a work server, it's set to 100 also.  What does your sp-help_category return as valid category values?

Hey jan,

I see you've posted this around a bit

Have you tried tracing your sql server (start it just before the subscription creation attempt...

Hey Joe,

There's quite a few around.  Take a look over at Mosha's site (http://www.mosha.com), he lists some there.

If you want free (yeehaw) tools, MSft have their 'BI Portal' which...

Hi Ben,

The reason I asked re: the System or USer DSN is that if it's a user DSN you're user account can access it but the account under which the...

Did you create a system DSN or a user DSN?  What driver are you using and are there any user specific attriutes that you had to specify when creating the...

Hi Eva,

The quick sample I did up worked for me.  I created 2 reports, one was a subreport of the first.

Report 1:

Had a parm to collect an employeeId, not used in...