Posted: 9 Oct 2019 13:05 EDT Last activity: 17 Feb 2021 10:20 EST
Format Date in Drop Down
I am presenting a drop down to users in a Dashboard Widget (note: I get the same behavior presenting a drop down in the case harness, as well).
A report was created based on a Data Type called Flights, as shown in the attachment datatype.png. There is a date only field called FlightDate in the data type.
The drop down source is a report, based on the Flights data type, as shown in the attachment reportSource.png. In the report, the .FlightDate is formatted as MM/dd/yyyy (see attachment reportformat.png), and appears correctly when I run the report.
However, when I select the .FlightDate column from the report as the source of the drop down, it displays the date in a default format, and I cannot figure out how to change it (see attachment results.png). I want it to appear in MM/dd/yyyy format. Anyone have ideas?
***Edited by Moderator Marissa to update platform capability tags****
The format defined in the report (ReportFormat.png) is target only for the when rendering the column in "Report Browser" or "when exporing the data to pdf or excel". The same format can not be applied when rendering the value using a different control like dropdown (results.png) though you are referring the report definition in the source of the control.
I am able to replicate the problem the same way. However, the dropdown control used in this case is a basic html control. This will show the value as is from the clipboard value as a simple text value and there is no auto generated way that we can apply special formatting techniques like we did on the column in the report definition.
So, we need to use some advanced control to achieve the desired behaivour. In this case, I recommend to choose "Autocomplete" control. This control allows the formatting on the value. Here are the screen prints.
Auto complete configuration -
Source configuration -
Format configuration :
An configuration that gets the same look and feel like dropdown adding an accordion at end of the control