I suppose you could, but the downside to doing it in SSRS is that you pull back a bigger dataset, and T-SQL will run circles around SSRS doing this any...

How about this one[/url]?

The part you want is at the end of the article.

I would probably see if HappyCat59 knows.

Before I get into possible solutions, if you're just starting on this database, I would advise you to reconsider your design. Basically you're storing more than one fact in...

I'm assuming you're using Access 2013 (it's what I have installed, sorry!) so if this doesn't work, you might need to specify the version of Access you're using.

If you're querying...

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/