Please help: I'm trying to make my reports running faster. They are just too slow when they connected to more than more unlinked tables. Here is the scenerio:

1) create a brand new report.

2) connect to 1st table DB2/SQL (main sourece of data --> 100,000 records)

3) connect to 2nd table DB2/SQl (just contains about 20 records for lookup and get some misc info. using some FORMULAR) ---  HOW CAN I SPIN this table to read all the   20 records, extract one field and put them all in one variable ???).

Right now even I've not used the 2nd table yet, the reports still run really slow. I think CR 10 (the version I'm using) seems trying to do the matching of these unlinked tables.

I would be very appreciated more a solution !!!!