Thanks guys. That one got to me because I put a lot of time into providing solutions that did exactly what he needed for results based on the information...

pietlinden (9/9/2014)

---

Jack,

Cool solution! After stepping away from what I was thinking before, I realized that I could use a CTE to do the thing... (and I saw you did...

KoldCoffee (9/9/2014)

---

yes, you and pietlinden are the only ones. And you are trying to help me but are under and over reaching each time. I need one specific...

Okay, I may have gotten out of line in this thread, http://www.sqlservercentral.com/Forums/Topic1611473-150-1.aspx, but I'm not sure. Been trying to help the OP all day and the response where the OP...

KoldCoffee (9/9/2014)

---

Yeah, I'm learning SSRS. My boss knows that.

I'm asking for help with one small part of a report and not for advise on why I am bringing...

The expression I provided should still work for what you need, you'll just need to figure out how to get it to work with the dataset you have and within...

Okay the expression gets the leads from last year that match this year and sums them.

Binoogle SSRS Lookup to understand how the Lookup function works.

Attached is a working report (embedded...

For auditing/logging changes to data in the database (your first logging) I would do it in the same database.

For application logging I would probably use a separate exceptions or logging...

Your issue is that you are trying to output to the same file and sqlcmd doesn't support appending. From BOL:

-o output_file

Identifies the file that receives output from sqlcmd.

If -u...

I would also say that is depends on how you are using the data in your report. Remember 2 stored procedures in 2 data sets mean 2 calls to...

KoldCoffee (9/9/2014)

---

Thanks Jack, I'll take a look at this (just got it). I really appreciate it

btw, earlier I said

subtract last years count from this year's count...

Because I was intrigued by this problem I put some effort into figuring out what you want. I don't think doing this in an SSRS expression is the best...

3 questions:

1. Can you post the query you are currently using for your SSRS dataset because the query you posted earlier doesn't have months?

2. To be clear, the...

Alexander Suprun (9/8/2014)

---

navie22 (9/5/2014)

---

Get date in where condition will also change with each moth like

AND MT.TRANSACTIONDATE BETWEEN DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE())-2, 0) --First day 2 months ago

AND DATEADD(MILLISECOND, -...

I can't speak for anyone else, but I'd have to know what your data set looks like in order to hazard a guess.