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. RPTCOMPANY records that are introduced when you preview a report will cause other reports to duplicate their report detail

RPTCOMPANY records that are introduced when you preview a report will cause other reports to duplicate their report detail

View products that this article applies to.

Symptoms

Consider the following scenario in Project Controller in Microsoft Dynamics SL:

Print preview the Detail GL report.

Leave the preview open.

Print any of the four formats of the Budget report in Project Controller (PA.030.00).

Notice all the detail lines are duplicated.

↑ Back to the top

Resolution

Open the report in Crystal. Click Report -> Selection Formula -> Record

Add the following text to the record selection formula:

{RptCompany.RI_ID} = tonumber(RIPARAM("RI_ID"))  

Click Save

↑ Back to the top

More Information

This problem occurs with the following reports:

Allocation Methods XREF (PA.430.00)

Alloc Proc/GL Posting Audit (PA.450.00)

Project Change Order Print (CN.030.00)

Employee Report (PA.050.00)

Project Aging/Recap (PA.110.00)

Project Aging/Recap (SSRS) (PA.111.00)

Project Transactions (PA.150.00)

Project List (PA.170.00)

Job Summary Report (PA.300.00)

Labor Hours Detail (PA.310.00)

Labor Hours and Cost Detail (PA.320.00)

ODC Detail (PA.330.00

Revenue Detail (PA.340.00)

Cost Summary (PA.340.00)

Revenue Summary (PA.360.00)

Indirect Cost Analysis Report (PA.370.00)

Revenue Variance Report (UZ.010.00)

↑ Back to the top

Keywords: kbmbsmigrate, kbmbspartner, kbsurveynew, kb

↑ Back to the top

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