nardmoseley
Comments
-
Here is an rbWiki 'How To' that provides an example of creating a
spreadsheet style report and includes downloadable code.
in Report Builder Detail with columns instead of rows Comment by nardmoseley February 2010 -
Try putting the Variable in the DetailBand and setting Variable.Visible to
False.
--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
-
Please understand that Digital Metaphors can only provide tech support to
the Delphi developers that purchase ReportBuilder. Digital Metaphors
receives no distribution royalties from Delphi developers that embed
end-user repo… -
For the main report, I would create a summary query that uses SQL to calc
the summary values. Then the subreport can expand and show the detail from a
separate detail query.
--
Nard Moseley
Digital MetaphorsPlease update the 'from' in your postings to use your full name. Thanks in
advance.
Here is an rbWiki article with details about implementing JITPipeline
master/detail.
in Subreport and JITPipelines Comment by nardmoseley November 2010I'm not clear on what the requirements are and thus I am not clear on what
the issue is. Perhaps you can create a simple example using the DBDemos data
and send to support@ in zip format and then I can take a look at it.
Try placing a dotted Line at the top of the detail band. Implement the
Line.OnPrint event to toggle the visibility.
In RAP code this would be
myLine.Visible := Report.Detail.Count > 1;
--
…For a pbChild subreport try using either Title/Summary or
GroupHeader/GroupFooter rather than a page header/footer.
A pbSection starts on a new page and ends with a page break, which does not
sound like what you want.
Section style subreports are designed to print independently - for example
if you need to create a compound document that consists of many reports that
print as a single document.
Regions are designed to be simple contai…When subreport.PrintBehavior is pbChild (the default) you can use
ShiftRelativeTo to specify the ordering. For your example, place DBImage1
inside a Region. Set Region1.ShiftRelativeTo Subreport1 and set
Subreport2.ShiftRelativeTo …
The ability to connect the detailband to a datapipeline has been deprecated
and should not be used. Each report and subreport can be connected to
datapipeline. Use subreports to implement master/detail reports.
1. If define a master/detail relationship using the datapipeline fieldlinks,
then you must sort the detail data on the linking field(s).
2. See demo 112 (dm0112.pas) in the main demo reports application,
RBuilder\Demos\Rep…
Try calling Report.Reset prior to Report.Print. This should force RB to
flush its cached data.
--
Nard Moseley
Digital Metaphors
http://www.di…
Sounds like a problem with the DataTree not being updated when you use the
Query tools.
1. Try pressing the right mouse button over the DataTree tool window. Then
select the Refresh option.
2. E-mail the exact s…
Welcome to ReportBuilder.
ReportBuilder supports any TDataSet descendant and we have customers using
jus…
Please see the DADE newsgroup. There is a thread dated Feb 17, 2004 on this
very subject - the title of the thread is "DADE plugin for FIBPlust 5.x".
You may want to contact the originator of the thread.
Digital Meta…
The DBPipeline component can connect to any TDataSet descendant tha supports
bi-directional navigation.
To the use Query Tools from the Data workspace you need a plug-in. Looks
like there is one avialable for download that…
Compare your IBOPipeline code to TppDBPipeline (ppDBPipe.pas).
The report engine traverses data by using the Next, Prior, Last, First
methods and also the GetBookmark and GotoBookmark methods. Make sure you
have implemente…
The TextPipeline supports the standard Delphi TDateTime format - which is a
double. From the Delphi help for TDataTime:
type TDateTime = type Double;
The integral part of a Delphi TDateTime value is the number of day…
Correct. ReportBuilder does not support Unidirectional datasets.
If you use the Data workspace of the ReportDesigner with dbExpress, the DADE
plug-in for dbExpress will internally create a SQLClientDataSet as part of
the s…
1. Check that the datapipelines are Owned by the form/datamodule upon which
they reside. Also try placing them on the same form/datamodule upon which
the report resides.
2. Below is an article on datapipeline linking. It a…
Sorry, we do not have any information JET/ODBC settings. Try searching
Google and Google Groups.
We have only used the JET driver via Delphi's ADO to connect to MS Access
tables.
--
Nard Mosele…
The latest release, RB 7.04 does contain some fixes for linking with null
field values. Prior to this fix, the report would generate incorrectly -
however it would not AV or encounter the type of error that you describe. We
have…
When the report engine initializes, it will open each datapipeline used in
the report. It will then check to see whether the DataPipeline is Active.
Perhaps your dataset is raises an exception when DataSet.Open is called, or
per…
The TdaSQLBuilder class works in much the same manner as the QueryDesigner.
I would first try doing this using the QueryDesigner. Write down what steps
are necessary. For example, when using the Query Designer and you remove t…
You need to create a custom dataview class. For examples, see
RBuilder\Demos\EndUser\Custom DataViews. Also check out the DADE thread of
the Tech Tips newsgroups for an overview of the architecture.
You will want your cu…
For each dataset you need a separate DataPipeline. If the detail data is
embeddd in a blob field of the master, then you still need two
DataPipelines.
A DataPipeline can have any number of fields defined for it
(Da…
Correct, there is a DataPipeline.GetFieldAsStream method
--
Nard Moseley
Digital Metaphors Corporation
http://www.digital-metaphors.com
1. AutoSearchFields can be defined for any report.
2. The Report.OnGetAutoSearchFieldValues event fires after the user has
specified the search values. This event is typically used to apply the
values to the SQL where cl…
There is a tutorial on using the JITPipeline in the Developers Guide.
There are examples of the JITPipeline in the main reports demo. Run
RBuilder\Demos\Reports\Demo.dpr and check out the 'no database' section.
A JI…