Add another calculated field to your dataset. Instead of:

=IIF(fields!date1.value>fields!date2.value,"yes","no")

use

=IIF(fields!date1.value>fields!date2.value,1,0)

then you can total that.

Since you're new here, you should definitely read this article... it explains how to post questions to get the best help.

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

Once we have some sample data, answering your questions should...

If you create a placeholder, you can format it any way you want.

These are puzzling:

where [term]=@term and ([position]=@position) >=0

and [value_per_month]=@value_per_month >=0

Could you please explain what you're trying to accomplish? I just don't follow.

[position] is a column in your table, and @position would...

Check out Paul Randal's article...

Finding out who dropped a table using the transaction log[/url]

Looks like this returns who ran the offending code:

SUSER_SNAME ([Transaction SID]) AS [User]

Probably several ways to do this.

One would be to have two tablixes, one on top of the other and set one visible and the other not depending on which parameter...

Like this?

http://www.sqlskills.com/blogs/paul/finding-out-who-dropped-a-table-using-the-transaction-log/

or

http://www.mssqltips.com/sqlservertip/3090/how-to-find-user-who-ran-drop-or-delete-statements-on-your-sql-server-objects/

One way...

SELECT *

FROM

(SELECT DDid

, Seq

, Descrip

, ROW_NUMBER() OVER (PARTITION BY DDid, Seq ORDER BY DDid, Seq) AS rn

FROM

(SELECT 1 As DDid, 0 AS Seq, 'AAA' AS Descrip

UNION ALL

SELECT 1, 1,...

Sounds like you need a table for this:

The order is B,BB, A, AA, AAA, & AAAA.... something like

CREATE TABLE LoookupTable(

stringValue CHAR(4) PRIMARY KEY,

Seq TINYINT...

Maybe you can use this article[/url] to simulate LAG and LEAD.

Not really. It's only in TempDB because for him, it's not a permanent part of any database. you would put it in your database and not in TempDB.

The reason...

What's your expected result?

If you're using 2010, then PowerPivot is not installed by default. (Actually, I don't think it was developed until after 2010 came out.) You have to go to MS and...

I'm cheating for a minute and assuming you're using 2012 (which you're likely not)...

CREATE TABLE salesData

(date_created date,

sales money);

GO

INSERT INTO salesData (date_created, sales)

VALUES ('6-23-15', '20000.00'),

('6-24-15', '22000.00'),

('6-25-15', '25000.00'),

('6-26-15', '28500.00'),

('6-27-15', '32000.00');

-- 2012 solution

--...

UNION your real result set with something like

SELECT Null, Null, Null

FROM Tally

WHERE n<=@NumRows

you would need to figure out the count of missing rows to do it, but that would be...