Maybe this?

https://gallery.technet.microsoft.com/scriptcenter/Get-List-of-Unused-SSRS-9091d7bb

Maybe something like this, assuming you're using 2008.

http://www.rafael-salas.com/2008/05/t-sql-lead-and-lag-functions.html

If the data comes from different tables, you have to union the two queries together.

SELECT...

FROM tableA

UNION [ALL]

SELECT ...

FROM tableB;

Why are the history records in another table? Did this come from...

Maybe this article[/url] will help.

Or maybe use this to get the average?

COUNT(Fields!enrollmentID.Value)/CountDistinct(Fields!EnrollMonth.Value)

I added it to a new column outside the normal matrix group

Please post consumable data -- in the form of CREATE TABLE/INSERT statements or a SELECT statement with UNIONS...

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

mwill172 (6/11/2015)

---

Thanks for such a fast reply. I have very little knowledge in access and SQL, so please explain the following process 'Update with the value of the autonumber.' I...

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....