Viewing 4 posts - 1 through 4 (of 4 total)
=Sum(IIF(Fields!PaidDirecttoThree.Value = "Y", Fields!Amountcollected.Value, 0))
Everytime i run the report however i get an error. The PaidDirecttoThree column in the report is either Y or it is null.
Any ideas?
Instead of checking...
May 17, 2011 at 2:15 pm
Could you just filter out any record where the balance = 0?
May 16, 2011 at 9:13 pm
Are you expecting users to select each item from the drop down box, populate each text box, THEN run the report? Or do they select 1,2, or 3, fill...
April 29, 2011 at 8:51 pm
You may also need to JOIN() your parameter values prior to passing them to your stored procedure
April 29, 2011 at 5:09 pm
Viewing 4 posts - 1 through 4 (of 4 total)