Supported Levels of Subreports
How many levels of subreports are supported in RB9? I ask because I'm
running into a problem getting subreports more than 2 levels deep to print
anything on the lower levels. I've verified that the data is being
retrieved from the tables via the DataView previews, that the subreports are
connected to the correct dataviews, and that they are set to visible. I can
get 4 subreports deep if the subreports are not connected to dataviews, but
it stops at 2 deep when I start connecting them to dataviews.
Am I running into a limitation of the number of subreports or something
else?
--
---------------------------------------
Terry Swiers
Millennium Software, LLC
http://www.1000years.com
http://www.atrex.com
Atrex Inventory Control/POS -
Big business features without spending big business bucks!
Atrex Electronic Support Options:
Atrex Knowledgebase: http://www.atrex.com/atrexkb.asp
Email: mailto:support@atrex.com
This discussion has been closed.
Comments
There is no limit. You are encountering something else.
It might be related to the data. I assume you have linked dataviews that are
also four levels deep.
1. As a test, try unlinking all of the dataviews. Then test whether the
subreports show up at all. Then incrementally test by linking the first
level. Then add the second, etc.
2. By default, if a master record has no corresponding detail then the
master record will be skipped. You can modify this setting by
double-clicking on the link to access the link dialog.
3. See the article below. The Designer.DataSettings contains some setting
for Collation and GUIDCollection. These are used to create new dataviews and
then saved as part of the dataview. These are used to tell RB about how the
database is ordering the dataset.
-------------------------------------------
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
Best regards,
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
Yes, they do. It only stops working when the subreports are linked to a
dataview.
Yup. They are all set to outer joins. The data does show up correctly in
the dataview preview for each level.
I'll verify that this is not working correctly in a report built with stock
RB9 components. If I can reproduce it outside of our application, I'll send
the report and the data to the support email address for review.
--
---------------------------------------
Terry Swiers
Millennium Software, LLC
http://www.1000years.com
http://www.atrex.com
Atrex Inventory Control/POS -
Big business features without spending big business bucks!
Atrex Electronic Support Options:
Atrex Knowledgebase: http://www.atrex.com/atrexkb.asp
Email: mailto:support@atrex.com