Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2004
    Posts
    34

    Question Unanswered: Only count shown records???

    Hi,

    Is there anyway to make CR count records that are only showing on the page??? Example: I have a report that has null values in it... Those null values are suppresed... Now I want a count a of those records only showing so I can conditional format each line. I've tried using the null values as evaluation criteria but it is not working... If anyone has any ideas please help!!!

    Thanks,
    Jcoe

  2. #2
    Join Date
    Oct 2003
    Posts
    357

    Thumbs up

    Hi, try this. Create two formulae having the following code
    Code:
     Formula1 : @OmitNull which has the code
    NumberVar r;
    whileprintingrecords;
    if not isnull({Fruits.Test}) then
    r:=r+1;
    Formula2 : @Display which has the code
    {@OmitNull};
    Now place these to formulae in the details sections and suppress them. Place @Display in the report footer and do not suppress it.
    Now you can see the result what you expected.

    Madhivanan

  3. #3
    Join Date
    Jul 2004
    Posts
    34

    Thanks...

    Thanks Madhivanan, you rock!!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •