This is a migrated thread and some comments may be shown as answers.

Problem with Excel export

9 Answers 149 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Caio Mayer
Top achievements
Rank 1
Caio Mayer asked on 10 Jan 2008, 10:43 AM
When I export a report to excel with date values at some columns the displayed values are not correct.
Ex: "24/10/2007 10:54:36" on the report viewer, this value is displayed as "39379,45" on the report exported to Excel.
At pdf export the values is displayed correctly.

Is there some workaround for this? some property to set?

Thanks.

9 Answers, 1 is accepted

Sort by
0
Rossen Hristov
Telerik team
answered on 10 Jan 2008, 10:55 AM
Hello Caio Mayer,

Can you send us your original report along with its data. We will try to reproduce the behavior in order to locate the problem.

Greetings,
Ross
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center
0
Joseph
Top achievements
Rank 2
answered on 22 Aug 2008, 07:03 PM
I had this same problem, and what I wound up doing was converting the dates to varchars in the database, and then setting the properties of the date columns in the dataset to System.String.  That fixed the issue.

However, I suppose a limitation of this is that then you can't really treat this as a date on the front-end - it would sort as a string - couldn't be subject to localization , etc.

If anyone at telerik has a better fix, I'd like to know.
0
Rossen Hristov
Telerik team
answered on 25 Aug 2008, 08:03 AM
Hi Joseph,

Are you using the latest version of Telerik Reporting? There was a bug like the one you describe, but it was fixed way back in time. In case you are using the latest version of the product and you are still experiencing this behavior, please open a new support ticket and attach a project that demonstrates that behavior.

Best wishes,
Ross
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.
0
Quan Nguyen
Top achievements
Rank 1
answered on 19 Dec 2012, 06:02 PM
Hi
I am using Telerik Reporting Q2 2011 version and have been experiencing this same issue.
Attached are the screenshot of my report and the excel version.

Thank you
Quan
0
Steve
Telerik team
answered on 20 Dec 2012, 12:00 PM
Hello Quan,

As my colleague has asked in the post way back in 2008, we cannot reproduce this problem in our local tests, so please open a support ticket and attach a project that exhibits the problematic behavior. Once we review it, we would be able to provide you with more information.

On a side note, does the problem occur with both the Excel 97(.xls) and newer OpenXML Excel (.xlsx)?

All the best,
Steve
the Telerik team

HAPPY WITH REPORTING? Do you feel that it is fantastic? Or easy to use? Or better than Crystal Reports? Tell the world, and help fellow developers! Write a short review about Telerik Reporting and Telerik Report Designer in Visual Studio Gallery today!

0
Quan Nguyen
Top achievements
Rank 1
answered on 21 Dec 2012, 07:41 PM
How do i send the project codes? I can only attach image files.
I can't find anywhere that I can create a support ticket for reporting in my account area.

Also, Is there a way to limit the export options?

Thanks
Quan
0
IvanY
Telerik team
answered on 27 Dec 2012, 10:32 AM
Hi Quan,

Limiting the export options - yes, there is an easy way to do so - here are listed all the rendering extensions and in Telerik Reporting Configuration Section (and the related sub-articles) you will see how to add our section. Finally all you need to do is to exclude the rendering extensions, like this:
<Telerik.Reporting>
  <Extensions>
    <Render>
      <Extension name="CSV" visible="false">
      </Extension>
    </Render>
  </Extensions>
</Telerik.Reporting>

In order to open a support ticket you need to have a valid support subscription. Since your subscription has expired a year ago, you won't be able to do so.

Greetings,
IvanY
the Telerik team

HAPPY WITH REPORTING? Do you feel that it is fantastic? Or easy to use? Or better than Crystal Reports? Tell the world, and help fellow developers! Write a short review about Telerik Reporting and Telerik Report Designer in Visual Studio Gallery today!

0
Quan Nguyen
Top achievements
Rank 1
answered on 27 Dec 2012, 06:46 PM
Hi,
I tried to configure the Telerik.Reporting in my app.config file to exclude CVS item but got error on ReportViewer screeen.
Attached are some screenshots.

Can i renew my support subscription?
Thanks
Quan
0
Elian
Telerik team
answered on 01 Jan 2013, 01:18 PM
Hi Quan,

There has been a change in the configuration section in the 2012 Q3 Release:
Telerik.Reporting.Processing.Config.ReportingConfigurationSection is now Telerik.Reporting.Configuration.ReportingConfigurationSection
and the online documentation has been updated accordingly.
Since you are on 2011 Q1, you should be using the old class name. 
 
All the best,
Elian
the Telerik team

HAPPY WITH REPORTING? Do you feel that it is fantastic? Or easy to use? Or better than Crystal Reports? Tell the world, and help fellow developers! Write a short review about Telerik Reporting and Telerik Report Designer in Visual Studio Gallery today!

Tags
General Discussions
Asked by
Caio Mayer
Top achievements
Rank 1
Answers by
Rossen Hristov
Telerik team
Joseph
Top achievements
Rank 2
Quan Nguyen
Top achievements
Rank 1
Steve
Telerik team
IvanY
Telerik team
Elian
Telerik team
Share this question
or