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

Notification

Icon
Error

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

Rank: Newbie

Groups: Registered
Joined: 6/13/2019(UTC)
Posts: 1
Canada
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.
epf  
#2 Posted : Friday, June 14, 2019 6:28:33 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 676
Switzerland

Thanks: 12 times
Was thanked: 116 time(s) in 113 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.