Reports

[greatrohit]

Is there a way to print a simple Report
using Crystal Reports,in which there are
three tables the contents of which have
to be printed independently in a single
Report without linking of any field.

e.g.

< Field 1 of table 1 >

<All Records of field 1 of Table 2 >

<All Records of field 1 of Table 3 >

Table 1 , 2 & 3 are independent Tables not
linked to each other.

[hpet]

If I understand you correctly you would like to print a report that gathers data from 3 different tables?
If that's the case then you can build SQL statement that returns recordset which includes data from all 3 tables.
You can assign this rs to report after (in this case you need to base you report on data definition file rather then DB).
On the other hand, there are several different ways, like filling details field on your own from recordset, etc.

hpet

[baroberts]

Try using "subreports". Each can be designed separately and included in one report.

[ermingut]

I have the same problem. So I want my data to look like this:

caption 1

data from table 1 xxxxxxx xxxxxxxxxx xxxxxxxxxxx xxxxxxxxx
data from table 1 xxxxxxx xxxxxxxxxx xxxxxxxxxxx xxxxxxxxx
data from table 1 xxxxxxx xxxxxxxxxx xxxxxxxxxxx xxxxxxxxx
data from table 1 xxxxxxx xxxxxxxxxx xxxxxxxxxxx xxxxxxxxx
data from table 1 xxxxxxx xxxxxxxxxx xxxxxxxxxxx xxxxxxxxx

caption 2

data from table 2 xxxxxxx xxxxxxxxxx xxxxxxxxxxx xxxxxxxxx
data from table 2 xxxxxxx xxxxxxxxxx xxxxxxxxxxx xxxxxxxxx
data from table 2 xxxxxxx xxxxxxxxxx xxxxxxxxxxx xxxxxxxxx
data from table 2 xxxxxxx xxxxxxxxxx xxxxxxxxxxx xxxxxxxxx
data from table 2 xxxxxxx xxxxxxxxxx xxxxxxxxxxx xxxxxxxxx

caption 3

data from table 3 xxxxxxx xxxxxxxxxx xxxxxxxxxxx xxxxxxxxx
data from table 3 xxxxxxx xxxxxxxxxx xxxxxxxxxxx xxxxxxxxx
data from table 3 xxxxxxx xxxxxxxxxx xxxxxxxxxxx xxxxxxxxx
data from table 3 xxxxxxx xxxxxxxxxx xxxxxxxxxxx xxxxxxxxx
data from table 3 xxxxxxx xxxxxxxxxx xxxxxxxxxxx xxxxxxxxx

And so on...

Can anyone help?

[Edneeis]

Like baroberts said 'Subreports' then you can make seperate reports and use them as subreports in your main report, which would have all 3.