.trdx detail form no longer showing data even if data is returned

[Shane]

Hello, I am on the latest version of Reporting and have noticed that reports that were once working, are no longer displaying any data. I go in and configure the datasource, execute the source while still in the wizard, and it returns a 100 rows. I finish the datasource wizard, run the report, use the same parameter's and nothing returns in the detail. 

 

I then create a new report (which creates a trdp file), literally copy and paste the datasource, the fields, create the same parameter's, run the report and all the data is displaying.

 

So it seems that the detail's form is broken. Is this a known issue?

[Stef]

Hi Shane,

Please compare the two reports you created. You can save them as TRDX files (File - Save As from the Standalone Report Designer, and File - Open to load a report from DLL) to compare the XML as plain text.

Check if the report's DataSource is set, or if you use a nested data item like Table the Table.DataSource must be set instead.

Regards,
Stef
Telerik by Progress

[Shane]

MailBackReport.trdx is the report that is NO longer working. MailBackReport - was trdp.trdx was created from scratch, and I literally copied everything over from the original file, and it IS working.

From what I can see, they are identical enough and should be working. The data source is in there, and it is not nested. I tried attaching the trdx files, but it wouldn't let me.  I know the datasource is working, because one of the parameter's returns the names of all records returned.  So if 4 records return, and 3 of them are "bob jones" and 1 of them is "elderberry treeroot", then the parameter will have a dropdown with those 2 names for further filtering.

 

The fact that something exists in the dropdown tells me the datasource is working. It just isn't displaying the rows. 

 

Also, I'm not using a table. It's just a detail section with the field names.

[Stef]

Hi Shane,

If you have a TRDX file reproducing the problem, please paste the XML content here. Note that the XML will contain the serialized connection string used by the SqlDataSource component (edit the XML if it contains sensitive data).

Regards,
Stef
Telerik by Progress

[Shane]

This is from the file that works

 

