please help with selection criteria Crystal 8.5
CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2

Thread: please help with selection criteria Crystal 8.5

  1. #1
    Join Date
    Jan 2014
    Posts
    1

    Question please help with selection criteria Crystal 8.5

    Have a table with mulitple records per person, need to read the records for each person and based on certain fields pull them into my report. I have a list of combinations of seq and codes that need to be in my result. For example (in seq order) 0032/0303/0990 or 0064 or 0311/0091 (my list is much larger) but for this example the only records I would need would be person 1 and person 2 from the list below... I dont know how to read through records like this.. can someone suggest a good way for me to do this? Much appreciation


    person seq code
    person1 1 0032
    person1 2 0303
    person1 3 0990

    person2 1 0064

    person3 1 4000
    person3 2 5000
    person3 3 6000

    person4 1 0032
    person4 2 5000
    person4 3 0990

  2. #2
    Join Date
    Jul 2005
    Posts
    1,075

    Re: please help with selection criteria Crystal 8.5

    If the list is large then you could create a new table with all the desired records and define the fields as a key (person, seq & code).
    Then add that table to your report and link your data table to this new one.
    The report will display only the linked records
    JG


    ... If your problem is fixed don't forget to mark your threads as resolved using the Thread Tools menu ...

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