nardmoseley
Comments
-
Please see the following tech tip which explains two types of query linking.
The second type provides much faster performance - queries are only fired a
single time.
------------------------------------------------------Thanks for the additional info. ReportBuilder does not currently support
DataPipeline linking on GUID fields. If you need to establish a linking
relationship on a GUID field, try using the Delphi Query linking. I think
you need to use…
Have not heard of this before. Sounds like a data linking issue, though I do
not know why it would only manifest itself for the Fixed style subreport.
Note that there are two ways to link datasets in ReportBuilder: Delphi
TDataS…
This is not a known issue or one that has been reported before. The PageSet
numbering requires that the Report.PassSetting be set to psTwoPass. This
requires that all subreports also be set to two pass.
The RBuilder\Demos\…
There are two approaches to linking queries - see the article below. The
second approach, RB DataPipeline linking will result in faster performance -
try that.
------------------------------------------------------
Te…
Any DataSet that you want to include in a report requires a TDatasource and
DBPipeline.
If you have RB Professional or Enterprise you can use the Query Tools
available on the Data workspace of the ReportDesigner to visuall…
The RichText mail merge feature does not support the formatting of datafield
values.
Some Options:
1. Write custom code to programmatically merge the dbfield data. For an
example see demo 29 (dm0029.pas) located…
Below is an article that you might find helpful. Also, check out the
additional articles in the Data Access thread of the Tech Tips newsgroup
----------------------------------------------------
Tech Tip: Use Master/Detail…
A drill down report is essentially a master/detail report in which the
detail is only displayed when the user interactively clicks on the drill
down component to expand the detail.
On the Data side of things you need a sum…
You need to define a master/detail linking relationship between the totals
and the detail. Please the followig article.
------------------------------------------------------
Tech Tip: Linking SQL Queries for Master/…Section style subreports print in z-order. You can view the z-order by
selecting View | Toolbars | Report Tree. You can modify by position the
mouse over a subreport, pressing the right mouse button and select
BringToFront and SendToB…
You must subreport.PrintBehavior to pbSection. Only section style subreports
can have a different orientation than their parent. Section style subreport
always start on a new page and print on their own page space. Child
subrepo…
If you Group on a Label or Variable use the OnGetText event rather than
OnPrint or OnCalc. Due to timing of event firing, the OnGetText will work
much better.
--
Nard Moseley
Digital Metaphors Corporation<…
As a test try commenting out all event-handler code that is associated with
the report. Make sure that you do not have any code that manipulates the
dataset in any manner while the report is generating.
if you have a maste…
Try using the Subreport OverFlowOffset property. The following is from the
online help topic for OverFlowOffset...
Description
Use the OverFlowOffset property to define the vertical space that should be
ab…
Below are 2 articles that address this question. (note: These articles are
from the Calculations thread of the Tech Tips newsgroup).
------------------------------------------------------
Tech Tip: Calculating a Summary ba…
Thanks for providing that solution. I tried adding similar code to the
example and it resolved the issue there as well.
in A Question About Dynamic Loading SubReports
Comment by nardmoseley
June 2004
I can recreate that issue here. Therefore you have discovered that the
example has problems. Sorry about that. I traced the RB source code and even
attempted a couple of mods, but have not found any solution yet....
…
This example shows another approach, which is to use reference style
subreports. It is much simpler.
www.digital-metaphors.com/tips/SubReference.zip
--
Nard Moseley
Digital Metaphors Corporatio…
Check out the Code Based thread of the TechTips newsgroup. There you can
find articles with sample code. You are not creating the reports in quite
the correct manner. The Owner of all report elements should be the
form/datamodul…
That is probably as good a way as any.
The other way that comes to mind would something like
if (DataPipeline2.Bof and DataPipeline2.Eof) and....
--
Nard Moseley
Digital Metaphors Corpora…
1. Check out the Code Based thread of the Tech Tips newsgroup for examples
of creating repprts in code.
2. You can call Report.CreateDefaultBands to create a default set of bands.
For subreport of type pbChild, this will c…
Only a section style subreport can print in a different orientation than the
main report. A subreport set to to PrintBehavior of pbSection will be
definition start and end on its own page space.
If you need a report conist…From the Report Designer, select Report | Data. Then from the dialog select
the option for .
--
Thanks for supporting ReportBuilder! Please vote for ReportBuilder in the
Delphi Informant Readers Choice awards!<…
For the detail DataPipeline set SkipWhenNoRecords to False.
The following is from the online help topic for the SkipWhenNoRecords
property:
This property applies only to the detail DataPipeline of a master/detail
1. If each subreport were connected to a query that contained only the
relevant records, then by default the subreports would not print when there
are no related detail records.
2. With the current data configuration you n…
Can you explain further. Is this a master/detail report. Are the subreport's
set to pbSection or pbChild. Which subreport has the title - both of them?
Have you considered creating separate queries for each subreport. The
…
Can you provide more details about the report. Is the subreport a summary
report or part of a master/detail relationship, ...? What is the calculation
in the main report, at what point does the calculation occur. What does the
r…
The Grouping feature requires that the data is sorted on the grouping
datafield value. When the datafield changes, a group break is generated.
If you are grouping on data field of type String, be aware that the
comparison …
1. The report engine will open all of the datasets associated with the main
report, data-aware controls and childreports. If you have subreports that
you want to conditionally suppress prior to generating the report, then you
co…