>I had this same problem about 4 years ago, but I don't remember how I fixed it. I have a "billing detail" table used as the primary input for report, (with associated master tables - customer/category/etc); and the 1st detail line in the billing detail table is printed on every detail line of the report. When I do a preview in the development environment, it is displayed correctly. Can someone point me in the right direction?
The current alias when you run the report is not the alias that you're printing. So it's reprinting the data from the alias you wanted, once for every record of the alias you're going through... which is a wrong one.
Possible causes:
- your code selects some other table at the last millisecond before running the report
- your code in report's dataenvironment selects some other table and then continues running the report on it
- you have a grid which has the focus, and it chooses to refresh when you run the report. Your report prints the same record for each record of the grid's underlying alias.
Cure for first two is to just fix the code, or lose the alias in report's fields. For the third, get the focus off the grid before running the report.