Excluding rows from results

[chrisk]

Hi All,

I want to know if it possible to use multiple databands in a report? I am trying to create a report that will show X number of rows with a populated issue date with another field that shows how many of those fields have a populated return date.

I have tried the two fields having the following

{Count(DataBand1,PastLoans.PastLoan_IssueDate)} which gives me the number of issues

I cannot get a count of how many rows have a populated return date field, I have tried the below to count how many rows return dates are not blank or Null

{Count(DataBand1,PastLoans.PastLoan_ReturnDate)}
{Count(DataBand1,PastLoans.PastLoan_ReturnDateNull)}
{Totals.Sum(DataBand1,PastLoan_ReturnDate == null?1:0)}

Any help would be great I can't see to figure how to get a where clause in there to ignore blank or null fields.

Thanks in advance

[HighAley]

Hello.

I want to know if it possible to use multiple databands in a report? I am trying to create a report that will show X number of rows with a populated issue date with another field that shows how many of those fields have a populated return date.

I have tried the two fields having the following

{Count(DataBand1,PastLoans.PastLoan_IssueDate)} which gives me the number of issues

I cannot get a count of how many rows have a populated return date field, I have tried the below to count how many rows return dates are not blank or Null

{Count(DataBand1,PastLoans.PastLoan_ReturnDate)}
{Count(DataBand1,PastLoans.PastLoan_ReturnDateNull)}
{Totals.Sum(DataBand1,PastLoan_ReturnDate == null?1:0)}

Any help would be great I can't see to figure how to get a where clause in there to ignore blank or null fields.

Please try to use CountIf(DataBand1,PastLoans.PastLoan_ReturnDateNull) function.

Thank you.