nardmoseley
Comments
-
- 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…> I've long had an issue where if you go to File|New to start a new report,
By design, File | New does not clear out the data.
Perhaps in the future we could add a preference or another option to clear
out the data.I recommend updating to RB 11 for D7.
RB 11 automatically starts the second duplexed copy on a new page.
RB 11 can open and run reports created by prior versions such as RB 7.
RB 11 also includes a PageBreak componen…As a test, try building the same report via the designer, you will get the
same result.
1. A pbChild style subreport prints on the parent report's page space, the
page Header/Footer are not supported. As an atlerative, use Title…Mark,
Not trying to pick on you, but
1. It is against the newsgroup rules to post attachements. Please read this
page.
http://ww…Please do not post screenshots or attachments to the newsgroups. Attachments
can sent to support@.
To delete a DataView, press the right mouse button while positioned over the
DataView and then select the Delete option from th…