Alpha Video Training
Results 1 to 4 of 4

Thread: Show only unique records in report

  1. #1
    Member
    Real Name
    Mark Williams
    Join Date
    Dec 2005
    Posts
    313

    Default Show only unique records in report

    I am trying to define a filter in a report and I want it to only display records when a field is unique.

    For example, I have a field named IDNUM.

    I have several fields on the report, including IDNUM. If a record has the same ID number as another record on the report, I only want it to be displayed once when the report prints.

    Thanks

  2. #2
    Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,563

    Default Re: Show only unique records in report

    group on IDNUM and use the report header or footer for that region instead of the detail region.
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

  3. #3
    Member
    Real Name
    Mark Williams
    Join Date
    Dec 2005
    Posts
    313

    Default Re: Show only unique records in report

    Thanks, Al...

    I can't believe how easy that was. You wouldn't believe how much time I spent trying to over think this ;(

  4. #4
    Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,563

    Default Re: Show only unique records in report

    Quote Originally Posted by Mark Williams View Post
    Thanks, Al...

    I can't believe how easy that was. You wouldn't believe how much time I spent trying to over think this ;(
    Wanna bet? I resemble that remark....
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

Similar Threads

  1. Report to show duplicate records
    By Gustavo1478 in forum Mobile & Browser Applications
    Replies: 3
    Last Post: 04-07-2015, 02:42 PM
  2. How do I filter a report to show only unique fields (using ID) using a set?
    By Tanman in forum Alpha Five Version 9 - Desktop Applications
    Replies: 11
    Last Post: 09-25-2008, 07:28 PM
  3. Unique records in report
    By Peter.Greulich in forum Alpha Five Version 7
    Replies: 2
    Last Post: 09-07-2006, 02:08 PM
  4. Show Unique Records Only?
    By Brandon Burtnik in forum Alpha Five Version 6
    Replies: 2
    Last Post: 10-14-2005, 11:30 AM
  5. Report - show no detail records
    By Tom Patten in forum Alpha Five Version 4
    Replies: 1
    Last Post: 04-20-2002, 07:29 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
  •