Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Translated Trial Balance Preview prints duplicate records

Translated Trial Balance Preview prints duplicate records

View products that this article applies to.

Symptoms

If the trial balance preview report is printed, then another report is printing and the trial balance preview is printed again, records on the report are duplicated.

↑ Back to the top

Cause

Due to bug 14055, the report incorrectly does not filter out unrelated rptruntime records from other users.

↑ Back to the top

Resolution

Resolution 1:

a - Run the statement in SQL against your application database:

Delete from wrkfstribal

b - Verify no other users are current running a report

c - Print the FST Trial Balance Preview

Resolution 2:

Change the Crystal Report file, adding the following to the selection formula:

{WrkFSTriBal.RI_ID} = tonumber(riparam("RI_ID"))

↑ Back to the top

Keywords: kbmbsmigrate, kbmbspartner, kbsurveynew, kb

↑ Back to the top

Article Info
Article ID : 2678043
Revision : 2
Created on : 2/3/2017
Published on : 2/3/2017
Exists online : False
Views : 409