Hi Corteza team,
I am currently working with Corteza Reports and I have two questions related to report tables and embedded reports inside Compose Page Layouts.
First, I have some module fields of type Select/Dropdown. When I use those fields in a report table, the report displays the stored internal value instead of the user-facing label.
For example, a Select field may be configured like this:
| Stored value | Label |
|---|---|
0 |
Pending Approval |
1 |
Approved |
2 |
Rejected |
In Compose record pages, users see the label, such as Pending Approval, but in the report table I only see the stored value, such as 0.
Is there a recommended way in Corteza Reports to display the Select/Dropdown label instead of the stored value?
I would like to avoid creating extra calculated fields, workflow-maintained label fields, or manual CASE mappings if Corteza already provides a native way to access the display label.
Second, I would also like to know if it is possible to apply a dynamic filter to a report embedded in a Page Layout, based on the current record context.
For example, if I am viewing a Project record in Compose, and I add a Report block to that Project page layout, can the embedded report be dynamically filtered using the current record ID?
Something like:
project = ${record.recordID}
or any similar context expression.
The use case would be to show report data related only to the record currently being viewed, for example:
- Tasks related to the current Project
- Approvals related to the current Request
- Incidents related to the current Worker
- Cost items related to the current Job
So my two main questions are:
- Can Corteza Reports display Select/Dropdown labels instead of stored values?
- Can an embedded report inside a Compose Page Layout receive or use the current record context as a dynamic filter?
Any guidance, recommended approach, or workaround would be appreciated.
Thanks!