Problem with Excel export

[Caio Mayer]

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.

[Rossen Hristov]

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

[Joseph]

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.

[Rossen Hristov]

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.

[Quan Nguyen]

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

[Steve]

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

[Quan Nguyen]

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

[IvanY]

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

[Quan Nguyen]

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

[Elian]

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