Firebird 1.5.1 and ReportBuilder Pro

rbuser

I am trying to upgrade to version 1.5.1 of the firebird database. I am
having problems with some of my more complex reports built using the end
user reporting tool.
In version 1.0.3 of firebird they run just fine but since switching to
fb1.5.1 they hang on accessing data.

I have several linked Queries in one particular report.
I have tried to preview the queries in the design mode under the Data tab
and I can view them if I remove the links.

Is there something else I have to do to make this work?

any help appreciated.

nardmoseley

When DADE dataviews are linked, there is special linking SQL that is
generated for the detail dataset. Perhaps the newer firebird database engine
is having an issue with the linking SQL. See the following article for more
details on viewing the linking SQL.


-------------------------------------------
Tech Tip: Linking DataViews
-------------------------------------------

Overview
---------

Linking DataViews in the ReportBuilder Data workspace (DADE), requires that
the detail data be sorted by the linking fields. When DataViews are linked,
DADE generates special linking SQL for the detail DataView. The linking SQL
(Magic SQL) can be viewed by positioning the mouse over the DataView window
and pressing Ctrl + Left Mouse button. The results of the Magic SQL query
can be viewed by pressing Shift + Left Mouse button.

ReportBuilder's DataPipeline architecture includes support for linked data
traversal. Whenver the record position of the master data changes, the
traversal logic compares the master and detail field link values and then
determines where to locate the record position for the related detail data.
The linking logic will only work properly if the Database engine's collation
of the detail query result set is in sync with ReportBuilder's internaly
field link comparison logic.

--
Nard Moseley
Digital Metaphors Corporation
http://www.digital-metaphors.com