duplicate record issue
CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2

Thread: duplicate record issue

  1. #1
    Join Date
    Jun 2009
    Posts
    1

    duplicate record issue

    Ok quite new to crystal reporting but done some basics and got the hang of it I think.

    Now I am getting more involved with reporting from active SQL tables. Issue I have at the momnet is that I have 2 tables. One has a list of personal data and one has a list of system users. They have a couple of identical columns including a unique user id(employee id number).

    What I want is a report which can be run to list everyone that only appears in table A (Personal Data).

    So my logical thinking is i should be able to look at table A and compare with table B and if the ID number is in table B ignore it from Table A.


    Anyone ever have to do this before?


    Cheers
    Baz

  2. #2
    Join Date
    Jun 2009
    Posts
    14

    Re: duplicate record issue

    Hello Bazrut,
    You should be able to compare those fields as soon as you place them your detail section.
    You can also use the selection expert to filter your results.
    I also recommend you look at the "inner join" information available at http://www.w3schools.com/ - look uder SQL

Posting Permissions

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


Windows Mobile Development Center


Click Here to Expand Forum to Full Width

This is a CodeGuru survey question.


Featured


HTML5 Development Center