Configure Function field in Calendar Report on RITM table but for particular Catalogue Variable.

[Prutha Joshi]

How to design Calendar Report & configure function field on the basis of particular variable from Catalogue.
Suppose I have 100 RITMs which captures variable such as Users info: Name, Email id, Phone number and joining date. I want to create a calendar report on the basis of Joining date, The report should show Calendar along with RITM/REQ# , e.g 23/01/2023 should show RITM00111, RITM00222 & RITM 00333 as the users who created these requests chose the joining date as 23/01/2023. See example screenshot for change request 'Image 2' shows the Change request on the basis of Planned start Date. 
We can configure the function field for the field which are available on the selected table, but how to do it -

if configuration is required for the Variable in RITM. 

[Brian Lancaster]

Oh, ok I see sorry misread your original post. I don't think you can add variables to the event to display on dropdown in the calendar report. My only thought for this would be to create a custom field on the sc_req_item table with the same type as your variable. Then when that request is submitted use a business rule copy the variable into the field.

[Prutha Joshi]

Thank you Brian for your time on this,
Unfortunately User required it on calendar report only & that too on the sc_req_item table for that "Specific" catalogue.

We did not went ahead with the customisation as there were other constraint included.