I have created a report in SSRS 2005 which contains a Matrix and I want to dislplay the following information:
Row:UserID, PaymentAmt, Column
I want to display 12 months (Jan, Feb, Mar...etc) whether there is a PaymentDate or not in the db, with the text "N/P" in the PaymentAmt field
I have tblMonthQtr in the db with a Data Type of nchar(10), and tblPayment which contains a PaymentDate field which is Data Type smalldatetime
I have tried the following:
=iif(Sum(Fields!PaymentAmt.Value is nothing, "N/P", Sum(Fields!PaymentAmt.Value))
I believe I need to tie in the PaymentDate to this somehow but am not sure how to do that.
The logic seems to be - If the PaymentDate <> Month 1-12, then "N/P" with the Name of the Month displayed in the PaymentDate textbox.
Any assistance would be appreciated