Sub Report

[[email protected]]

I have created 2 document type reports. I added two actions on a form to generate each report for testing purposes. The first report is the main report and the second is a sub report of the main. When I run the sub report independently from from main report I get 1 record to show. When I run the main report with the embedded sub report, I get the sub report showing the records duplicated.

I have a query that is being used on the sub report called Test. This query has the syntax "FIND InstallLogSoftware WHERE InstallLogSoftware IN InstallLog.Software".

One other thing to note is that the sub report is embedded in the details of the main report.

From what I can tell, it looks like the sub report is repeating the records based on the number of records in the InstallLog file. [/b]

[aware_support]

Please try the following query for the sub-report instead:

FIND InstallLogSoftware WHERE InstallLogSoftware IN ThisInstallLog.Software

Note the prefix "This" which indicates the current record in the main report.