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..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Passing Parameters to a Crystal Report and data from more tables 1
Set row color of a datagrid when more than one datagrid on a form 2
using more than one detail record in one line on report 2
How do i use a lookup table for more than one field in query 10
How to run more than one report 3
how to display multiple lines in one crystal report chart 0
How To Package and Deploy Crystal Report .rpt files. 0
How to select all months from a table to include in a report 3

Back
Top