Hi I have a RDLC report with 3 sub reports. Everything works OK - except the 3rd sub report - which just displays blank data - it does display the correct number of rows however.
There is no connection or parameters associated with the parent report. It works ok as a single report - just not as a subreport.
I have tried all combinations of elements, grouping hiding, setting growth on off - allowing\disallowing increase etc...
Any suggestions anyone?
![258140-blank-subreport.jpg][1]
Code for subreport.
<?xml version="1.0" encoding="utf-8"?>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<Body>
<ReportItems>
<Tablix Name="Tablix1">
<TablixBody>
<TablixColumns>
<TablixColumn>
<Width>2.5cm</Width>
</TablixColumn>
<TablixColumn>
<Width>2.5cm</Width>
</TablixColumn>
<TablixColumn>
<Width>2.5cm</Width>
</TablixColumn>
<TablixColumn>
<Width>2.5cm</Width>
</TablixColumn>
<TablixColumn>
<Width>2.5cm</Width>
</TablixColumn>
<TablixColumn>
<Width>2.5cm</Width>
</TablixColumn>
<TablixColumn>
<Width>2.5cm</Width>
</TablixColumn>
<TablixColumn>
<Width>2.5cm</Width>
</TablixColumn>
</TablixColumns>
<TablixRows>
<TablixRow>
<Height>0.6cm</Height>
<TablixCells>
<TablixCell>
<CellContents>
<Textbox Name="Textbox9">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>NO</Value>
<Style>
<FontWeight>Bold</FontWeight>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>Textbox9</rd:DefaultName>
<Style>
<Border>
<Color>LightGrey</Color>
<Style>Solid</Style>
</Border>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="Textbox2">
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Unit</Value>
<Style>
<FontWeight>Bold</FontWeight>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>Textbox2</rd:DefaultName>
<Style>
<Border>
<Color>LightGrey</Color>
<Style>Solid</Style>
</Border>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="Textbox3">
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Unit S/N</Value>
<Style>
<FontWeight>Bold</FontWeight>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>Textbox3</rd:DefaultName>
<Style>
<Border>
<Color>LightGrey</Color>
<Style>Solid</Style>
</Border>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="Textbox4">
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Unit B\N</Value>
<Style>
<FontWeight>Bold</FontWeight>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>Textbox4</rd:DefaultName>
<Style>
<Border>
<Color>LightGrey</Color>
<Style>Solid</Style>
</Border>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="Textbox5">
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Cell</Value>
<Style>
<FontWeight>Bold</FontWeight>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>Textbox5</rd:DefaultName>
<Style>
<Border>
<Color>LightGrey</Color>
<Style>Solid</Style>
</Border>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="Textbox6">
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Pos</Value>
<Style>
<FontWeight>Bold</FontWeight>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>Textbox6</rd:DefaultName>
<Style>
<Border>
<Color>LightGrey</Color>
<Style>Solid</Style>
</Border>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="Textbox7">
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Cell S/N</Value>
<Style>
<FontWeight>Bold</FontWeight>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>Textbox7</rd:DefaultName>
<Style>
<Border>
<Color>LightGrey</Color>
<Style>Solid</Style>
</Border>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="Textbox8">
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Cell Node</Value>
<Style>
<FontWeight>Bold</FontWeight>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>Textbox8</rd:DefaultName>
<Style>
<Border>
<Color>LightGrey</Color>
<Style>Solid</Style>
</Border>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
</TablixCells>
</TablixRow>
<TablixRow>
<Height>0.6cm</Height>
<TablixCells>
<TablixCell>
<CellContents>
<Textbox Name="c01">
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Fields!c01.Value</Value>
<Style />
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>c01</rd:DefaultName>
<Style>
<Border>
<Color>LightGrey</Color>
<Style>Solid</Style>
</Border>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="c02">
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Fields!c02.Value</Value>
<Style />
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>c02</rd:DefaultName>
<Style>
<Border>
<Color>LightGrey</Color>
<Style>Solid</Style>
</Border>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="c03">
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Fields!c03.Value</Value>
<Style />
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>c03</rd:DefaultName>
<Style>
<Border>
<Color>LightGrey</Color>
<Style>Solid</Style>
</Border>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="c04">
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Fields!c04.Value</Value>
<Style />
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>c04</rd:DefaultName>
<Style>
<Border>
<Color>LightGrey</Color>
<Style>Solid</Style>
</Border>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="c05">
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Fields!c05.Value</Value>
<Style />
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>c05</rd:DefaultName>
<Style>
<Border>
<Color>LightGrey</Color>
<Style>Solid</Style>
</Border>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="c06">
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Fields!c06.Value</Value>
<Style />
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>c06</rd:DefaultName>
<Style>
<Border>
<Color>LightGrey</Color>
<Style>Solid</Style>
</Border>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="c07">
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Fields!c07.Value</Value>
<Style />
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>c07</rd:DefaultName>
<Style>
<Border>
<Color>LightGrey</Color>
<Style>Solid</Style>
</Border>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="c08">
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Fields!c08.Value</Value>
<Style />
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>c08</rd:DefaultName>
<Style>
<Border>
<Color>LightGrey</Color>
<Style>Solid</Style>
</Border>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
</TablixCells>
</TablixRow>
</TablixRows>
</TablixBody>
<TablixColumnHierarchy>
<TablixMembers>
<TablixMember />
<TablixMember />
<TablixMember />
<TablixMember />
<TablixMember />
<TablixMember />
<TablixMember />
<TablixMember />
</TablixMembers>
</TablixColumnHierarchy>
<TablixRowHierarchy>
<TablixMembers>
<TablixMember>
<KeepWithGroup>After</KeepWithGroup>
</TablixMember>
<TablixMember>
<Group Name="Details" />
</TablixMember>
</TablixMembers>
</TablixRowHierarchy>
<DataSetName>WWD</DataSetName>
<Height>1.2cm</Height>
<Width>20cm</Width>
<Style>
<Border>
<Style>None</Style>
</Border>
</Style>
</Tablix>
</ReportItems>
<Height>0.47244in</Height>
<Style />
</Body>
<Width>7.87402in</Width>
<Page>
<PageHeight>29.7cm</PageHeight>
<PageWidth>21cm</PageWidth>
<LeftMargin>1cm</LeftMargin>
<RightMargin>1cm</RightMargin>
<TopMargin>0.5cm</TopMargin>
<BottomMargin>0.5cm</BottomMargin>
<ColumnSpacing>0.13cm</ColumnSpacing>
<Style />
</Page>
<AutoRefresh>0</AutoRefresh>
<DataSources>
<DataSource Name="WWD">
<ConnectionProperties>
<DataProvider>System.Data.DataSet</DataProvider>
<ConnectString>/* Local Connection /</ConnectString>
</ConnectionProperties>
<rd:DataSourceID>c161565b-36e9-4e14-bd3c-f1c3ed797f19</rd:DataSourceID>
</DataSource>
</DataSources>
<DataSets>
<DataSet Name="WWD">
<Query>
<DataSourceName>WWD</DataSourceName>
<CommandText>/ Local Query */</CommandText>
</Query>
<Fields>
<Field Name="c01">
<DataField>c01</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="c02">
<DataField>c02</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="c03">
<DataField>c03</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="c04">
<DataField>c04</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="c05">
<DataField>c05</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="c06">
<DataField>c06</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="c07">
<DataField>c07</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="c08">
<DataField>c08</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
</Fields>
<rd:DataSetInfo>
<rd:DataSetName>WWD</rd:DataSetName>
<rd:SchemaPath>C:\Users\charris\Source\Repos\Reports\Reports\WWD.xsd</rd:SchemaPath>
<rd:TableName>WWD</rd:TableName>
<rd:TableAdapterFillMethod />
<rd:TableAdapterGetDataMethod>GetData</rd:TableAdapterGetDataMethod>
<rd:TableAdapterName>WWDTA</rd:TableAdapterName>
</rd:DataSetInfo>
</DataSet>
</DataSets>
<ConsumeContainerWhitespace>true</ConsumeContainerWhitespace>
<rd:ReportUnitType>Cm</rd:ReportUnitType>
<rd:ReportID>ebd7d3c5-55d5-4cbc-ac97-c787d5879018</rd:ReportID>
</Report>
<?xml version="1.0" encoding="utf-8"?>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2016/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<AutoRefresh>0</AutoRefresh>
<DataSources>
<DataSource Name="WWD">
<ConnectionProperties>
<DataProvider>System.Data.DataSet</DataProvider>
<ConnectString>/* Local Connection /</ConnectString>
</ConnectionProperties>
<rd:DataSourceID>38dfd38a-05df-4072-9d4e-41b9e6805a75</rd:DataSourceID>
</DataSource>
</DataSources>
<DataSets>
<DataSet Name="WWD">
<Query>
<DataSourceName>WWD</DataSourceName>
<CommandText>/ Local Query /</CommandText>
</Query>
<Fields>
<Field Name="c01">
<DataField>c01</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="c02">
<DataField>c02</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="c03">
<DataField>c03</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="c04">
<DataField>c04</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="c05">
<DataField>c05</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="c06">
<DataField>c06</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="c07">
<DataField>c07</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="c08">
<DataField>c08</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="c09">
<DataField>c09</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="c10">
<DataField>c10</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="c11">
<DataField>c11</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="c12">
<DataField>c12</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="c13">
<DataField>c13</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="c14">
<DataField>c14</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="c15">
<DataField>c15</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="c16">
<DataField>c16</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="c17">
<DataField>c17</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="c18">
<DataField>c18</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="c19">
<DataField>c19</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="c20">
<DataField>c20</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="c21">
<DataField>c21</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="c22">
<DataField>c22</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="c23">
<DataField>c23</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
</Fields>
</DataSet>
<DataSet Name="WWH">
<Query>
<DataSourceName>WWD</DataSourceName>
<CommandText>/ Local Query */</CommandText>
</Query>
<Fields>
<Field Name="logo">
<DataField>logo</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="c01">
<DataField>c01</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="c02">
<DataField>c02</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="c03">
<DataField>c03</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="c04">
<DataField>c04</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="c05">
<DataField>c05</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="c06">
<DataField>c06</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="c07">
<DataField>c07</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="c08">
<DataField>c08</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="c09">
<DataField>c09</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="c10">
<DataField>c10</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="c11">
<DataField>c11</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="c12">
<DataField>c12</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="c13">
<DataField>c13</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="c14">
<DataField>c14</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="c15">
<DataField>c15</DataField>
<rd:TypeName>System.String</rd:TypeName>