Repeated pages in detail section

[fhurmuzlu]

How to avoid repeated pages in detail section ?after I joined all my tables left join, my report running slow .any idea to solve this problem?

 

[lbass]

You need to much more specific about the issue.

-LB

 

[fhurmuzlu]

I joined all my tables left outer join , because I can not get records when I use inner join .but the report running slow it takes 5 minutes to get the records.
also I am getting repeated records in detail section ?

 

[kray4660]

Left outer join will be much slower that a inner join, but sometimes the only way to get the data. Did you click on the Select Distinct Records under the Database menu item to remove duplicates?

 

[lbass]

How you link tables should be driven by the logic of your report, not by whether you can get records or not.

You can handle duplication through grouping and/or using "suppress if duplicated" formatting options and/or using running totals to ignore duplicate records.

-LB