Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Nested Table Woes
Migrateduser
I have a report that uses 3 nested tables. (Parent<--Child<--Grand Child)
The query for the grand-child table is written so it returns a value if there is a match in the child table OR in the parent table.
When ever there is a record that has a relationship directly from the grand child table to the parent table nothing is returned. I think I understand why this happens, because the row for child is null, the grand child table is not created.
Since the parameter bindings for the grand child table allow you to link to either the child table or the parent table, so I figured my technique would work (or what's the purpose of showing both tables?).
Is there way to force the grand child table to always instantiate? Or some other technique to get this OR to work?
Thanks in advance!
Rob
Find more posts tagged with
Comments
There are no comments yet