CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2020
    Posts
    1

    How to only show last record in a linked table and then group these records

    Hi, this is my first post, i'm from the Netherlands, so I hope my English is not to bad.

    I'm using SAP BusinessObjects Crystal Reports 2013 Support Pack 4, Version 14.1.4.1327 on a windows10 machine (Sybase SQL database).
    The database shell we use is Ultimo (www.ultimo.com)

    I'm using 2 Tables (Equipment-tabel and LendOut-tabel). (We register equipment and we want to know which equipment is available for lending out (lend out or available)
    Tables are linked by EquipmentId (EquipmentMove.EqmmEqmID -> Equipment.EqmId)

    Is there a way to show only the last record of the EquipmentMove table, and then group this result by EquipmentMove.EqmmRecStatus (= lend out or available) and within this group group again by Equipment.EqmDescription.
    In the attachements you will find what i did so far:
    Attachment 35846Attachment 35847Attachment 35848
    Group #1 on @UitleenStatus, Group #2 on EquipmentMove.EqmmEqmiD and Suppress Details Section {ReordCount > 1) to get the last records.
    The problem is that i get duplicate records.
    Attached Images Attached Images     

  2. #2
    Arjay's Avatar
    Arjay is offline Moderator / EX MS MVP Power Poster
    Join Date
    Aug 2004
    Posts
    13,490

    Re: How to only show last record in a linked table and then group these records

    Don't know much about cr, but can you sort the linked table in descending order and select 1 record?

Posting Permissions

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





Click Here to Expand Forum to Full Width

Featured