Export high precision time data from web report to Excel/Word file

Background

When exporting web report to Excel/Word file, the precision of high precision time data will decrease. That is because of the display format of Excel/Word. For example, if there are time data of millisecond, it will changed to second after being exported to Excel/Word.

This is troublesome for users of web report. then, is there a way to keep the precision of time data?

Solution

The answer is yes!

As a professional web-based Java reporting tool, RAQ Report pays a lot of attention to details. For this problem, RAQ Report provides a wonderful function — str().

Easy Operation

Users only need to write the function as str(value(),”yyyy-MM-dd HH:mm s.S”) as shown below. Then, time data can be displayed correctly after being exported to Excel/Word file.

Source: Knowledge Base of Web Reporting Tool
Original Post: Export high precision time data from web report to Excel/Word file
Related Articles:
7 shortnesses of displayTag;
Comparison between RAQ Report and Crystal Report;
HTML report dengan VB;
Exports generated crystal report into Excel Format & download;
Useful Links:
Excel-like Web-based Java Reporting Software;
Freezea’s Report Lesson;
Jackson’s Reporting Review;
Dotnet SourceCode;

RAQSOFT: Innovative Techology Makes Progress.

For more about reporting tool, you are welcome to refer to freezea's blog.