Link-Parent field in Reports — Accessing related entity columns (v9.3.10)

[rudy880718]

Hi EspoCRM team,
I'm running EspoCRM 9.3.10 and I'm facing a limitation with the Reports module when using a Link-Parent field.
My setup:

• Entity: Inscripcion
• Field: event — type Link-Parent
• Fields I need in Reports: event.fechaInicio (startDate), event.fechaFin (endDate), event.sector

The problem: Since event is a Link-Parent, the database only stores eventId and eventType. The Reports module works directly with SQL, so I can't access the related Event fields as columns. I tried using autocalculated fields to pull the values, but they don't appear in Reports because they aren't stored in the DB / aren't part of the SQL query.
My question: Is there any native way to expose fields from a Link-Parent related record inside the Reports module (List or Grid reports)? As a side note, I should point out that the client wants to avoid creating more fields in the entity or running jobs since there are already many records in the database. Any guidance would be appreciated. If a custom complex expression or report hook is the way to go, a small pointer on where to start would be great.
Thanks!

Field:
"event": {
"type": "linkParent",
"entityList": [
"CFeria",
"Ronda",
"Capacitacion",
"ArgentinaB2B",
"SemanaArgentina",
"Otro"
],
"readOnlyAfterCreate": true,
"required": true,
"audited": true
},

[victor]

Maybe someone will give you better advice than mine, but in this case you can't do without additional fields inside the entity.
That is, you should create the necessary fields inside the entity of the same type as event.fechaInicio (startDate), event.fechaFin (endDate), event.sector from the Parent entity. Then, using simple formulas, put the data from the Parent entity into the current one and use the data from the created fields in the Report.
These fields should not be displayed on Layouts and will be used only in Reports.