Warning: The forum is now for consultation only. Please use GitHub Discussions to post any questions or comments.

Welcome Guest ! To enable all features please Login or Register.



Go to last post Go to first unread
#1 Posted : Thursday, June 13, 2019 3:12:02 PM(UTC)

Rank: Newbie

Groups: Registered
Joined: 6/13/2019(UTC)
Posts: 1
Location: Ontario

The same report can be exported to PDF and looks great!

It can be exported to CSV and then opened with Excel and the date fields can then be formatted to show the date (they have the date and time in them and show the time only by default).

Unfortunately, exporting to Excel leaves all date fields empty.

If the row contained only dates, then the row is trimmed out of the Excel report.
#2 Posted : Friday, June 14, 2019 6:28:33 AM(UTC)

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 1,209

Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
Do you mean: when the date time is specified with a time format, the Excel converter leaves the field empty ?
Make sure that the Type of your element is a Date Time.
You might also force the Type to Text to have your filed in text...

Which version of SR are you using ?
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.