nardmoseley
Comments
-
- set the subreport PrintBehavior to pbFixed and resize the subreport
boundary to accomodate the contents
- the Footer is not dynamic height and at this time, a Static height band
cannot accodate Stretchable objects. A p… -
- make sure that you either use DataSet linking or DataPipeline, but not
both
- see RBuilder\Demos\Reports\Demo.dpr for examples of master/detail/detail
- if you would like to submit an example for review, please em… -
- check that the data linking relationships are properly defined - see tech
tip article below
- check that the main report and childreport DataPipeline properties are
properly assigned
------------------… -
- when defining a link, make sure that you drag the field from the detail to
the master (i.e. do no drag from the master to the detail). When the link
draws, there will be a 1 by the master and an infinity sign by the detail.
… -
- as a test try commenting out the event-handler code 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 still have an … -
- for a master/detail linking relationship, you can use the Linking dialog
from the Data workspace to specify that you want to include master records
in which no corresponding detail exists.
- the Report and ChildReport … -
- As a quick fix, try setting Report.CachePages to true.
- always use TppVariable components rather than global variables. See the
Calculations thread of the Tech Tips newsgroup and the ReportBuilder
Developers Guide tut… -
One alternative approach to relying upon the report traversal process to
perform the calculations is to use SQL to create a summary query.
Thanks for the feedback...
--
Nard Moseley
Digital Metaphors
The DBCalc.Compute method is called by the repot.engine traversal process.
Each report/childreport has its own report engine. The childreport engine is
traversing the data that you want to perform the calculations upon. A
chi…
- Use TppVariables for the subreport and main report totals.
- In the Subreport Variable.OnCalc, increment the main report's variable
procedure VarSubReportOnCalc(Sender: TObject, var Value: Variant);
begin
You need a master/detail setup. Try creating a summary query that can
display the summary amount in the detail band. As you describe, the
limitation is that the clickable link needs to be in the same band as the
drill down s…
I recommend using the BeforePrint event of the band in the main report (the
band that contains the subreports.)
The BeforeGenerate event occurs too late.
--
Nard Moseley
Digital Metaphors
www.digital…
The Data workspace does not currently support a Copy/Paste of dataviews.
You might try using File | Export to save the data module to a .dtm file.
Then select File | Merge. However, be aware that will save all of the
dat…
For the main report, remove the header/footer bands, so that there is only a
detail band.
Main Report - no datapipeline assigned
detail
section1
section2
...
sectionN
Try using ndBlankReport for subreport2.
I also recommend updating to RB 10.06.
--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
To include the master record in the report when corresponding detail records
exists, set the detail DataPipeline.SkipWhenNoRecords property to False.
--
Nard Moseley
Digital Metaphors
www.digital-metaphor…
Below is an artice on linking queries. (Do not use the AfterScroll event).
------------------------------------------------------
Tech Tip: Linking SQL Queries for Master/Detail Data
---------------------------------…
RB 7.04 was the last produced release for RB 7.x. Check the Help | About box
of the report designer to determine what version you are using.
Check the detailband.PrintHeight is set to phDynamic for all subreport.
As…
Report and ChildReport share a common ancestor - CustomReport. However,
Report adds events for handling the report generation process - one of which
is BeforePrint. When assigning Report to SubReport, it is treated like a
Chi…
- Place a Shape in the detail band, set ParentWidth and ParentHeight to true
and SendToBack.
- For the Shape.OnPrint event code
myShape.Visible := not(myShape.Visible);
--
Nard Moseley
…
Trial versions are limited to 5 pages of output - this is noted on the trial
version download page.
There is no limit to the number of subreports that can be used to create a
report layout.
I recommend purchas…
1. Using PrintToDevices
if myReport.InitializeParameters then
myReport.PrintToDevices
2. Using Print
uses
ppTypes;
myReport.DeviceType := dtPrinter;
myReport.ShowPrintDialog…For the detail DataPipeline set SkipWhenNoRecords to False
--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
mySubreport.ParentPrinterSetup := False;
mySubreport.Report.PrinterSetup.BinName :=
mySubreport.Report.PrinterSetup.BinNames[0];
--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
If you have two subreports set to PrintBehavior of pbSection, then each
subreport can have a separate printersetup.
You can set subreport.ParentPrinterSetup to False.
a. At design-time you can access the workspace f…
Try putting all 5 subreports in the detailband and then use the
DetailBand.BeforePrint event to toggle the subreport visibility.
Avoid loading subreports while the report is executing - the report engine
initializes all…
RB 11 adds new features that enable this to be accomplish without writing
any code. The query search criteria can bound to report parameters. The
report parameters can be designated as AutoSearch. In this way you can have
one…
There are no known issues such as you describe.
What is your environment? Windows version, Delphi version, database, data
access components, etc.
As a test try commenting out all event-handler code associated with t…> Thanks for coming back. I'm doing it all within RAP and the FreeModules
Ok, well you do /not/ want to call FreeModules from RAP - that will free the
codemodule and datamodule. There is only one datamodule - it belongs to the
You could try adding a line to clear out the data, prior to loading the
report. Perhaps that will help
// clear data
myReport.FreeModules;
// load the reports
--
Nard Mo…