Rrpt with 8 linked tables only prints 1st record

[olichap]

I've 8 tables that are properly linked, with one we'll call tblList as the parent. I have a group in the report on what amounts to a CustID field in tblList (numeric in all tables).

At present I'm just roughing out the report to make sure I can display the related data properly. There are 2089 records in tblList. I've dropped a few fields from each table in the Details section.

My expectation is to see 2089 record groupings and the various info from Details; I only get the info for one record (the first).

Anyone know where I'm going wrong here? I've not had to play around with linked resultsets in a report before.

Thanks,

Oli

 

[IdoMillet]

Sounds like at least one "target" link is successful only for one customer, resulting in a single record.

Start the links with just 2 tables and keep adding more tables to see where the problem is.

Also, check what you have in your record & group selection formulas (in case you are restricting to just one customer).

hth,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[lbass]

You could also try changing the links from equal to left outer one at a time. If you do have a table with only one matching record, the left outer from the parent table to that table would allow all records from the first table to still appear.

-LB