Add a job cost related field to AR report in Crystal Reports

SUGGESTED

I am trying to add the "JobDesc" field to our AR Aged Invoice Report so that we can see what job name corresponds with the invoice on the report. I'm a beginner in Crystal Reports, but here is what I've tried:

In Crystal Reports designer, I created a copy of the AR Aged Invoice Report to edit. Since "JobDesc" isn't a field within the AR Aged Invoice Report, I opened Database Expert and added the "JC_JobLIstingWrk" table to the selected tables. I've checked the links many times and I BELIEVE I have all the matching records from the two tables linked (SortField, GroupField, JobNo, etc.). When I add the "JobDesc" field to the report, it doesn't print anything in that field on the report. Is there something I'm missing? I found some articles about adding a field through Custom Office\User-Defined Field and Table Maintenance, but "JobDesc" isn't an available field to add since it's a field more related to Job Cost. 

Parents
  • 0

    I have never worked with subreports, but when I was looking into the suggestions above I talked to someone else whose solution worked. 

    For anyone interested, here's what ended up working. It was recommended that I add the table JC_Job rather than JC_JobListingWrk. Then go to Link Options and change the Join Type to "Left Outer Join" (because if an item on the AR Report didn't have a job number, it might leave it off the report altogether). It still didn't work until I removed all of the links EXCEPT JobNo.

    Success!

Reply
  • 0

    I have never worked with subreports, but when I was looking into the suggestions above I talked to someone else whose solution worked. 

    For anyone interested, here's what ended up working. It was recommended that I add the table JC_Job rather than JC_JobListingWrk. Then go to Link Options and change the Join Type to "Left Outer Join" (because if an item on the AR Report didn't have a job number, it might leave it off the report altogether). It still didn't work until I removed all of the links EXCEPT JobNo.

    Success!

Children