AnsweredAssumed Answered

Using Reports to Display all Portal Records

Question asked by SydneyBlock on Aug 20, 2015
Latest reply on Aug 20, 2015 by SydneyBlock

Title

Using Reports to Display all Portal Records

Post

Good morning!

I have a Staff Personnel database, which has a portal to display an employee's salary/bonus history. I am trying to create a report that will display each salary year for an individual employee. I am not sure if the problem lies with how the tables are related, or how the report is structured, but after playing around with the report a little, what I have gotten to is that it will display a record from the portal, but doesn't associate it with an employee. Here is how my table relationships work;

Personnel Records   Yearly Compensation

    xP_EmpID         -->      xD_EmpID     (Serial number to number field)

   p_ComSum        -->    EmpComSum  (Serial number to number field)

 

As far as my report goes, the layout itself is displaying records from Yearly Compensation. It has a subsummary when sorted by Personnel Records::FirstLast (Leading) and a subsummary when sorted by Yearly Compensation::Year (Trailing). Any tips on what I'm doing wrong?

 

Outcomes