Duplicate Records when running Requests Reports
It seems that when a request has a resolution that exceeds 255 characters the software creates duplicate entries in the database. The remaining characters are placed in the resolution column. If 255 characters are added to the second entry, then a third is created.
This is problem when running reports on the number of requests, because the count function uses the number of records that are return as the "Number of Requests" value. This value is incorrect if one or more requests have long resolution explanations.
Is their a way around this?
Does a conversion to MSSQL solve this?
Thanks,
Chris
This is problem when running reports on the number of requests, because the count function uses the number of records that are return as the "Number of Requests" value. This value is incorrect if one or more requests have long resolution explanations.
Is their a way around this?
Does a conversion to MSSQL solve this?
Thanks,
Chris
Topic Participants
JRD_ITDepartment
QVC_me
John Busch
smannesman
Fwinters