<?xml version="1.0" encoding="utf-8"?>
<Report DataSourceName="sqlMailBackReport" Width="10.0000012715658in" Name="Mail Back Report" ShowSnapGrid="True" SnapToSnapLines="False" xmlns="http://schemas.telerik.com/reporting/2012/4.1">
  <DataSources>
    <SqlDataSource QueryDesignerState="null" ConnectionString="test" SelectCommand="Accounting.rptReceiptAddressMailingReport" SelectCommandType="StoredProcedure" Name="sqlMailBackReport" ParameterValues="{&quot;@FromDate&quot;:&quot;1/1/2015&quot;,&quot;@ToDate&quot;:&quot;2/1/2015&quot;,&quot;@Name&quot;:&quot;smith&quot;}">
      <Parameters>
        <SqlDataSourceParameter DbType="DateTime" Name="@FromDate">
          <Value>
            <String>= Parameters.FromDate.Value</String>
          </Value>
        </SqlDataSourceParameter>
        <SqlDataSourceParameter DbType="DateTime" Name="@ToDate">
          <Value>
            <String>= Parameters.ToDate.Value</String>
          </Value>
        </SqlDataSourceParameter>
        <SqlDataSourceParameter DbType="AnsiString" Name="@Name">
          <Value>
            <String>= Parameters.Name.Value</String>
          </Value>
        </SqlDataSourceParameter>
      </Parameters>
    </SqlDataSource>
  </DataSources>
  <Items>
    <DetailSection Height="0.199999978144964in" Name="detailSection1">
      <Style VerticalAlign="Middle">
        <BorderStyle Top="Solid" Bottom="Solid" />
        <BorderColor Default="LightGray" />
        <BorderWidth Default="1px" Top="1px" Bottom="1px" />
        <Padding Top="6px" Bottom="6px" />
      </Style>
      <Items>
        <TextBox Width="0.900000254313151in" Height="0.199999968210856in" Left="9.10000038146973in" Top="0in" Value="= Replace(Fields.InstNo, &quot;,&quot;, &quot;&#xD;&#xA;&quot;) " Format="{0}" Name="textBox11">
          <Style TextAlign="Left" VerticalAlign="Middle" />
        </TextBox>
        <TextBox Width="0.799999833106994in" Height="0.199960867563884in" Left="8.3000005086263in" Top="0in" Value="=Fields.DocNo" Format="{0}" Name="textBox12">
          <Style TextAlign="Center" VerticalAlign="Middle" />
        </TextBox>
        <TextBox Width="2.70000076293945in" Height="0.19999997317791in" Left="1.19999965031942in" Top="0in" Value="= Fields.MName" Format="{0}" Name="textBox8">
          <Style TextAlign="Left" VerticalAlign="Middle" />
        </TextBox>
        <TextBox Width="4.39999961853027in" Height="0.19999997317791in" Left="3.90000057220459in" Top="0in" Value="=Fields.Address1 + IIF(Fields.Address2 IS NOT Null,IIF(Fields.Address2 &lt;&gt; &quot;&quot;, &quot; &quot; +  Fields.Address2 + &quot; &quot;, &quot; &quot;), &quot; &quot;) + Fields.MCity + &quot;, &quot; + Fields.MState + &quot; &quot; + Fields.MZip" Format="{0:d}" Name="textBox9">
          <Style TextAlign="Left" VerticalAlign="Middle" />
        </TextBox>
        <TextBox Width="1.20000040531158in" Height="0.19999997317791in" Left="0in" Top="0in" Value="= Fields.Receipt" Name="textBox3">
          <Style TextAlign="Center" VerticalAlign="Middle" />
        </TextBox>
      </Items>
      <ConditionalFormatting>
        <FormattingRule>
          <Style BackgroundColor="240, 240, 240" />
          <Filters>
            <Filter Expression="RowNumber()%2" Operator="Equal" Value="1" />
          </Filters>
        </FormattingRule>
      </ConditionalFormatting>
      <Bindings>
        <Binding Path="Height" Expression="0" />
      </Bindings>
    </DetailSection>
    <PageFooterSection PrintOnFirstPage="True" Height="0.599950671195984in" Name="pageFooterSection1">
      <Items>
        <TextBox Width="7.36599922180176cm" Height="0.491999685764313cm" Left="3.55208333333333in" Top="0.40625in" Value="=&quot;Page &quot; + PageNumber + &quot; of &quot; + PageCount" Name="ReportPageNumberTextBox">
          <Style TextAlign="Center" VerticalAlign="Middle">
            <Font Name="Segoe UI" />
          </Style>
        </TextBox>
      </Items>
    </PageFooterSection>
    <ReportHeaderSection Height="0.900039196014404in" Name="reportHeaderSection1">
      <Items>
        <TextBox Width="9.9999213218689in" Height="0.199921295046806in" Left="0.0000394185371988in" Top="0in" Value="Clerk of Superior Court" Name="textBox20">
          <Style TextAlign="Center" VerticalAlign="Middle" />
        </TextBox>
        <TextBox Width="9.99996058146159in" Height="0.200000122189522in" Left="0.00003941853841138in" Top="0.197837670644124in" Value="Return-Mail Item Report" Name="textBox18">
          <Style TextAlign="Center" VerticalAlign="Middle">
            <Font Name="Arial" Size="10pt" Bold="True" />
          </Style>
        </TextBox>
        <TextBox Width="9.99992100397746in" Height="0.173571586608887in" Left="0.00003941853841138in" Top="0.397916475931803in" Value="= Parameters.FromDate.Value.ToString(&quot;MM/dd/yyyy&quot;) + &quot; To &quot; + Parameters.ToDate.Value.ToString(&quot;MM/dd/yyyy&quot;)" Format="{0:d}" Name="textBox21">
          <Style TextAlign="Center" VerticalAlign="Middle" />
        </TextBox>
        <TextBox Width="4.40000059207281in" Height="0.19999997317791in" Left="3.90000025431315in" Top="0.700039227803548in" Value="Address" Name="textBox4">
          <Style TextAlign="Left" VerticalAlign="Middle">
            <Font Name="Arial" Bold="True" />
          </Style>
        </TextBox>
        <TextBox Width="2.70000046491623in" Height="0.19999997317791in" Left="1.19999980926514in" Top="0.699999809265137in" Value="Name" Name="textBox5">
          <Style TextAlign="Left" VerticalAlign="Middle">
            <Font Name="Arial" Bold="True" />
          </Style>
        </TextBox>
        <TextBox Width="0.800000170866648in" Height="0.199999734759331in" Left="8.3000005086263in" Top="0.700000047683716in" Value="# Of Docs" Name="textBox6">
          <Style TextAlign="Center" VerticalAlign="Middle">
            <Font Name="Arial" Bold="True" />
          </Style>
        </TextBox>
        <TextBox Width="0.899999956289927in" Height="0.19999997317791in" Left="9.10000038146973in" Top="0.699999809265137in" Value="CFNs" Name="textBox7">
          <Style TextAlign="Left" VerticalAlign="Middle">
            <Font Name="Arial" Bold="True" />
          </Style>
        </TextBox>
        <TextBox Width="0.885416686534882in" Height="0.199960649013519in" Left="0.489583333333333in" Top="0.199999809265137in" Value="= Now()" Format="{0:d}" Name="textBox16" />
        <TextBox Width="0.885416686534882in" Height="0.199960649013519in" Left="0.489583333333333in" Top="0.397916475931803in" Value="= Now()" Format="{0:t}" Name="textBox19" />
        <TextBox Width="1.19992101192474in" Height="0.19999997317791in" Left="0in" Top="0.699999968210856in" Value="Receipt #" Name="textBox1">
          <Style TextAlign="Center" VerticalAlign="Middle">
            <Font Name="Arial" Bold="True" />
          </Style>
        </TextBox>
        <TextBox Width="0.468750238418579in" Height="0.199960649013519in" Left="0in" Top="0.399999936421712in" Value="Time:" Name="textBox15">
          <Style TextAlign="Right" />
        </TextBox>
        <TextBox Width="0.468750149011612in" Height="0.199960649013519in" Left="0in" Top="0.202083269755046in" Value="Date:" Name="textBox17">
          <Style TextAlign="Right" />
        </TextBox>
      </Items>
    </ReportHeaderSection>
  </Items>
  <PageSettings PaperKind="Letter" Landscape="True">
    <Margins>
      <MarginsU Left="0.5in" Right="0.5in" Top="0.5in" Bottom="0.200000002980232in" />
    </Margins>
  </PageSettings>
  <StyleSheet>
    <StyleRule>
      <Style>
        <Padding Left="2pt" Right="2pt" />
      </Style>
      <Selectors>
        <TypeSelector Type="TextItemBase" />
        <TypeSelector Type="HtmlTextBox" />
      </Selectors>
    </StyleRule>
  </StyleSheet>
  <ReportParameters>
    <ReportParameter Name="FromDate" Type="DateTime" Text="From Date" Visible="True">
      <Value>
        <String>1/4/2017</String>
      </Value>
    </ReportParameter>
    <ReportParameter Name="ToDate" Type="DateTime" Text="To Date" Visible="True">
      <Value>
        <String>1/6/2017</String>
      </Value>
    </ReportParameter>
    <ReportParameter Name="Name" Visible="True" AllowNull="True">
      <AvailableValues DataSourceName="sqlMailBackReport" DisplayMember="= Fields.MName" ValueMember="= Fields.MName" />
    </ReportParameter>
  </ReportParameters>
