nardmoseley
Comments
-
Philip,
For RB 15 new properties were added for exactly this purpose,
XlsSettings.IncludeSingleHeader, IncludeSingeFooter.
Best regards,
-
Nard Moseley
Digital Metaphors
www.digital-metapho… -
You can implement the Report.OnFileDeviceCreate event to set the
DefaultBands property.
Example:
uses
ppTypes,
ppXlsDevice;
if ppReport1.FileDevice is TppXlsDataDevice then
TppXls… -
Carlos,
XlSSettings IncludeSingleHeader/Footer apply only to XLSData. This is
working as designed and as noted in the RBuilder help topics for
XLSSettings.IncludeSingleHeader/Footer . By definition XLSReport exports
repo… -
Ralf,
Give RB 15.02 a try and post a follow up here. (RB 15.02 contains some mods,
though not the specific mod you requested. )
According to the Windows docs, dmFields indicates whether the specified
member is initi… -
From the What's New for RB 15 feature list...
- XLSReport.IgnorePageHeight property,
when True prevent blank rows from being added to bottom of page
Complete RB 15 feature list
rbWiki
in Crosstab and page breaks in XLSReport Comment by nardmoseley December 2013 -
I'll add this to the requested feature list.
Thanks for the feedback,
-
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
-
David,
ReportBuilder has two XLS export devices: XLSReport and XLSData.
XLSReport exports report pages - it tries to duplicate what you would see
when generating to preview/print/pdf. For RB 15 we added an
XLSSettin… -
For RB 15 we added the XLSSettings.IncludeSingleHeader and
IncludeSingleFooter so that no coding would be required to accomplish this
behavior.
For earlier RB versions, you can implement code in the Report.BeforePrintHi Ignacio,
Check out the RBuilder help topic for TppXLSDataDevice for details on its
use. The default behavior is that only the detail band items are exported.
You can use the File | Print To File Setup dialog to specify whic…Thanks for the feedback.
An 'HtmlTable' based device is on our ToDo list. Based on priority and
resources it remains to be determine when that will get done. Using tables
provides much less accuracy. It's only useful because s…Hi Dima,
What are trying to accomplish?
TppHtmlDevice is meant to be a simple device that produces a single html
page that contains the report pages and embeds the style info in the html
document. By design it does …Hi Dima,
Thanks for the feedback. This will be considered for RB 16 and beyond.
Best regards,
-
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
Hi Paul,
Sorry for not responding earlier - I did not see the original post, my
mistake.
I tried a simple test here and did not encounter an issue. I created a
DBText connected to the AmountPaid (currency) field of …Hi Nicholas,
An XLSSettings property to control this is being add for RB 16.
Currently there is no way to do it.
Best regards,
-
Nard Moseley
Digital Metaphors
www.digital-metaphors.…Hi Nicholas,
For RB 15.05 the XLSData exports Memos by preserving blank lines, removing
CR/LF, allowing the Cell to wrap the text. There are no spaces added. This
is done because the Memo.Width has to be mapped to one or more…Hi Ton,
To optimize performance RB caches the list of installed printers. You can
use the following code to refresh the printer list while the application is
running.
uses
ppPrintr;
ppPrint…Hi Tom,
For RB 16.0, I'm creating a patch
For RB 15, a work around is to assign the DBText/Variable DisplayFormat
property.
RB translates Delphi display formats to Excel compatible formats and adds
them t…Hi Paul,
I tested with RB 15.05 and RB 6 and did not encounter any issues.
I used a TppVariable with DatatType dtCurrency and implemented the OnCalc to
set the value to -100.00. I have a USA machine, so currency format fo…Hi Frederick,
ReportBuilder is not aware of local vs networked printers, or the type of
networking. Windows and the Printer driver handle all of that.
ReportBuilder <--> Windows API <----> Printer Driver
…Hi Paul,
RB 15 introduced the Duplex dpDefault option, but left the default as
dpNone. For RB 17 we can consider changing to dpDefault for new reports.
Existing reports need to be left as dpNone for backward compatibility.
Hi Steve,
For XlsData only the detail band elements are exported by default. You can
use the File | Print To File Setup dialog to configure the bands and
elements to export. For subreports, select the childreport workspace and…This is a multi-part message in MIME format.
Hi Nicholas,
You might try using Label or DBText with WordWrap set to False.
Memo always wraps text, there is no way to turn that off. This occurs during
report generation, when the Page.DrawCommands[ ] are generated. The…Hi Chris,
The Xlsx and Xls devices export the data value, data type, and display
format as separate cell attributes. For custom display formats, Excel will
not know what do with those. Below is some sample code you can use to …Hi Jonatan,
Here's a simple example:
uses
ppTypes;
myReport.DeviceType := dtPDF;
myReport.TextFileName := 'c:\myReport.pdf';
myReport.ShowPrintDialog := False; // suppress print dialog
myReport…HI Kjell,
Create a simple report like that.
Export to XlsData/XlsxData, the Excel spreadsheet will have 3 variable width
columns
Export to XlsReport/XlsxReport, the Excel spreadsheet will have fixed narrow
Hi Kjell,
The XlsxData and XlsData devices export the data in a simple column format.
For details check out RBuilder Help topics for TppXlsxDataDevice or
TppXlsDataDevice
The XlsxReport and XlsReport devices export …Hi Paul,
- There are only a few standard web fonts, if those are not used, then text
is generated as a graphic. For details check out
TppXHTMLUtilities.IsStandardWebFont in ppXHTMLUtilities.pas
- Label, Variable, DB…Hi Eric,
There is no support for Excel formulas.
Please configure your newsreader client to post using your full name. That
is a requirement of the newsgroups.in Excel Formula Comment by nardmoseley November 2016
Hi Terry,
At one time it worked, but was later removed because Excel added stricter
validation for XLS that would not validate ReportBuilder's exported XLS
files. Going forward I can research adding support for the Xlsx format…