Dick, Was it the packing of the index that did it?
James Belisle Making Information Systems People Friendly Since 1990 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Carpet Broker, Dick Fey Sent: Friday, December 18, 2015 11:40 AM To: Jim Belisle Subject: [RBASE-L] - RE: Report issue Thank you Javier... That fixed it. I would never have thought of that. In fact, don't think I have ever doe it. Dick Fey On 12/18/2015 10:40 AM, Javier Valencia wrote: > Dick, > > The first thing I check when I have a problem with reports is to verify the > data going into the report is correct. > > If it is using a table, verify that there are indeed no duplicate records. > > If it using a view, particularly a multi-table view, verify that extra rows > are not being generated. > > PACK INDEX - Rebuild Indices for the table or preferably for the entire > database. You can do this even if there are users connected. > > Javier, > > Javier Valencia, PE > O: 913-829-0888 > H: 913-397-9605 > C: 913-915-3137 > > > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf Of Carpet > Broker, Dick Fey > Sent: Friday, December 18, 2015 9:56 AM > To: [email protected] > Subject: [RBASE-L] - Report issue > > Have a new problem with an old report. > > A single table report, showing accounts receivable. > > Should show the single line from the order table, which holds just 1 row for > each order. > > The report is suddenly showing duplicate rows, occasionally triples, > sometimes a single. > > Any clues, have found nothing wrong so far. > > -- > Dick Fey > Carpet Broker Inc > P: 913-894-9211 > F: 913-894-0138 > > > > -- Dick Fey Carpet Broker Inc P: 913-894-9211 F: 913-894-0138
