I agree re: the cost invovled.  The line that I hear most used is buy VB.net (~$99 US or less per seat).  This gets you the VS environment within which...

Yes, they should install developer edition.  This basically lets them have their own server to develop and test on prior to publishing the reports to your test and prod servers.

Theoretically,...

Have you tried running this up in RS?  We use this approach quite often to give our users the 'All' or individual selection options.  I noticed your earlier post looked...

Assuming you've got a standard summing roll-up for your dimension, then the value returned for the member 'Actvie' is the sum of it's children, so you'd just need to return...

Alternate SQL you could use is

select ...... from ....

WHERE (job_status = @status OR @status = 99)

This should return all when 'All' (99) is selected, or the individual status if one...

Hey Del,

You could try using the Descendants function to pick up only the descendants of the 'Active' member of the dimension.  Unless you've got your level members sorted alphabetically (this...

You could try using a Lookupcube statement.  These work pretty well when you have some common dimensions, just need to watch for query speed impacts.  Take a look at the...

Hey Del,

You probably want to use the BASC or BDESC in the order function.  These are the 'breaking' ascending and descending order statements.  They break the hierarchy when doing the...

Some (most?) front end tools will let/help you do these type of time calcs on existing measures.  You can also pre-create them as calculated measures.  Some do this with them...

You may want to do a search back through the RS Admin forum, I think it was Phil (philcart) who posted a message indicating that the upgrade could be done...

From the log it looks like the sub report (rptSummaryBynetowrkDetail) isn't where RS is expecting it do be (sub-dir /DDS/<report&gt.  If the two reports...

Hey Del,

I understand re: refreshing the data but still don't see why you couldn't/can't use MDX and dimensions to filter the data appropriately (have you looked at multiple hierarchies in...

very strange.  Your script worked perfectly on my local install (WinXP SP2, RS SP2) - apart from me not having the reports of course.

What OS is the server?  If it's...

Something along the lines of

=Calendar.GetDaysInMonth(Calendar.GetYear(Fields!<your_dt_field>.Value), Calendar.GetMonth(Fields!<your_dt_field>.Value))

The above uses the the GetYear to determine the year from your datetime field value and then the month number (1 based) to get the...

Could be a type but the User!UserId need to be outside of the quoted dynamic sql string, probably should be quoted with single quotes if being passed to MSSQL (it's...