How do I report on all the phases and states a job requisition progresses through?

Summary:

I am currently trying to report on all the phases and states a job requisition progresses through, including effective dates. using subject area 'Recruiting - Recruitment Events Real Time'. I can extract 'Phase Code' and 'State Code' data as well as an 'Event Date' from the 'Job Requisition History - Event Details' folder but as soon as I add 'Job Requisition Number' from the 'Job Requisition - Basic Information' folder, the report errors out.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):