</Report>

[Shane]

Correction, the file above is from the file that does not work.

 

This is from the file that works

<?xml version="1.0" encoding="utf-8"?>
<Report DataSourceName="sqlMailBackReport" Width="10.00448290507in" Name="MailBackReport" ShowSnapGrid="True" xmlns="http://schemas.telerik.com/reporting/2012/4.1">
  <DataSources>
    <SqlDataSource QueryDesignerState="null" ConnectionString="test" SelectCommand="Accounting.rptReceiptAddressMailingReport" SelectCommandType="StoredProcedure" Name="sqlMailBackReport" ParameterValues="{&quot;@FromDate&quot;:&quot;1/4/2017&quot;,&quot;@ToDate&quot;:&quot;1/6/2017&quot;,&quot;@Name&quot;:&quot;smith&quot;}">
      <Parameters>
        <SqlDataSourceParameter DbType="DateTime" Name="@FromDate">
          <Value>
            <String>= Parameters.FromDate.Value</String>
          </Value>
        </SqlDataSourceParameter>
        <SqlDataSourceParameter DbType="DateTime" Name="@ToDate">
          <Value>
            <String>= Parameters.ToDate.Value</String>
          </Value>
        </SqlDataSourceParameter>
        <SqlDataSourceParameter DbType="AnsiString" Name="@Name">
          <Value>
            <String>= Parameters.Name.Value</String>
          </Value>
        </SqlDataSourceParameter>
      </Parameters>
    </SqlDataSource>
  </DataSources>
  <Items>
    <PageHeaderSection Height="0.899999936421712in" Name="pageHeaderSection1">
      <Items>
        <TextBox Width="9.99992179870605in" Height="0.199921295046806in" Left="0in" Top="0in" Value="Clerk of Superior Court" Name="textBox20">
          <Style TextAlign="Center" VerticalAlign="Middle" />
        </TextBox>
        <TextBox Width="9.99996089935303in" Height="0.200000122189522in" Left="0in" Top="0.200039386749268in" Value="Return-Mail Item Report" Name="textBox18">
          <Style TextAlign="Center" VerticalAlign="Middle">
            <Font Name="Arial" Size="10pt" Bold="True" />
          </Style>
        </TextBox>
        <TextBox Width="9.99992084503174in" Height="0.173571586608887in" Left="0in" Top="0.400118192036947in" Value="= Parameters.FromDate.Value.ToString(&quot;MM/dd/yyyy&quot;) + &quot; To &quot; + Parameters.ToDate.Value.ToString(&quot;MM/dd/yyyy&quot;)" Format="{0:d}" Name="textBox21">
          <Style TextAlign="Center" VerticalAlign="Middle" />
        </TextBox>
        <TextBox Width="0.468750238418579in" Height="0.199960649013519in" Left="0in" Top="0.40706459681193in" Value="Time:" Name="textBox15">
          <Style TextAlign="Right" />
        </TextBox>
        <TextBox Width="0.468750149011612in" Height="0.199960649013519in" Left="0in" Top="0.209147930145264in" Value="Date:" Name="textBox17">
          <Style TextAlign="Right" />
        </TextBox>
        <TextBox Width="0.885416686534882in" Height="0.199960649013519in" Left="0.468828837076823in" Top="0.409187237421672in" Value="= Now()" Format="{0:t}" Name="textBox19" />
        <TextBox Width="0.885416686534882in" Height="0.199960649013519in" Left="0.468828837076823in" Top="0.209147930145264in" Value="= Now()" Format="{0:d}" Name="textBox16" />
        <TextBox Width="4.40000057220459in" Height="0.19999997317791in" Left="3.90216255187988in" Top="0.699999968210856in" Value="Address" Name="textBox4">
          <Style TextAlign="Left" VerticalAlign="Middle">
            <Font Name="Arial" Bold="True" />
          </Style>
        </TextBox>
        <TextBox Width="2.70000052452087in" Height="0.19999997317791in" Left="1.20208326975505in" Top="0.699999968210856in" Value="Name" Name="textBox5">
          <Style TextAlign="Left" VerticalAlign="Middle">
            <Font Name="Arial" Bold="True" />
          </Style>
        </TextBox>
        <TextBox Width="0.800000190734863in" Height="0.199999734759331in" Left="8.30224227905273in" Top="0.699999968210856in" Value="# Of Docs" Name="textBox6">
          <Style TextAlign="Center" VerticalAlign="Middle">
            <Font Name="Arial" Bold="True" />
          </Style>
        </TextBox>
        <TextBox Width="0.899999976158142in" Height="0.19999997317791in" Left="9.10232162475586in" Top="0.699999968210856in" Value="CFNs" Name="textBox7">
          <Style TextAlign="Left" VerticalAlign="Middle">
            <Font Name="Arial" Bold="True" />
          </Style>
        </TextBox>
        <TextBox Width="1.19992101192474in" Height="0.19999997317791in" Left="0.00208346048990885in" Top="0.699999968210856in" Value="Receipt #" Name="textBox1">
          <Style TextAlign="Center" VerticalAlign="Middle">
            <Font Name="Arial" Bold="True" />
          </Style>
        </TextBox>
      </Items>
    </PageHeaderSection>
    <DetailSection Height="0.200078805287679in" Name="detailSection1">
      <Style>
        <BorderStyle Top="Solid" Bottom="Solid" />
        <BorderColor Top="LightGray" Bottom="LightGray" />
        <BorderWidth Top="1px" Bottom="1px" />
      </Style>
      <Items>
        <TextBox Width="0.900000274181366in" Height="0.19999997317791in" Left="9.10448265075684in" Top="0in" Value="= Replace(Fields.InstNo, &quot;,&quot;, &quot;&#xD;&#xA;&quot;) " Format="{0}" Name="textBox11">
          <Style TextAlign="Left" VerticalAlign="Middle" />
        </TextBox>
        <TextBox Width="0.799999833106995in" Height="0.199960872530937in" Left="8.30440394083659in" Top="0in" Value="=Fields.DocNo" Format="{0}" Name="textBox12">
          <Style TextAlign="Center" VerticalAlign="Middle" />
        </TextBox>
        <TextBox Width="2.70000076293945in" Height="0.19999997317791in" Left="1.20424588521322in" Top="0in" Value="= Fields.MName" Format="{0}" Name="textBox8">
          <Style TextAlign="Left" VerticalAlign="Middle" />
        </TextBox>
        <TextBox Width="4.39999961853027in" Height="0.19999997317791in" Left="3.90432548522949in" Top="0in" Value="=Fields.Address1 + IIF(Fields.Address2 IS NOT Null,IIF(Fields.Address2 &lt;&gt; &quot;&quot;, &quot; &quot; +  Fields.Address2 + &quot; &quot;, &quot; &quot;), &quot; &quot;) + Fields.MCity + &quot;, &quot; + Fields.MState + &quot; &quot; + Fields.MZip" Format="{0:d}" Name="textBox9">
          <Style TextAlign="Left" VerticalAlign="Middle" />
        </TextBox>
        <TextBox Width="1.20000040531158in" Height="0.19999997317791in" Left="0.00416660308837891in" Top="0in" Value="= Fields.Receipt" Name="textBox3">
          <Style TextAlign="Center" VerticalAlign="Middle" />
        </TextBox>
      </Items>
      <ConditionalFormatting>
        <FormattingRule>
          <Style BackgroundColor="240, 240, 240" />
          <Filters>
            <Filter Expression="RowNumber()%2" Operator="Equal" Value="1" />
          </Filters>
        </FormattingRule>
      </ConditionalFormatting>
    </DetailSection>
    <PageFooterSection Height="0.599950671195984in" Name="pageFooterSection1">
      <Items>
        <TextBox Width="7.36599922180176cm" Height="0.491999685764313cm" Left="3.55208325386047in" Top="0.40625in" Value="=&quot;Page &quot; + PageNumber + &quot; of &quot; + PageCount" Name="ReportPageNumberTextBox">
          <Style TextAlign="Center" VerticalAlign="Middle">
            <Font Name="Segoe UI" />
          </Style>
        </TextBox>
      </Items>
    </PageFooterSection>
  </Items>
  <PageSettings PaperKind="Letter" Landscape="True" ColumnCount="1" ColumnSpacing="0in" ContinuousPaper="False">
    <Margins>
      <MarginsU Left="0.5in" Right="0.5in" Top="0.5in" Bottom="0.5in" />
    </Margins>
  </PageSettings>
  <StyleSheet>
    <StyleRule>
      <Style>
        <Padding Left="2pt" Right="2pt" />
      </Style>
      <Selectors>
        <TypeSelector Type="TextItemBase" />
        <TypeSelector Type="HtmlTextBox" />
      </Selectors>
    </StyleRule>
  </StyleSheet>
  <ReportParameters>
    <ReportParameter Name="FromDate" Type="DateTime" Visible="True">
      <Value>
        <String>1/4/2017</String>
      </Value>
    </ReportParameter>
    <ReportParameter Name="ToDate" Type="DateTime" Visible="True">
      <Value>
        <String>1/6/2017</String>
      </Value>
    </ReportParameter>
    <ReportParameter Name="Name" Visible="True" AllowNull="True">
      <AvailableValues DataSourceName="sqlMailBackReport" DisplayMember="= Fields.MName" ValueMember="= Fields.MName" />
    </ReportParameter>
  </ReportParameters>
</Report>

 

[Shane]

This happens on many reports. I even have it on several reports where the old one used to return let's say 8 rows. Now, it's returning 5 rows. Create a new one, copy the datasource, and etc to the new report, and all 8 start showing again in the new report.

[Stef]

Hello Shane,

The problem is related to the binding applied to the Detail section of the not working report. Please avoid setting zero width or height. As of R3 2016 sections have a CanShrink property - Design Considerations for Report Item Layout.

to resolve the problem, open the not working report in a report designer, select the Detail section and open the Bindings collection. Remove the binding to the Height property.

Regards,
Stef
Telerik by Progress

[Shane]

1) I didn't realize that the canShrink filter had been added (awesome)

2) That worked. Thank you for your help!