Page display
Hello
Windown 7, RB 11.08 and Delphi 2010
I have a report that contains two subreports. The primary report is linked
to a Query component but contains no RBuilder components other than the
first subreport. The first subreport is linked to a ppDBPipeline connected
to a table of "Payors". The mastersource for the Payors is linked to the
main report's query component. The Payor table is order by an index
containing social security numbers. Each payor record generates only one
page of the report.
When the report executes, the page list on the left hand side displays the
payor social security number associated with each page and below that the
actual page number. The question is whether there is a mechanism for me to
in code change the displayed field for each page shown on the left hand side
of the report for one that I determine in code at run time. I am assuming
that the Social Security is displayed because that is the index field for
the Payor table, but I do not wish to change the index, just the displayed
fields.
TIA
John
Windown 7, RB 11.08 and Delphi 2010
I have a report that contains two subreports. The primary report is linked
to a Query component but contains no RBuilder components other than the
first subreport. The first subreport is linked to a ppDBPipeline connected
to a table of "Payors". The mastersource for the Payors is linked to the
main report's query component. The Payor table is order by an index
containing social security numbers. Each payor record generates only one
page of the report.
When the report executes, the page list on the left hand side displays the
payor social security number associated with each page and below that the
actual page number. The question is whether there is a mechanism for me to
in code change the displayed field for each page shown on the left hand side
of the report for one that I determine in code at run time. I am assuming
that the Social Security is displayed because that is the index field for
the Payor table, but I do not wish to change the index, just the displayed
fields.
TIA
John
This discussion has been closed.
Comments
You can take complete control over the report outline using the
Report.OnOutlineNodeCreate event. Use the aNode parameter to check and
change the value of each node as it is created. For instance...
if aNode.Caption = Report.DataPipeline['SSNumber'] then
aNode.Caption := Report.DataPipeline['FullName'];
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Great. Thanks
A corollary question regarding how far can the node issue be expanded. Is
it possible to:
a) attach a check box to the node
b) set the value of the check box to true when node is generated at preview
c) allow the node check box to be "unchecked" at preview then
d) when the report is printed allow only the pages with a "checked" checkbox
to be printed.
This would essentially replace the print dialog print "page range" with the
converse scenerio, ie. print all pages except those "unchecked". It would
be very useful in situations such as billing where there may be hundreds of
bills, and one wishes to print all but a selected few.
TIA
John
That would be a cool feature but ReportBuilder currently does not have any
built-in support for it. I will add this to our list of possible
enhancements for a later release. A different approach would be to use the
AutoSearch feature of ReportBuilder to automatically filter the dataset
before printing so only the needed records are printed/viewed. Take a look
at the Autosearch demos located in the \Demos\AutoSearch\... directory.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com