Multi Container Relational Report

[munishsethi]

Here we have three tables as Master, Addresses and Obligations. I want to show Master.FirstName, Addresses.Address and Obligations.Amount. I hav took two containers parallel to each other vertically till the end of the designer page.

In container 1, i placed Master table band and addresses table band. I hav selected the required fields and placed them in their respective bands. In Container 2 at right side, i hav placed Obligations band and then hav placed the Amount field in it.

My bands are properly related to each other.

Now when i execute the report, it does shows the data, but not in the required behavior. I mean to say , this data is not properly aligned parallel to each other. the required result was something like this

Mathew Hogan 200$
123 Street. NY
200$

200$

200$


Nicole Smith 500$
321 Stree, NY
200$

200$

I mean in the above data, i wanted to show that, incase if Mathew Hogan is related to four rows in Obligations, then the result must be like above. But wat i m getting is like this.

Mathew Hogan 200$
123 Street. NY

Nicole Smith 200$
321 Stree, NY

200$


200$


500$


200$


200$

So the Above output showed me that the bands are not related.( but i hav created relations) . So kindly suggest wat must be done here??/

[Edward]

Here we have three tables as Master, Addresses and Obligations. I want to show Master.FirstName, Addresses.Address and Obligations.Amount. I hav took two containers parallel to each other vertically till the end of the designer page.

In container 1, i placed Master table band and addresses table band. I hav selected the required fields and placed them in their respective bands. In Container 2 at right side, i hav placed Obligations band and then hav placed the Amount field in it.

My bands are properly related to each other.

Please check definitions of relations between DataSources, not only using of those relations for linking bands.

Now when i execute the report, it does shows the data, but not in the required behavior. I mean to say , this data is not properly aligned parallel to each other. the required result was something like this

Mathew Hogan 200$
123 Street. NY
200$

200$

200$


Nicole Smith 500$
321 Stree, NY
200$

200$

I mean in the above data, i wanted to show that, incase if Mathew Hogan is related to four rows in Obligations, then the result must be like above. But wat i m getting is like this.

Mathew Hogan 200$
123 Street. NY

Nicole Smith 200$
321 Stree, NY

200$


200$


500$


200$


200$

So the Above output showed me that the bands are not related.( but i hav created relations).

After setting relations between tables, please refer to the appropriate fields via relations. I mean {Products.Categories.CategoryName} where Categories is the relation between Categories and Products DataSources.

Also the principle of "parallel" data is not clear for me. Did you mean that one page contains one master row (Master) and all detail rows(Addresses and Obligations)?

Please send a screenshot of the desired result or mrt file of your report to for analysis.

P.S. Please note that when you using relations in containers, you should provide the following principle:

One rendered page - one relationship between containers, e.g.:

Page1

Master1 - Detail1.1
- Detail1.2
- Detail1.3
- Detail1.4

Page2

Master2 - Detail2.1
- Detail2.2
- Detail2.3


Thank you.