crystal report how to use more than one table

  • Thread starter Thread starter 2003et
  • Start date Start date
2

2003et

I have a crystal report object which include 3 tables... I get data from
dataset and make the report... The first Table is my primary table, the
second and third tables are the other information tables, which can include
more than one row... So the report looks like below:

Table1_No Table2_Name_Of_ThePerson Table3_Name_Of_The_OtherPerson

1 Michael Dilson
Pamela Kidman
1 Michael Dilson
Andre Scot
1 Fred Green
Pamela Kidman
1 Fred Green
Andre Scot
2 Danny Rodman Sami
Tonton
3 Murat Kira
Nicholas Turan
3 Murat Kira
Danny Coffman


But I want to show the report as below:

Table1_No Table2_Name_Of_ThePerson Table3_Name_Of_The_OtherPerson

1 Michael Dilson
Pamela Kidman
Fred Green
Andre Scot

2 Danny Rodman Sami
Tonton

3 Murat Kira
Nicholas Turan

Danny Coffman


Please help I don't want to repeat all the names at every line...

Thanks in advance
 
I have a crystal report object which include 3 tables... I get data from
dataset and make the report... The first Table is my primary table, the
second and third tables are the other information tables, which can include
more than one row... So the report looks like below:

T1_No Table2_Name Table3_Name

1 Michael Dilson Pamela Kidman
1 Michael Dilson Andre Scot
1 Fred Green Pamela Kidman
1 Fred Green Andre Scot
2 Danny Rodman Sami Tonton
3 Murat Kira Nicholas Turan
3 Murat Kira Danny Coffman


But I want to show the report as below:

T1_No Table2_Name Table3_Name

1 Michael Dilson Pamela Kidman
Fred Green Andre Scot
2 Danny Rodman Sami Tonton
3 Murat Kira Nicholas Turan
Danny Coffman


Please help I don't want to repeat all the names at every line...

Thanks in advance
 
Use Gruop By [Table2_Name_Of_ThePerson] in CR. I don't know where is
that option, just look around a bit in CR..
 
Back
Top