create a subreport with nolink

[ravikode]

I want to create a report which has data from 2 different tables which donot have common columnNames or values. Both the tables are very small.

Can I insert a second table in the report(which has been created using the first table).

 

[SydneyGeek]

It's probably not a good idea to make one report a subreport of another if the two tables are completely unrelated, or to place both tables in the report design. Both these options would have undesirable results, as follows --

1. Report from unrelated tables will give the cartesian product of the records:
Table 1 has records 1, 2, 3, 4
Table 2 has records A, B, C, D
The report would have A1, A2, A3, A4, B1, B1, B3, B4, ... D4 (16 records in all)

2. Report with an unrelated subreport would do this:
Record 1
Record A
Record B
Record C
Record D
Record 2
Record A
Record B
Record C
Record D
Record 3
Record A
Record B
Record C
Record D
Record 4
Record A
Record B
Record C
Record D

Probably the best option is to create a blank report based on nothing, and make BOTH reports into subreports in here.
Method:
Reports -- Create new report in Design view. Save as Wrapper.
In the Header of Wrapper, put a label with the heading you want for the report.
Make the report so its size is Restored -- you should be able to see the database container.
Drag the icons for both reports into the Detail section of Wrapper. You can adjust their width, but leave the height alone -- put them one below the other, and they expand to fit the data.

Give that a try, and see how you go.

Denis