Problem in Creating Report ...

[HadiRezaee]

Hi all,
I have to make new report, i have problem in that, too !!!

Look at the my Tables and Fields with examples ...

Table -> PERSONS

Fields ->
PID (Number value)
PNAME (Text value)
PFAMILY (Text value)
and etc.

Example:
1 - Hadi - Rezaie
2 - Ali - Arabi
3 - Hasan - Varchaghi

Table -> OPERATE

Fields ->
PID1 (Just can save PID data in PERSON table)
POPERATE (Yes/No)
PID2 (Just can save PID data in PERSON table)

Example:
1 - Yes - 3
1 - No - 2
2 - Yes - 3
3 - No - 1

I wanna show thease information in my report like thease:

Person name: Hadi Rezaie

Operation list:
Hasan Varchaghi - Yes
Ali Arabi - No
Hasan Varchghi - No

How can i do it ?
Please help me ! HELP ME !!!

 

[chelseatech]

I'm not sure how the the third entry works, but for the first two...
Link Operate to the Person's Table...
PID1 - PID

Then add the persons table to the report a second time as an alias of PERSON2 and link
PID2 - PID

If you then want to pick up where PID Hadi - Rezaie is a PID2 in the Operate Table, you might need a subreport with jsut the Operate and Person table linked to PID1....

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm