Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2007
    Posts
    8

    Question Unanswered: Comparing data with main report to subreport

    Hello, I am working on a crystal report in which the subreport is pulling out a box/carton out of a multi-body line field. Then in turn I am pulling out the box in my main report from a stored excel table. I am in need of doing a comparison formula and compared whether the box I pulling out of excel matches my subreport box. How do I go about doing this calculation?


  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Create a formula, drag the fields into the builder window from the appropriate form controls and arrange it like so
    Code:
    If {somefield} = {someotherfield} Then
      "Match!"
    Else
      "Uh-oh!"
    George
    Home | Blog

  3. #3
    Join Date
    Oct 2007
    Posts
    17
    I think the issue was in comparing a field in a subreport to a field in the main report. So you couldn't use the if statement. Now The report ended up working using a Shared VarString. The problem is , is that when it's inserted the first value is null and then the rest of the values are a row lower than they should be because of the first null value. It's really bizarre. Kinda looks like this

    Part A Part B If Match is Correct Display Part

    123 123 (Null)
    234 234 123
    345 345 234
    546 546 345

    As you can see the column next to Part B should list 123 as the part because they match but it appears Null and this only happens at the first row.

Posting Permissions

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