Why are the records repeating in my report?
When my report runs, it repeats the records multiple times. Any idea why?

I have a report imbedded in another report.
The frame report (that is being called by Geocortex) is:
<?xml version="1.0" encoding="UTF-8"?>
<ActiveReportsLayout Version="3.1" PrintWidth="11520" DocumentName="ARNet Document" ScriptLang="C#" MasterReport="0">
<StyleSheet>
<Style Name="Normal" Value="font-family: Arial; font-style: normal; text-decoration: none; font-weight: normal; font-size: 10pt; color: Black; " />
<Style Name="Heading1" Value="font-size: 16pt; font-weight: bold; " />
<Style Name="Heading2" Value="font-family: Times New Roman; font-size: 14pt; font-weight: bold; font-style: italic; " />
<Style Name="Heading3" Value="font-size: 13pt; font-weight: bold; " />
</StyleSheet>
<Sections>
<Section Type="PageHeader" Name="PageHeader1" Height="14" BackColor="16777215" />
<Section Type="Detail" Name="Detail1" Height="2880" BackColor="16777215" CanShrink="1">
<Control Type="AR.Subreport" Name="ChildCareList" Tag="ChildCareSingleRecord.rpx" Left="0" Top="0" Width="10080" Height="2160" ReportName="Child Care Centres" />
</Section>
<Section Type="PageFooter" Name="PageFooter1" Height="14" BackColor="16777215" />
</Sections>
<ReportComponentTray />
<PageSettings />
<Parameters />
</ActiveReportsLayout>
And the data report that is being called by the Frame report is:
<?xml version="1.0" encoding="UTF-8"?>
<ActiveReportsLayout Version="3.1" PrintWidth="10080" DocumentName="ARNet Document" ScriptLang="C#" MasterReport="0">
<StyleSheet>
<Style Name="Normal" Value="font-family: Arial; font-style: normal; text-decoration: none; font-weight: normal; font-size: 10pt; color: Black; " />
<Style Name="Heading1" Value="font-size: 16pt; font-weight: bold; " />
<Style Name="Heading2" Value="font-family: Times New Roman; font-size: 14pt; font-weight: bold; font-style: italic; " />
<Style Name="Heading3" Value="font-size: 13pt; font-weight: bold; " />
</StyleSheet>
<Sections>
<Section Type="Detail" Name="Detail1" Height="2880" BackColor="16777215" CanShrink="1">
<Control Type="AR.Field" Name="TextBox2" DataField="CentreName" Left="180" Top="90" Width="8910" Height="360" Text="Centre Name" Multiline="0" CanGrow="0" Style="ddo-char-set: 0; font-weight: bold; font-size: 12pt; " />
<Control Type="AR.Field" Name="dataAddress" DataField="Address" Left="180" Top="540" Width="5940" Height="270" Text="Address" Multiline="0" CanGrow="0" />
<Control Type="AR.Field" Name="dataPhoneNum" DataField="Phone" Left="540" Top="900" Width="3150" Height="360" Text="PhoneNumber" Multiline="0" CanGrow="0" Style="vertical-align: middle; " />
<Control Type="AR.Field" Name="dataHours" DataField="HoursOfCare" Left="540" Top="1260" Width="8550" Height="360" Text="Hours" Multiline="0" CanGrow="0" Style="vertical-align: middle; " />
<Control Type="AR.Field" Name="dataAge" DataField="AgeOfChild" Left="6120" Top="540" Width="2970" Height="270" Text="Age of child" Multiline="0" CanGrow="0" Style="text-align: right; " />
<Control Type="AR.Field" Name="dataWebsite" DataField="Website" Left="180" Top="1620" Width="8910" Height="270" Text="website" HyperLink="Website" Multiline="0" CanGrow="0" />
<Control Type="AR.Label" Name="Label1" Left="6750" Top="810" Width="1728" Height="270.72" Caption="Subsidy Available:" Style="text-align: right; " Multiline="0" />
<Control Type="AR.Field" Name="dataSubsidy" DataField="SubsidyAvailable" Left="8460" Top="810" Width="630" Height="270" Text="Subsidy" Multiline="0" CanGrow="0" Style="text-align: right; " />
<Control Type="AR.Image" Name="Picture1" Left="180" Top="1260" Width="360" Height="360" LineWeight="0" HyperLink="">imgurleditedforclarity</Control>
<Control Type="AR.Image" Name="Picture2" Left="180" Top="900" Width="360" Height="360" LineWeight="0" HyperLink="">imgurleditedforclarity</Control>
<Control Type="AR.Line" Name="Line1" X1="270" Y1="2070" X2="9090" Y2="2070" LineWeight="3" />
</Section>
</Sections>
<ReportComponentTray />
<PageSettings />
<Parameters />
</ActiveReportsLayout>


Any help would be very appreciated. Thanks.
Paul
0
-
Hi Paul,
I don't see anything out of place in the rpx files. How are you running the report? If the report runs from a workflow, you'll want to check the dataset that gets sent to the TemplateReport activity. If the report is being accessed from the out of the box "Run a Report" tool, you could try using Fiddler to see what data is being used (https://support.geocortex.com/essentialsGSCkba?sub-nav=kba&main-nav=essentials&#!/feedtype=SINGLE_ARTICLE_DETAIL&criteria=BESTANSWERS&id=kA360000000Cib0CAC), and/or test running the report from its REST endpoint.
Hope that helps,
Amanda0
Please sign in to leave a comment.
Comments
1 comment