style not working, while exporting Report progrmatically

[Pradeep Toluganti]

I have Create the report and tried to exprot programatially like below, but styles does not seem to be exproted.

TRANS_DELIVERY_REPORT

 

report = new TRANS_DELIVERY_REPORT();

 

Telerik.Reporting.Processing.

ReportProcessor reportProcessor = new Telerik.Reporting.Processing.ReportProcessor();

 

Telerik.Reporting.Processing.

RenderingResult result = reportProcessor.RenderReport("XLS", report, null);

 

 

 

FileStream fs = new FileStream("C:\\report1.xls", FileMode.Create);

 

fs.Write(result.DocumentBytes, 0, result.DocumentBytes.Length);

fs.Flush();

fs.Close();

can any one please let me know what need to be done? thank you.

[Chavdar]

Hello Pradeep Toluganti,

Please, note that the Excel rendering extension supports only a predefined set of around 75 colors that can be used for Background and Foreground colors of report items. The report item’s colors are translated to the closest possible color from the predefined palette and this might be the reason to suppose that the styles are not working.

You can also check whether the styles are working or not working by exporting the report to another format, e.g. PDF. For more information about the Excel rendering extension, please take a look at the Design Considerations for Excel Rendering help article.

All the best,
Chavdar
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[Steve]

Hi Pradeep,

This is just a follow up to let you know that in Q1 2011 we've introduced new export formats based on Office Open XML and one of them is XLSX which does not have the limitation to the color palette as the old BIFF excel format.

All the best,
Steve
the Telerik team