Relational Reports?

[Genx]

I wasn't quite sure where to put this so just hear me out first...I'm ok with general relation database theory but i have real problems when it comes to reporting certain information...

Righto Lets say i have two tables:

Table 1

- ID 1 (Unique)

- Date Field 1

Table 2

- ID 2

- Date Field 2

The relationship is structured as such:

ID 1 = ID 2

& Date Field 1 <= Date Field 2

So basically i want to filter out all the records that don't meet the criteria of the relation ship... and present a report laid out something as such:

ID 1 (Record 1)

ID 2 Date Field 2

ID 2 Date Field 2

ID 1 (Record 2)

ID 2 Date Field 2

Finally to the question... what goes where? what goes into the body, the subsummary part, which TO should the report be set to? etc etc...

Im sorry if this is a bit unclear but... sigh, any attempts at help would be appreciated

Cheers, Genx

[Genx]

... I'm going to assume due to the lack of responses that it is most likely not possible to do it this way so i am going to resign to using a simple calculation field that sets to yes if Date Field 2 is >= Date Field 1...

Thanks for at least having a look...

Genx

[-Queue-]

Try the attachment on for size.

SampleReport.zip

[T-Square]

Your example is really unspecific, which makes comment tough. Let me try, though:

When I am trying to build a complicated report, I have found that you have to build the report from the perspective of the finest granular data. So if I am making a report that lists Services by Client, I build the report on the Services table, with data from Clients brought in by relationships. In your example, use Table 2 as the basis of the report. Create a subsummary when sorted by T1::ID 1 and put everything related to the T1 record there. Then put your T2 data in the body element.

HTH.

David

[Genx]

Thanks Queue, even though i know my example wasn't that great / specific, that filtering script was exactly what i was looking for

Cheers for all help, Genx