Alpha DevCon 2018
Results 1 to 4 of 4

Thread: Count repeating rows

  1. #1
    Member J.R. Noe's Avatar
    Real Name
    J.R. Noe
    Join Date
    Feb 2011
    Location
    Brandenburg, KY.
    Posts
    398

    Default Count repeating rows

    I have an unbound textbox on my dialog and i want it to display the count of records in the repeating section, but i only want to count the records in which the "xyz" field in the repeating section has a value (not null). I have tried some of the count functions i have found on here, but I cannot get any of them to do a conditional count.
    J.R.
    Epigate Software, LLC.

    jr@epigate.com
    http://www.epigate.com

  2. #2
    Member
    Real Name
    Bill Amidon
    Join Date
    Dec 2010
    Location
    Osseo, Wisconsin
    Posts
    116

    Default Re: Count repeating rows

    Could you have a virtual field that evaluates to 0 or 1 then total it?

  3. #3
    "Certified" Alphaholic
    Real Name
    David Kates
    Join Date
    Apr 2008
    Location
    Unionville, ON
    Posts
    6,891

    Default Re: Count repeating rows

    Have a look here http://msgboard.alphasoftware.com/al...tingSectionRow post # 7 where it talks about an Array filter. Excellent little method. I think that might do it for you - you can include anything you like in the list.

  4. #4
    Member J.R. Noe's Avatar
    Real Name
    J.R. Noe
    Join Date
    Feb 2011
    Location
    Brandenburg, KY.
    Posts
    398

    Default Re: Count repeating rows

    Thanks David, that worked.
    J.R.
    Epigate Software, LLC.

    jr@epigate.com
    http://www.epigate.com

Similar Threads

  1. Repeating rows in browse
    By Bonbon in forum Alpha Five Version 11 - Desktop Applications
    Replies: 11
    Last Post: 02-06-2012, 04:16 PM
  2. How To Set # Repeating Rows When Dialog Opened For Edit?
    By iRadiate in forum Application Server Version 11 - Web/Browser Applications
    Replies: 3
    Last Post: 12-08-2011, 08:53 AM
  3. How to calculate amount in repeating rows
    By Mike Reed in forum Application Server Version 11 - Web/Browser Applications
    Replies: 8
    Last Post: 11-14-2011, 07:42 PM
  4. Repeating rows in reports
    By Larry Gordon in forum Alpha Five Version 10 - Desktop Applications
    Replies: 3
    Last Post: 03-09-2011, 02:32 AM
  5. Repeating rows - why?
    By Peter.Greulich in forum Web Application Server v7
    Replies: 6
    Last Post: 12-29-2005, 08:55 AM

Bookmarks

Posting Permissions

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