Look up function?

rbuser

Is there any look up function in rrbuilder? Such as function (for eg) can
check the ID and the get the value by using look up function? Thanks.
And I did using groupband to make my report shows many details, but if using
multiple datapipelines, the outer group band details cannot change or
affect the inner group details that using oter pipeline follow the outer
group. I did try to set the outer group is master and inner group slave
pipeline or visa verses by linking the same field data or not. But the
outcomes makes me even cant see anything in print preview or produce
hundreds of report(orginal are 4 to 6 pages). Did i do something wrong?
Thanks

From Jes

nicocizik

Hi Jes,

1. Check out the AutoSearch feature of ReportBuilder. You can use this to
search the returned data and filter it anyway you like, or even use it to
"look up" a certain value and return true if the value exists. For examples
of using AutoSearch, please see the AutoSearch demos located in the
\RBuilder\Demos\5. AutoSearch\... directory.

2. Be sure you have the Report.AutoStop property set to True and that you
do not have your report and any subreport connected to the same
datapipeline. This will cause endless pages.

------------------------------------------------------
Article: TroubleShooting: Report Prints Endless Pages
------------------------------------------------------

Occasionally, we have customers state that their reports are in some
infinite state where page after empty page prints forever.

There are a few items to check when this occurs.

The TppReport.AutoStop property is the first thing to check. If this is
false when the DataPipeline property is unassigned, the endless report
will be the result. AutoStop is automatically set to True when
DataPipeline is set to nil, but it is possible to set it back to False.
Check for instances in your code where you might have created this
condition.

Another thing to check is that all subreports in your report have their
DataPipeline set. When a subreport does not have its pipeline set, you
will sometimes see a condition where the first detail record prints and
then you get blank pages.

Another, non-data related cause can sometimes be your margin settings.
If you have stretching bands that need to overflow to the next page, if
your margins are too tight, sometimes the report engine will endlessly
overflow to the next page trying to fit the overflow material.

Still another cause might be having a statically positioned control, set
to ReprintOnOverFlow, in the same band with a stretching control. For
instance, if you have a memo set to stretch and in that same band, a
label control set to ReprintOnOverFlow, then on every page after the
first, the memo will begin to print after the label control. If the
label is placed low enough that the memo has no room to print, the
report will forever be trying to print the overflowing memo on the next
page.


--