I am assuming the issue is with the iif statement, not the DateDiff function. Instead of doing a length comparison, can you try using the IsNothing function. I've...

You should be able to just add a simple where clause:

select * from [download$]

where column1 = 'value'

You can use all of the regular sql syntax from here to filter...

The expression goes in the textbox just belowthe Collected header (starts with =Sum...). This is editable and should work for you, if not let me know.

As a note, it...

No problems, there are lots of topics and lots of questions...

To figure out the group name, select the field you are looking for (Fields!PayerName), right click and Edit Group. ...

This seems pretty similar to another question from earlier this week:

http://www.sqlservercentral.com/Forums/Topic1138567-1063-1.aspx

You should be able to use one of the two functions below (changing field and group names to those consistant...

After playing around a little more with the scope (like you mentioned) you may be able to get the subtotal to work even better if you use an expression like...

You are certainly more restricted in SSRS 2005, but you can move the expression into the textbox associated with the subtotal. Which could work depending on the formatting. ...

What version are you using? I just ran a quick test on 2008 R2 (you can modify totals expressions in this version), but I may have missed something else...

Marty,

I think it may be easier. Assuming you have a separate subtotal for each group, you should be able to do a conditional expression in the subtotal line for...

Based on the error, it looks like you have some illegal characters in the .rdl file.

To fiew the source XML/RDL code, right click on the report from Visual Studio and...

Another option if you want to stick with the dates and do math as integers is (YEAR(INV_SER_DT)*100000)+MONTH(INV_SER_DT). By multiplying the year function (2011) by 100000 and then adding the...

Glad it all worked out... Good luck

I just tested this as well and it worked fine for me. In SSRS 2005, first make sure you select the entire row, not just a single cell or...

If the report has a group created on the date field, then you can easily just use the border properties to create the line. Make sure the border width...

Here's a shot at question 2, to join them together. I changed your table JOIN syntax to use the more conventional SQL syntax. I then used the first...