Export to Excel

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
mike
Posts: 16
Joined: Tue Oct 10, 2017 12:44 pm

Export to Excel

Post by mike » Fri May 31, 2002 2:06 pm

I have a problem where when I export a report to Excel 2000 on a Windows 2000 machine with R&R SQL 9.0 it will export dates as character symbols even though when you do a print preview the dates look fine. Anyone have any suggestions?
Top
kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: Export to Excel

Post by kfleming » Sun Jun 02, 2002 10:29 am

One way around would be to use the DTOC() function in the report to send the dates as character strings.____You could also try adding the line:__CSVKeepDateFormats=1____to the Export section of C:windowsRRW.INI____Kathleen__R&R Support
Top
mike
Posts: 16
Joined: Tue Oct 10, 2017 12:44 pm

==> RE: Export to Excel

Post by mike » Tue Jun 04, 2002 1:59 pm

I do not have an RRW.INI file. I do have a RSW.INI file and editing that does not do the trick. Need more help.
Top
kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

===> RE: Export to Excel

Post by kfleming » Wed Jun 05, 2002 1:09 pm

Did you try the calculated field method?____Kathleen__R&R Support
Top
Post Reply

Return to “R&R ReportWorks Users”