Yes, was not even aware that could be causing the problem.
Dick Fey
On 12/18/2015 11:57 AM, Jim Belisle wrote:
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
