Data selection

[akar33]

Hi there,
This issue of mine really getting complicated.

My data set looks like this
ID, AlternateID, first_name, last_name, birth_date

1,5,Tina,Roy, 05-15-01
2,5,Reena,Roy, 05-20-02
3,5,Mona,Roy, 05-25-02
4,6,Rose, Lippa, 06-02-04
5,6, Megan, Lippa, 07-04-03

The report is grouped by ID (top level of grouping) and AlternateID.

The outcome requested is, if it is the first record(1,5,Tina,Roy, 05-15-01)ten in the AlternateID grouping
only
2,5,Reena,Roy, 05-20-02
3,5,Mona,Roy, 05-25-02
should be displayed, meaning by in the AlternateIDgrouping it should not display the data set in the ID grouping (1,5,Tina,Roy, 05-15-01)


I hope this informs helps any of you to help me.

Thanks

 

[michbell]

Not sure about what you want to display. Could you write a longer example of what's displayed right now and what you want it to display?

 

[kwalters110]

Question, do you want the names to be unique? for example, if the first record on the report is (1, 5, Tine, Roy, 05-15-01) and then in the sub group it shows Reena and Mona, do you still want it to show them again later? Like showing every record, and then showing all of the related records (using alternate id) below them.

If that is the case then you could go into the visual linking expert add the table with the data twice (the second table will be an alias). then you can join the two tables by their alternate id field. Then in the record selection tell it select when the main ID do not equal.

{table1.id} <> {aliased_table.id}

then you can group it by {id} and then by {alternateID}.

If thats not what you intended then perhaps you could elaborate more about the end result you want to achieve?