Subreport...Subreport..Subreport and Ugly data display!

[marydn]

If I have a Tenant Lease and this lease can have multiple amendments as well as multiple terms is there any way I can represent this in a SUBREPORT without leaving out any data or repeating any data? I would also like to keep it in a neat order. For example,

Tenant #01 Name - Tenant 1
-----------------------------
Amendments:
$200 1/1/2001
$300 1/1/2002
$400 1/1/2003
-----------------------------
Term:
12/1/1999 5 years
1/1/2004 5 years

----PAGE BREAK----------------------------------------------

Tenant #02 Name - Tenant 2
-----------------------------
Amendments:
$200 1/1/2001
$300 1/1/2002
$400 1/1/2003
-----------------------------
Term:
12/1/1999 5 years
1/1/2004 5 years



I have tried grouping the data, but it splits the data in a way that I get one amendment then one term, etc....It looks horrible. I tried something that actually worked out visually, but it only gave me one value not all of them.

I am using version 8.5 and my datasource is several views that are linked together in the report.

Please keep in mind that this report is already a subreport so I cannot create subreports for a subreport.

Any help would be greatly appreciated!

M.

 

[Madawc]

When I want to use Group but don't like the order, I use a formula field derived from the value and make that the group.

E.g. types are A, D and M but I want the order to be A, M and D, I set formula values of 1 for A, 3 for D and 2 for M.

If you already have a group, create the formula and then use 'change group' to get the new field Madawc Williams
East Anglia
Great Britain