grouping based on dob

[msnarayanan]

dear all



i have created a report based on query.

i have made three groupings - 1. Family Name 2. Generation 3. Father's Name

while the report shows correct data pertaining to each group, the "Father's Name" group
does not feature based on date of birth.

I want this group is indicated in that order based on the date of birth.

can i make a conditional grouping?

thanks

m s narayanan

[June7]

Don't really understand the issue. What does 'group does not feature based on date of birth' mean?

Not sure you really need a Father's Name group. Can there be more than one Father for each Family/Generation?

What data is in the Detail section?

[msnarayanan]

Don't really understand the issue. What does 'group does not feature based on date of birth' mean?

Not sure you really need a Father's Name group. Can there be more than one Father for each Family/Generation?

What data is in the Detail section?

dear sir
i am really sorry i have not made my issue understandable.

in the "detail" section i have the following fields.

name age wife name father name

suppose there are three children through "father", in the table i key the names as follows:

name (of the first child) xxxxx ageL date/time field wife name: yyyyyyyy father's name: zzzz
(second child) aaaa zzzz

simiarly the second son has three issues
the same thing is repeated - but the father's name differs.

to get over this issue, i just added serial nos. before "father name" it worked.

what i want to know his whether grouping can be done in relation to the date of birth.

hope i have made my issue somewhat clear.

expecting your advice

thanks

m s narayanan

[June7]

Think would need a compound value of FatherDOB_Name. Instead of group on Father's Name, group on an expression that concatenates the two values. This is in case multiple fathers have same DOB. The date must be formatted as YYYYMMDD. So like:

Format([DOB], "YYYYMMDD") & FatherName