Skip to main content

Sub-Report repeating itself

Permanently deleted user
I have a workflow that generates a report of features that intersect an input feature.  Unfortunately the report repeats itself depending on the number of features that intersect the input feature.  For example, if point 'A' intersects both polygon '1' and polygon '2', the report looks like this:

 

Input Feature

 

'A'

 

Intersecting Polygon

 

1

 

2

 

Input Feature

 

'A'

 

Intersecting Polygon

 

1

 

2

 

If there are 3 intersecting polygons, the report would look like this:

 

Input Feature

 

'A'

 

Intersecting Polygon

 

1

 

2

 

Input Feature

 

'A'

 

Intersecting Polygon

 

1

 

2

 

Input Feature

 

'A'

 

Intersecting Polygon

 

1

 

2

 

All the following return the same results:

 

-Using FeatureSetToDataTable

 

-Invoke Method to add Rows and then add all rows to table

 

In the first example, counts on the number or rows in the table return what I would expect (2).  Counts on the Number of DataTables in the Dataset are what I would expect (Input Feature DataTable and Intersecting Polygons DataTable).

 

The Report contains a map, and couple of Sub reports.

 

Anyone have an idea how I can fix this problem?
0

Comments

5 comments

Date Votes
  • Permanently deleted user
    Anyone have an idea what might be causing this?
    0
  • Permanently deleted user
    Hi Aron,

     

    I'm only taking a guess since I don't have the workflow or report in front of me, but it seems to me that the features that are returned by your workflow should be sent to a sub-report of your report.

     

    Are you able to provide anymore details?

     

    Warren
    0
  • Permanently deleted user
    OK, here is my workflow, report and subreports to see if anyone can help.  I have made everything as generic as possible.  To sum up what the workflow does, the workflow queries a well site and returns the intersecting SRA (special review area) in a report.  To display the multiple reporting features, you will need to ensure that your input feature (well site) intersects with 2 or more other polygons.  The report will repeat itself however many times that the input feature intersects the review area.  The following changes need to be made to make the workflow function.

     

    wellSiteLayerUrl - variable needs to be changed to your own service that you want to use as the input feature.

     

    wellSiteQuery - variable needs to be changed to return the feature that you would like to query

     

    geometryServiceUrl - variable needs to be changed to your geometry service

     

    hyperlinkUri - variable needs to be changed to your Geocortex Essentials REST endpoint

     

    SRALayerUrl - variable needs to be changed to the service that you want to use as your special review area

     

    attributeName - variable needs to be changed to the attribute name that you want to return of each of the intersecting special review areas

     

    templateReportSRAUri - variable needs to be changed to the path to where you placed the report's .rpx file

     

    Due to workflow size, I will have to break it up into a couple of pieces.  I will also add the reports in separate posts.
    0
  • Permanently deleted user
    intersectReport.rpx <?xml version="1.0" encoding="UTF-8"?> <ActiveReportsLayout Version="3.1" PrintWidth="15210.72" 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; ddo-char-set: 186; " /> <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="ReportHeader" Name="ReportHeader1" Height="1018" BackColor="16777215"> <Control Type="AR.Label" Name="Label1" Left="5355" Top="270" Width="6480" Height="720" Caption="Feature within Special Review Area" HyperLink="emblem.jpg" Style="ddo-char-set: 0; font-weight: bold; font-size: 18pt; font-family: Arial; " /> </Section> <Section Type="PageHeader" Name="PageHeader1" Height="0" BackColor="16777215" /> <Section Type="Detail" Name="Detail1" Height="2174" BackColor="16777215"> <Control Type="AR.Subreport" Name="SubReport2" Tag="WellSite_SubReport.rpx" Left="450" Top="630" Width="3960" Height="270" ReportName="WellSite_Data" /> <Control Type="AR.Label" Name="Label5" Left="450" Top="360" Width="1080" Height="270" Caption="Feature #" Style="ddo-char-set: 0; text-align: left; font-weight: bold; font-size: 11.25pt; font-family: Arial; text-decoration: underline; " /> <Control Type="AR.Label" Name="Label10" Left="450" Top="900" Width="2160" Height="270" Caption="Intersecting Area" Style="ddo-char-set: 1; font-weight: bold; font-size: 10.75pt; text-decoration: underline; " /> <Control Type="AR.Subreport" Name="SubReport3" Tag="ConsiderationArea_SubReport.rpx" Left="450" Top="1170" Width="4320" Height="270" ReportName="sraDataTableReport" /> <Control Type="AR.Line" Name="Line1" X1="450" Y1="1710" X2="5400" Y2="1710" /> </Section> <Section Type="PageFooter" Name="PageFooter1" Height="0" BackColor="16777215" /> <Section Type="ReportFooter" Name="ReportFooter1" Height="432" BackColor="16777215"> <Control Type="AR.Label" Name="Label4" Left="6570" Top="90" Width="2070" Height="270" Caption="Report Generated On:" Style="ddo-char-set: 1; text-align: right; font-family: Tahoma; " /> <Control Type="AR.ReportInfo" Name="ReportInfo1" Left="8640" Top="90" Width="2970" Height="270" FormatString="{RunDateTime:M/d/yy h:mm tt}" Style="ddo-char-set: 1; font-family: Tahoma; " /> </Section> </Sections> <ReportComponentTray /> <CalculatedFields> <Field Name="HalfDistanceCalc" Formula="_ScaleBarDistance/2" FieldType="None" /> </CalculatedFields> <PageSettings LeftMargin="360" RightMargin="360" TopMargin="360" BottomMargin="360" PaperSize="0" PaperWidth="12240" PaperHeight="15840" PaperName="Custom paper" Orientation="2" /> <Parameters /> </ActiveReportsLayout>

     

     
    0
  • Permanently deleted user
    ConsiderationArea_SubReport.rpx <?xml version="1.0" encoding="UTF-8"?> <ActiveReportsLayout Version="3.1" PrintWidth="9360" 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="pageHeader" Height="0" BackColor="16777215" /> <Section Type="Detail" Name="detail" Height="540" BackColor="16777215"> <Control Type="AR.Label" Name="Label1" DataField="CONSIDERATION_AREA" Left="360" Top="90" Width="2880" Height="270" Caption="CONSIDERATION AREA" Style="ddo-char-set: 0; font-size: 9.75pt; " /> </Section> <Section Type="PageFooter" Name="pageFooter" Height="29" BackColor="16777215" /> </Sections> <ReportComponentTray /> <PageSettings /> <Parameters /> </ActiveReportsLayout>

     

    WellSite_SubReport.rpx <?xml version="1.0" encoding="UTF-8"?> <ActiveReportsLayout Version="3.1" PrintWidth="9360" 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="pageHeader" Height="0" BackColor="16777215" /> <Section Type="Detail" Name="detail" Height="540" BackColor="16777215"> <Control Type="AR.Label" Name="Label1" DataField="TRACK_NO" Left="90" Top="90" Width="1440" Height="285" Caption="TRACK_NO" Style="ddo-char-set: 0; font-size: 9.75pt; " /> </Section> <Section Type="PageFooter" Name="pageFooter" Height="29" BackColor="16777215" /> </Sections> <ReportComponentTray /> <PageSettings /> <Parameters /> </ActiveReportsLayout>

     

     
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post