Creating reports and dashboards | Stimulsoft community forum

Hi,

I want to disable the UsePageHeadersAndFooters check box of
stiReportViewer.InvokeReportSaveWord2007();
The reason for that is the exported file gets incorrect formatting if this option is used. If I leave it unchecked then the file gets exported correctly.
I checked below link and found that its by design that some changes happens when we check that check box. So for safer side I want the dialog box UsePageHeadersAndFooters unchecked and disabled.

http://www.stimulsoft.com/en/documentat ... 7_2010.htm
-If the checkbox Use Page Headers and Footers is on, it should be taken into consideration that, in this case, the height of the lines will be minimum allowable.


Could you please let me know how to do that?

Thanks
Shyam

Hello.

Unfortunately, it's impossible to disable the UsePageHeadersAndFooters option in export dialog.
But you could change the settings in ReportExport event.
It was added in one of our latest builds.

Thank you.

Hi,

Could you please let me know in which release onwards I can find The ReportExport event?
I tried in 2014.3 but could not find it.
It would of great help if you can demonstrate some code to disable UsePageHeadersAndFooters check box.

Please note that we don't want to do away with the setting dialog completely. We just want to control the UsePageHeadersAndFooters check box. because once set it resets the height of line to minimum allowable thus making the exported word file different that the report that is visible on reportviewer.

Thanks
Shyam

Hello,

Please check the last buil Stimulsoft Reports.Silverlight 2014.3.7 from 2015.01.30

Thank you.

Dear Aleksey

Can you tell me what following options does?

StiOptions.Export.Word2007.LineHeightExactly = true;
StiOptions.Export.Word2007.LineHeightExactlyForPHFMode = true;

I tried it for word export but I did not see any change in the exported document.

Thanks
Shyam

Hello.

Reports are exported to Word in Table mode.
This options specifies settings of Row height like on the image. If it is true, then the height will be set exactly, if it is false, then the row will set at least specified height. Thank you.

At below link
http://www.stimulsoft.com/en/documentat ... 7_2010.htm

its mentioned:
Notice: If the checkbox Use Page Headers and Footers is on, it should be taken into consideration that, in this case, the height of the lines will be minimum allowable.

Now if I check UsePageHeadersAndFooters and then set
StiOptions.Export.Word2007.LineHeightExactly = true;
StiOptions.Export.Word2007.LineHeightExactlyForPHFMode = true;
in my code then the height of line should not change.... but its still changes the row height to minimum and that changes the formatting of the report.

My understanding was that these Options should be there to override some default behaviour, in this case it the row height, but its is not.
Can you please let me know does this options can override row hight settings when using UsePageHeadersAndFooters ?

Thanks

Hello.

Let me explain how the Row settings work in Word.
You could see the difference if the text is not fit in a cell.
Here is a sample report template, which we exported with three settings. 1. The Use Page Headers and Footers setting is false. The LineHeightExactly setting is true by default. The cells do not grow in height. 2. The Use Page Headers and Footers setting is true. The LineHeightExactlyForPHFMode setting is false by default. The cells grow in height. This is noticed in our manual. 3. The Use Page Headers and Footers setting is false. The LineHeightExactlyForPHFMode setting is true. The cells do not grow in height. We guess that you understand how it works now.

Thank you.