Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Duplicate rows
Message
From
23/02/2003 18:39:19
 
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Miscellaneous
Thread ID:
00756794
Message ID:
00756800
Views:
11
>I have a report that pulls info from a table. When I preview this report, the first page looks correct. The data is the data from the table. But, when I go to see another page, all the rows of data are replaced with only one record from the table. So, if there are 30 rows on the report all 30 are filled with only one rows data from the table over and over and over again.
>
>But, if I put a browse or a suspend before the REPORT FORM line in the data, then close that browse/suspend, the report will run fine.
>
>I have put a select statement before the report from line to see if it just wasn't matching up with the table, but that still doesn't fix the problem.


The usual problem is that the area is changed. But you said a Select table is done prior to the report.

Are there any table relations? Make sure they are not broken at some point.
Make sure no routine or UDF changes the selected area.
Does the report have a data environment?


Alex Feldstein, MCP, Microsoft MVP
VFP Tips: English - Spanish
Website - Blog - Photo Gallery


"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry
Previous
Reply
Map
View

Click here to load this message in the networking platform