Displaying Row count of Straight table as an header Text
I have a straight Table which gets filtered as per a check box selection. Hence the rows of the straight table changes dynamically. I have also suppressed the rows with null values and therefore the null rows does not getting displayed.
I need to display the total row count of the straight table as a header (say in a text box object). I am using count(Field1 & Field2). The count is getting displayed but it also includes the null rows that have been suppressed. Is there a way to eliminate null rows from the count?