nardmoseley
Comments
-
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…
A couple of options to try:
1. Set the subreport.Band to nil to remove it from the report.
2. Set subreport.DataPipeline to nil to disconnect it from the datapipeline.
If the data-aware component in the subreport suc…
No. That is up to you to determine. There are many factors that can affect
performance. The complexity of the report layout is affected by number of
subreports and also by factors such as the number of KeepTogether objects,
Stre…
You can optionally create the group in the childreport rather than the main
report - that would make it an easy DBCalc.
The older architecture caused mass confusion for most customers. The current
architecture does not - y…
One option might be to use a group that breaks for each detail line and is
configured to reprint its header on subsequent pages. That would require
that you place the memo in the group header band, so it might not suit your
nee…
To control whether the master record prints when there are no detail
available, you need to set the detail DataPipeline.SkipWhenNoRecords
property to False.
When using Dade, you can do this via the Link dialog. Access the …