DataWindow Within DataWindow

[FontanaS]

I have two seperate datawindows.

1- Retrieves all user information
2- Retrieves all user organization information

They are seperate tables also.

The problem is that I want both data windows nested into one.

The First data window (1 - above) is the main (parent) one. And the second one (2- above) will be the nested child data window.

I eventually will link them based on user id, but for now I cannot figure out how to get the second datawindow into the first one.

THANKS

 

[rt63]

You have two options depending on the requirements.

1. If you are retrieving data for a specific user (i.e only one user at a time) and the user_id is going to be a retrieval argument for the datawindow, then create a composite datawindow where you can put both datawindow 1 and datawindow 2 (insert report option like inserting any other object like text, line etc.) and define user_id as a retrieval argument for the composite datawindow. This argument can then be passed to the two child datawindows.

2. If you have multiple rows in the first one and for each row in the first you want to display details in the second, then you should create a nested datawindow. You can insert a report object in the detail band and in its properties, set the dataobject as datawindow 2. Define a user_id retrieval argument for this report object and link it with the column user_id of main datawindow through its expression property.

These are some common steps for creating nested datawindows. You can get more info if you search thru help on composite and nested datawindows.

RTewari