Is it possible to run a Calendar report on a database view and select the "fields" we want to see from the database view?
I have created a database view of two custom tables, one of which has a start_date and end_date field. The second table has room information that needs to be viewable together with the start and end dates - hence the database view. A list report runs fine but a calendar is requested to show Short Description, Assigned To, Start and End date(time) and room information. The calendar entry looks like this - not helpful
I know how to choose the fields I want to show on a calendar report from a normal table - go to collection record and add calendar_elements to the attributes. However, a database view does not have a dictionary so no collection record.
Does anyone know if it's possible to create a usable calendar report from a database view? If not, any other way to create a calendar such as this?
