Hi Jon,
Thanks for your response.
I am using CABI Jaspersoft with a customised data source which is connected directly to MDB database. I am using the following tables (as shown in jaspersoft):
dbo_act_log and dbo_call_req with full join on persid (in call_req) and call_req_id (in act_log).
I have applied the filter in which type of call_req is 'I' and type of act_log is 'SOLN'.
Basically the objective is to show the details of all the incidents on which solution is provided by the analyst.
Now one of the fields that is being shown in the report is open_date (out of box field in call_req table). The value that is being shown in the report output is in the same format (numeric) that is stored in the MDB database. I want that it get displayed in the date and time format. Attaching some screenshots for your reference:
Custom Data Source->
Tables Used->
Field Detail->
Report Output->
Kindly suggest how to convert the open date from numeric to standard date and time format (as in CA BOXI, there was a provision to change the output format).
Regards,
Balram Singh Deswal