In my experience the person who designs the database may have good reasons for cascaded updates and deletes on some relationships and not others...

Yikes, my eyeballs lied to me. Usually the guy that builds the servers makes the data drive letter D and this time it's E and I failed to notice. This...

Thanks for your responses. I am getting the following error when I attempt to switch the install path to the D drive.

This is despite the fact that I have...

Thanks guys, we will deploy to an NLB cluster dedicated to SSRS. Appreciate your responses.

Allister, I'm using that one because lucky me, the report we're doing only has a couple of hundred nodes in the tree and as of now we won't even have...

It depends on how you want to show the data. If you just want all the data for the previous month or same month last year as additional rows, then...

If I understand your problem correctly, I don't think this is an SSRS question as much as it's a query question. I would suggest left joining to the prior month...

I believe another way to solve the problem is just to install the 2008 version of the Report Viewer, which works just fine with SSRS 2005.

http://www.microsoft.com/downloads/details.aspx?FamilyID=bb196d5d-76c2-4a0e-9458-267d22b6aac6&displaylang=en

I figured it out. I am running the 64-bit version of Windows 7 and I was rushing and failed to make the distinction between "Program Files" and "Program Files (x86)"....

I didn't provide DDL and sample data because I'm not asking for someone to write the query for me, I am just asking if anyone has any links to articles...

Are you using the default report manager site or are you trying to integrate your reports into a custom application/sharepoint/something else?

There are manual ways to do it, sure, but if you're going to be working with staged dev/test/production databases, you need to know about Red Gate SQL Compare and SQL...

To answer your second question, yes, SQL Server offers the ability to "cascade" a delete or an update. Google or search this site for ON DELETE CASCADE and you'll find...

I can't help myself, I have to ask, what kind of application is this and why does it create many tables with the exact same schema??

Bru's way is a better approach but just in case I'll offer an alternate, the only advantage being how few lines of code it needs. It assumes you store the...