What are you trying to accomplish with the >= comparisons here:

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

and [value_per_month]=@value_per_month >0

?

if you're trying to validate that the values passed to @position and @value_per_month are...

instead of this:

SELECT * FROM rCTE

ORDER BY Item_NO ASC

insert into the temp table

INSERT INTO #TempTable(Columns)

SELECT columnlist

FROM rCTE

ORDER BY Item_No ASC;

Start here maybe? (MS Log Parser utility)

You might be able to set the VISIBLE property of the control in the report based on the value in it... other than that, I'm not sure how you would...

You do realize that reports are read-only, right? You can prompt for parameters, but only before the report is run. That would be the only place you could modify...

Are you just trying to filter out the records that do or do not meet some criterion? If so, use a Filter and tie it to a parameter value, so...

Regarding teaching caution: Some people might say we go overboard. The attendees must have their manager sign and return a document that says they understand that they are responsible for...

I would start with comparing the differences between the reports that are working and those that are not. What errors do you get when you try to run the reports...

That's what I was thinking... Given that not everyone has a DW handy, it would make sense to me to be able to simplify the connection to the database... so...

I think you can, it's just that the interface is extremely unfriendly. (Another reason it works much better against a DW).

After posting this, I got off my lazy butt and...

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]