Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2010
    Posts
    1

    Unanswered: crystal reports count function

    Hi,

    I am very new to crystal reports and I have what I think to be a very basic question that hopefully someone can answer. I need to get a count of a specific value "complete" within a group. I also need to get a count of another value within the same group "incomplete". I subsequently need to display the count of the two values as a numerator/denominator (complete/incomplete) in a separate group. Does anyone have any suggestions as to how I can accomplish this?

  2. #2
    Join Date
    Feb 2008
    Posts
    21
    Hello there,
    I am not clear about your requirements, but as far as I can understands you need to select a column value based on another column value in that same row. like -
    Code:
    select name from users where sex='m'
    to do this you can use formula like this
    Code:
    if {users.sex} = 'm' then
    {users.name}
    else
    '-'
    now drag the formula field to the details section to add the field to the report.

    I hope you get the hang of it. Btw you need to add both the filtering and filtered column in the report using db expert.

Tags for this Thread

Posting Permissions

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