Create another table of just the unique SSNs. Add an autonumber to the table. It will populate with unique numbers (might have gaps). Add another column to the...

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/cf06de2b-683b-4208-9682-a13f5e7ac2cd/help-with-mdx-query?forum=sqlanalysisservices

Orange is a running sum? If you're using 2012, use a windowing function to create the running total, then just base the report on your stored procedure.

Maybe you should read this. Most people don't want to download files from people they don't know...

http://www.sqlservercentral.com/articles/Best+Practices/61537/

I should have referred you to this article:

Forum Etiquette: How to post data/code on a forum to get the best help[/url]

It explains how to post data etc. It just makes...

Can't do that anymore. Haven't used SSRS 2005 in a long time, and don't have it installed anywhere.

Where to begin? For starters, since you're clearly new here, it would help a LOT and you would get better answers if you posted sample data like this:

SELECT 2015AS...

If you right-click the gray button in your totals row, you should get a dropdown that says something like...

Insert Rows

Delete Rows

Row Visibility

etc

Choose Insert Rows. Then in that row, you...

I would probably force the existence of the missing values by using an outer join in the query this is based on. Then coalesce the missing values to zero....

Jason,

If you have a local SQL Server User Group, I would definitely talk to people there - both recruiters and other developers/DBAs. What usually happens to the groups i...

That's not the kosher way of posting expected results, but anyway... here's the answer:

SELECT Component

, [Opening Balance]

, [M/O Qty Req,d (MWOMAT)]

, [Opening Balance] - ABS(SUM([M/O Qty Req,d (MWOMAT)]) OVER (PARTITION...

Do you need to display all the subtypes at once? Otherwise, you could use add an action to each of the bars of the chart that would basically drill into...

Looks like you're looking for REPLICATE.

The table doesn't exist for the rest of us, though. That's why you post it. To get tested code.

What 5 records are you trying to return? You never...

Welcome to SSC. Since you're new, I'll fix up your post to show you a way to do it that will make the job of those trying to help...