Page 1 of 1
Exported excel format of report not fine
Posted: Mon Apr 07, 2014 6:49 am
by 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
Re: Exported excel format of report not fine
Posted: Mon Apr 07, 2014 8:45 am
by 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.
Re: Exported excel format of report not fine
Posted: Wed Apr 09, 2014 8:51 am
by 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 3206 times
Thanks
Re: Exported excel format of report not fine
Posted: Wed Apr 09, 2014 9:45 am
by HighAley
Hello.
Please, try to set next static option:
Code: Select all
StiOptions.Export.Excel.DivideBigCells = false;
Thank you.
Re: Exported excel format of report not fine
Posted: Wed Apr 09, 2014 10:58 am
by 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.
Re: Exported excel format of report not fine
Posted: Wed Apr 09, 2014 11:55 am
by HighAley
Hello.
You could set this option anywhere before export.
Thank you.
Re: Exported excel format of report not fine
Posted: Wed Apr 09, 2014 12:07 pm
by 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
Re: Exported excel format of report not fine
Posted: Thu Apr 10, 2014 9:59 am
by HighAley
Hello.
Please, set the option in the Page Load event.
Thank you.
Re: Exported excel format of report not fine
Posted: Thu Apr 10, 2014 11:44 am
by 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
Re: Exported excel format of report not fine
Posted: Fri Apr 11, 2014 7:19 am
by 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 3189 times
Thank you.