Exported excel format of report not fine

[prajan]

Hi,
I have created a report using stimulsoft. The report is all fine in webviewer. But when I export it to excel format, I see multiple cells are merged , horizontally and vertically. This makes the excel report unusable.
I have made every component as align to grid. I am not sure what I am missing.
I am attaching the report as well as the output format in excel. Can you please tell me how I can fix this.

Thanks

[HighAley]

Hello.

Please, read the How to Create Report for Export? section of the Stimulsoft User Manual.

//offtopic
Why do you use Data Bands without Data Source and Panels on your subreports. You don't need this.

Thank you.

[prajan]

Hi,
I have modified the report and was able to get a better excel format output this time.
But I can still see some rows are merged. I am not sure what I am missing. Can you please help me.
Please see the issues highlighted in red and yellow.

Issues in report.JPG (61.74 KiB) Viewed 3209 times

Thanks

[HighAley]

Hello.

Please, try to set next static option:

Code: Select all

StiOptions.Export.Excel.DivideBigCells = false;

Thank you.

[prajan]

Hi,
I am using StiWebViewer. How do I set the options there.
This is the code

Code: Select all

            StiReport report = CreateBSReport();
            report.Render(false);
            StiWebViewer1.Report = report;
            StiWebViewer1.ZoomPercent = 60;                        
            StiWebViewer1.ShowZoom = false;
            StiWebViewer1.ShowFirstButton = false;
            StiWebViewer1.ShowLastButton = false;
            StiWebViewer1.ShowNextButton = false;
            StiWebViewer1.ShowPrevButton = false;
            StiWebViewer1.ShowBookmarksButton = false;
            StiWebViewer1.ShowViewMode = false;
            StiWebViewer1.ShowParametersButton = false;
            StiWebViewer1.ShowCurrentPage = false;                          
            StiWebViewer1.ViewMode = StiWebViewMode.WholeReport;            
                

Please let me know.
Thanks.

[HighAley]

Hello.

You could set this option anywhere before export.

Thank you.

[prajan]

Hi,

The user views the report in the StiWebViewer and selects the export option from there.
The export doesn't happen programmatically. It happens when the user clicks on Save and selects Excel in the options under Save.
Please let me know how the StiOption can be set in that case.

Thanks

[HighAley]

Hello.

Please, set the option in the Page Load event.

Thank you.

[prajan]

Hi,
That has not helped either.
Is there something else that I need to do to get this fixed.
Please let me know.

Thanks

[HighAley]

Hello.

The height of rows on the sub-reports is different. So there is no other way to export such report to Excel.

in the green area

rows.png (201.84 KiB) Viewed 3192 times

Thank you.