custom report works, cms supervisor dont

[whatsanavaya]

i've created a custom report with screen painter. When i run the report using the cms terminal, all is fine but when i run the same report with cms supervisor one of the fields is just ******. it should just be todays date but not as a date variable but as a database item so that for every row i get the date as well.
The custom report is just a daily agent report where i want the date displayed on every line.

the field is hagent.ROW_DATE.

Any ideas?

 

[definityandcmuk]

I think the asterix appear when the field content is too big for the column, try resizing

 

[whatsanavaya]

the ****** only appear when the report is run in CMS Supervisor. When run using the CMS terminal the dates are shown correctly. I used the screenpainter within the CMS terminal application to create the report. Other dates are shown OK when they are created as a variable but when they are created via a database field item, they are not shown in CMS supervisor report.

 

[whatsanavaya]

solved. The field format had to be changed from mm/dd/yy to dd/mm/yy.