Creating reports and dashboards | Stimulsoft community forum

I have a few reports to export to Excel and CSV. The format of the reports is as follows:

Report Title Band:
- 2 TextBoxes with the header

HeaderBand:
- Headers for each and every column that I need to display in the databand

Data Band:
- Values being populated from the datasource. The datasource is a stored procedure

Report Summary:
- Textboxes with calculated values based on what the databand has to display

Page Footer Band:
- Page number and just a disclaimer.

Excel and CSV Requirement:
- Export the Report Title without the formatting (once)
- Export the HeaderBand without the formatting (once)
- Export the Values in the databand without the formatting
- Export the calculated textboxes without the formatting
- Export the Page footer without the formatting (once)
- No page breaks or empty columns in the exported file

Problem:
- Exported Excel doesn't export the Report summary band
- Exported CSV and Excel exports with formatting (How can formatting be saved if it's a csv?)
- Export Excel with only the Report Header and no footer.


Can someone help me with this?? Why is it so hard to just export the data unformatted by default without empty columns between 2 values? This is an amazing software but can you please provide more options before exporting it off or perhaps ways to change the settings so that those things don't happen? Currently you have options to export data only or use one page header and footer but more options are required to overcome the issues that I am talking about.

Solution:
- Another property in each and every element which says "Exportable = True/False" and a sub property of Exportable which is "Formatted = True/False".
- Don't export the spaces between 2 data values as empty columns, just another cell would do.

One more thing... the export option exports lots of empty rows as well (between the report summary and the page footer band). Can that be fixed as well?

I keep coming up with issues, don't i!?!

CSV doesn't export the calculated values either.

I have changed the report summary to Column Footer Bar yet the same issues remain....

Hello,

KaranSeth wrote:Problem:
- Exported Excel doesn't export the Report summary band

We couldn't reproduce this bug. Can you please send us a sample report with data, which reproduce the issue?

KaranSeth wrote: - Exported CSV and Excel exports with formatting (How can formatting be saved if it's a csv?)

In Csv, Dbf and Xml only textboxes from DataBand are exported, without any formating.

KaranSeth wrote: - Export Excel with only the Report Header and no footer.

Unfortunately, we do not have plans in developing this feature.

KaranSeth wrote:Can someone help me with this?? Why is it so hard to just export the data unformatted by default without empty columns between 2 values?

Please check the UserManual.pdf from our site, article "5.10 How to create a report for export?"

KaranSeth wrote: - Another property in each and every element which says "Exportable = True/False" and a sub property of Exportable which is "Formatted = True/False".

Unfortunately, we do not have plans in developing this feature.

KaranSeth wrote:CSV doesn't export the calculated values either.
I have changed the report summary to Column Footer Bar yet the same issues remain....

In Csv, Dbf and Xml only textboxes from DataBand are exported.

Thank you.

Thanks for your help. I will just override the existing button in the viewer and post my own code. Beautiful software but a few drawbacks.