Here is my scenario:

 I have a report with multiple parameters, 2 of which are not working properly.  One of these parameters is called 'ParentOrg' and will return a list of all organizations.  The other is called 'Org' which takes the parameter value from 'ParentOrg' and makes sure that the same value is not included in the drop down list.

ParentOrg = (1,2,3,4,5,6)   and Org = (1,2,3,4,5,6)

But, when the report renders and I have chosen ParentOrg = 3, the Org drop down should only show/allow Org = (1,2,4,5,6).

The report will render with default values, but when I try to change the ParentOrg, the report crashes.

Can someone point me in the right direction?

 Thanks,

Phillip

I've seen this question posted in years past but wanted to see if there's been any change to Telerik Reporting to facilitate adding a conditional page break based on report group page number to add a blank page for reports with odd page numbers.This is the only thing I've been able to find that is keeping us from converting to Telerik Reporting over Reporting Services. We mail reports out to thousands of people and need to be able to separate the reports for insertion into different envelopes, pretty hard when the first page of one person's report prints on the back of another person's. We do so much volume it just isn't an option to print on single sides. If anyone knows if this is now possible or of a work-around, I'd be interested in hearing it.

Hi Team,

 We have two applications one is asp.net mvc web application which will make call to asp.net web api to get telerik report data as rest api call, till now we are using asp.net in memory cache, now i am trying to store the cache in a shared path, below is the line of code that i updated after adding this all my api POST calls to ReportViewer controller are failing, I see there are two calls being made one is options call the other one is post call, options call is getting 200 as reponse but post is failing with status code 400, I can see some files getting created in shared path "C:\\TempReportCache", please see the attched screenshot "ApiCalls Status code to  ReportViewer Api controller.jpg" which controls call trace and their response. 

please let me know what is the issue and do i need to update anything else in order to store cache in a shared path?

 

[EnableCors(origins: "*", headers: "*", methods: "*")]
    public class ReportViewerController : ReportsControllerBase 
    {

protected override ICache CreateCache()
        {
            return Telerik.Reporting.Services.Engine.CacheFactory.CreateFileCache("C:\\TempReportCache");
        }

}

 

​

 

 

​

​

I'm looking at possible solutions for printing from a Windows Service (by "service" I mean a continuous UI-less background process, not a web service).

My question is, can I use and print from Telerik Reporting from within a Windows service, and is that a supported/appropriate use of Telerik Reporting?

I'm aware that the System.Drawing.Printing classes are not supported / not available within a Windows service. I want to check whether that's the case for the Telerik DLLs. I've looked through the documentation and the support forum but I can't see any evidence indicating support or lack of it.

Thanks,

Chris N

My table report cuts off the far right portion of the table and puts it on another line. This happens when I export to Pdf or when I view it in print preview. I am using the latest version (2015 Q2) of the HTML 5 report view.  I want the report to appear as it appears in the report viewer when I export it to Pdf. 

 

Here is the report definition:

 

<?xml version="1.0" encoding="utf-8"?>
<Report Width="11.9999605814616in" Name="AttendanceReport" xmlns="http://schemas.telerik.com/reporting/2012/3.8">
  <DataSources>
    <SqlDataSource ConnectionString="ZENContext" SelectCommand="exec spReporting_AttendanceReport @InterventionId, @ProgramId, @MethodId, @EventId,&#xD;&#xA;@EducatorId, @City, @Location, @StartDate, @EndDate" Name="sqlDataSource1">
      <Parameters>
        <SqlDataSourceParameter DbType="String" Name="@InterventionId">
          <Value>
            <String>= Parameters.InterventionId.Value</String>
          </Value>
        </SqlDataSourceParameter>
        <SqlDataSourceParameter DbType="Int32" Name="@ProgramId">
          <Value>
            <String>= Parameters.ProgramId.Value</String>
          </Value>
        </SqlDataSourceParameter>
        <SqlDataSourceParameter DbType="String" Name="@MethodId">
          <Value>
            <String>= Parameters.MethodId.Value</String>
          </Value>
        </SqlDataSourceParameter>
        <SqlDataSourceParameter DbType="String" Name="@EventId">
          <Value>
            <String>= Parameters.EventId.Value</String>
          </Value>
        </SqlDataSourceParameter>
        <SqlDataSourceParameter DbType="String" Name="@EducatorId">
          <Value>
            <String>= Parameters.EducatorId.Value</String>
          </Value>
        </SqlDataSourceParameter>
        <SqlDataSourceParameter DbType="String" Name="@City">
          <Value>
            <String>= Parameters.City.Value</String>
          </Value>
        </SqlDataSourceParameter>
        <SqlDataSourceParameter DbType="String" Name="@Location">
          <Value>
            <String>= Parameters.Location.Value</String>
          </Value>
        </SqlDataSourceParameter>
        <SqlDataSourceParameter DbType="DateTime" Name="@StartDate">
          <Value>
            <String>= Parameters.StartDate.Value</String>
          </Value>
        </SqlDataSourceParameter>
        <SqlDataSourceParameter DbType="DateTime" Name="@EndDate">
          <Value>
            <String>= Parameters.EndDate.Value</String>
          </Value>
        </SqlDataSourceParameter>
      </Parameters>
    </SqlDataSource>
  </DataSources>
  <Items>
    <PageHeaderSection Height="1in" Name="pageHeaderSection1">
      <Style BackgroundColor="255, 255, 255" />
      <Items>
        <TextBox Width="2.69999980926514in" Height="0.400000015894572in" Left="0.100000381469727in" Top="0.0999999841054281in" Value="Attendance Report" Name="textBox1">
          <Style>
            <Font Name="Times New Roman" Size="20pt" />
          </Style>
        </TextBox>
      </Items>
    </PageHeaderSection>
    <DetailSection Height="2in" Name="detailSection1">
      <Items>
        <Table DataSourceName="sqlDataSource1" Width="9.80000026226044in" Height="0.4in" Left="0.100000381469727in" Top="0.199999968210856in" Name="table1" StyleName="Corporate.TableNormal">
          <Body>
            <Cells>
              <TableCell RowIndex="0" ColumnIndex="0" RowSpan="1" ColumnSpan="1">
                <ReportItem>
                  <TextBox Width="0.999999988018249in" Height="0.2in" Left="0in" Top="0in" Value="= Fields.InterventionName" Name="textBox15" StyleName="Corporate.TableBody" />
                </ReportItem>
              </TableCell>
              <TableCell RowIndex="0" ColumnIndex="1" RowSpan="1" ColumnSpan="1">
                <ReportItem>
                  <TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="= Fields.ProgramId" Name="textBox16" StyleName="Corporate.TableBody" />
                </ReportItem>
              </TableCell>
              <TableCell RowIndex="0" ColumnIndex="2" RowSpan="1" ColumnSpan="1">
                <ReportItem>
                  <TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="= Fields.ProgramName" Name="textBox17" StyleName="Corporate.TableBody" />
                </ReportItem>
              </TableCell>
              <TableCell RowIndex="0" ColumnIndex="3" RowSpan="1" ColumnSpan="1">
                <ReportItem>
                  <TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="= Fields.MethodName" Name="textBox18" StyleName="Corporate.TableBody" />
                </ReportItem>
              </TableCell>
              <TableCell RowIndex="0" ColumnIndex="4" RowSpan="1" ColumnSpan="1">
                <ReportItem>
                  <TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="= Fields.EventId" Name="textBox19" StyleName="Corporate.TableBody" />
                </ReportItem>
              </TableCell>
              <TableCell RowIndex="0" ColumnIndex="5" RowSpan="1" ColumnSpan="1">
                <ReportItem>
                  <TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="= Fields.EventName" Name="textBox20" StyleName="Corporate.TableBody" />
                </ReportItem>
              </TableCell>
              <TableCell RowIndex="0" ColumnIndex="6" RowSpan="1" ColumnSpan="1">
                <ReportItem>
                  <TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="= Fields.Educator" Name="textBox21" StyleName="Corporate.TableBody" />
                </ReportItem>
              </TableCell>
              <TableCell RowIndex="0" ColumnIndex="7" RowSpan="1" ColumnSpan="1">
                <ReportItem>
                  <TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="= Fields.Location" Name="textBox22" StyleName="Corporate.TableBody" />
                </ReportItem>
              </TableCell>
              <TableCell RowIndex="0" ColumnIndex="8" RowSpan="1" ColumnSpan="1">
                <ReportItem>
                  <TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="= Fields.ParticipationStatus" Name="textBox23" StyleName="Corporate.TableBody" />
                </ReportItem>
              </TableCell>
              <TableCell RowIndex="0" ColumnIndex="9" RowSpan="1" ColumnSpan="1">
                <ReportItem>
                  <TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="= Fields.ParticipationStatusCount" Name="textBox24" StyleName="Corporate.TableBody" />
                </ReportItem>
              </TableCell>
              <TableCell RowIndex="0" ColumnIndex="10" RowSpan="1" ColumnSpan="1">
                <ReportItem>
                  <TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="= Fields.StartDate" Name="textBox25" StyleName="Corporate.TableBody" />
                </ReportItem>
              </TableCell>
              <TableCell RowIndex="0" ColumnIndex="11" RowSpan="1" ColumnSpan="1">
                <ReportItem>
                  <TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="= Fields.EndDate" Name="textBox26" StyleName="Corporate.TableBody" />
                </ReportItem>
              </TableCell>
            </Cells>
            <Columns>
              <Column Width="1.00000006103394in" />
              <Column Width="0.800000078033429in" />
              <Column Width="0.800000078033429in" />
              <Column Width="0.800000078033429in" />
              <Column Width="0.800000078033429in" />
              <Column Width="0.800000078033429in" />
              <Column Width="0.800000078033429in" />
              <Column Width="0.800000078033429in" />
              <Column Width="0.800000078033429in" />
              <Column Width="0.800000078033429in" />
              <Column Width="0.800000078033429in" />
              <Column Width="0.800000078033429in" />
            </Columns>
            <Rows>
              <Row Height="0.2in" />
            </Rows>
          </Body>
          <Corner />
          <RowGroups>
            <TableGroup Name="Detail">
              <Groupings>
                <Grouping />
              </Groupings>
            </TableGroup>
          </RowGroups>
          <ColumnGroups>
            <TableGroup>
              <ReportItem>
                <TextBox Width="0.999999988018249in" Height="0.2in" Left="0in" Top="0in" Value="Intervention" Name="textBox3" StyleName="Corporate.TableHeader" />
              </ReportItem>
            </TableGroup>
            <TableGroup>
              <ReportItem>
                <TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="Program Id" Name="textBox4" StyleName="Corporate.TableHeader" />
              </ReportItem>
            </TableGroup>
            <TableGroup>
              <ReportItem>
                <TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="Program" Name="textBox5" StyleName="Corporate.TableHeader" />
              </ReportItem>
            </TableGroup>
            <TableGroup>
              <ReportItem>
                <TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="Method" Name="textBox6" StyleName="Corporate.TableHeader" />
              </ReportItem>
            </TableGroup>
            <TableGroup>
              <ReportItem>
                <TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="Event Id" Name="textBox7" StyleName="Corporate.TableHeader" />
              </ReportItem>
            </TableGroup>
            <TableGroup>
              <ReportItem>
                <TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="Event" Name="textBox8" StyleName="Corporate.TableHeader" />
              </ReportItem>
            </TableGroup>
            <TableGroup>
              <ReportItem>
                <TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="Educator" Name="textBox9" StyleName="Corporate.TableHeader" />
              </ReportItem>
            </TableGroup>
            <TableGroup>
              <ReportItem>
                <TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="Location" Name="textBox10" StyleName="Corporate.TableHeader" />
              </ReportItem>
            </TableGroup>
            <TableGroup>
              <ReportItem>
                <TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="Status" Name="textBox11" StyleName="Corporate.TableHeader" />
              </ReportItem>
            </TableGroup>
            <TableGroup>
              <ReportItem>
                <TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="Count" Name="textBox12" StyleName="Corporate.TableHeader" />
              </ReportItem>
            </TableGroup>
            <TableGroup>
              <ReportItem>
                <TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="Start Date" Name="textBox13" StyleName="Corporate.TableHeader" />
              </ReportItem>
            </TableGroup>
            <TableGroup>
              <ReportItem>
                <TextBox Width="0.8in" Height="0.2in" Left="0in" Top="0in" Value="End Date" Name="textBox14" StyleName="Corporate.TableHeader" />
              </ReportItem>
            </TableGroup>
          </ColumnGroups>
        </Table>
      </Items>
    </DetailSection>
    <PageFooterSection Height="1in" Name="pageFooterSection1">
      <Items>
        <TextBox Width="1.99999968210856in" Height="0.2999607026577in" Left="0.00003941853841146in" Top="0.100000143051147in" Value="=Parameters.TimeRan.Value" Name="textBox2" />
      </Items>
    </PageFooterSection>
  </Items>
  <StyleSheet>
    <StyleRule>
      <Style>
        <Padding Left="2pt" Right="2pt" />
      </Style>
      <Selectors>
        <TypeSelector Type="TextItemBase" />
        <TypeSelector Type="HtmlTextBox" />
      </Selectors>
    </StyleRule>
    <StyleRule>
      <Style Color="Black">
        <BorderStyle Default="Solid" />
        <BorderColor Default="Black" />
        <BorderWidth Default="1px" />
        <Font Name="Tahoma" Size="9pt" />
      </Style>
      <Selectors>
        <StyleSelector Type="Table" StyleName="Corporate.TableNormal" />
      </Selectors>
    </StyleRule>
    <StyleRule>
      <Style BackgroundColor="28, 58, 112" Color="White" VerticalAlign="Middle">
        <BorderStyle Default="Solid" />
        <BorderColor Default="Black" />
        <BorderWidth Default="1px" />
        <Font Name="Tahoma" Size="10pt" />
      </Style>
      <Selectors>
        <DescendantSelector>
          <Selectors>
            <TypeSelector Type="Table" />
            <StyleSelector Type="ReportItem" StyleName="Corporate.TableHeader" />
          </Selectors>
        </DescendantSelector>
      </Selectors>
    </StyleRule>
    <StyleRule>
      <Style>
        <BorderStyle Default="Solid" />
        <BorderColor Default="Black" />
        <BorderWidth Default="1px" />
        <Font Name="Tahoma" Size="9pt" />
      </Style>
      <Selectors>
        <DescendantSelector>
          <Selectors>
            <TypeSelector Type="Table" />
            <StyleSelector Type="ReportItem" StyleName="Corporate.TableBody" />
          </Selectors>
        </DescendantSelector>
      </Selectors>
    </StyleRule>
  </StyleSheet>
  <PageSettings>
    <PageSettings PaperKind="Letter" Landscape="False" ColumnCount="1" ColumnSpacing="0in">
      <Margins>
        <MarginsU Left="1in" Right="1in" Top="1in" Bottom="1in" />
      </Margins>
    </PageSettings>
  </PageSettings>
  <ReportParameters>
    <ReportParameter Name="InterventionId" Type="Integer" AllowNull="True">
      <Value>
        <String></String>
      </Value>
    </ReportParameter>
    <ReportParameter Name="ProgramId" Type="Integer" AllowNull="True">
      <Value>
        <String></String>
      </Value>
    </ReportParameter>
    <ReportParameter Name="MethodId" Type="Integer" AllowNull="True" />
    <ReportParameter Name="EventId" Type="Integer" AllowNull="True" />
    <ReportParameter Name="EducatorId" Text="EducatorId" AllowNull="True" />
    <ReportParameter Name="City" AllowNull="True" />
    <ReportParameter Name="Location" AllowNull="True" />
    <ReportParameter Name="StartDate" Type="DateTime" AllowNull="True" />
    <ReportParameter Name="EndDate" Type="DateTime" AllowNull="True" />
    <ReportParameter Name="TimeRan" Type="DateTime" AllowNull="True">
      <Value>
        <String></String>
      </Value>
    </ReportParameter>
  </ReportParameters>
</Report>

 

Thanks in advance.

Hello people,

I have created "search kind of " functionality by using Report parameter and Filters. It works fine, but now I need to change button text from preview to something else? Whole report is in Finnish and that one button is in English and text is not very descriptive for functionality.

 

Thanks in advance.

 

Mikko

I have multiple textboxes in the detail section. If I set visibility of one textbox to false with conditional formatting empty space is visible.

Also I put

in the constructor.

How can I remove that empty space and move below textboxes on top? You can see my report from report designer and report viewer in the attached images.

Thanks

Hi,

How to display multidimentional data (multipile line, grouped) on a tabular grid.

 Regards,

I have a data structure where some fields may or may not be present. If the fields are not there, I just don't want to display anything. How do I suppress the 'object not found in this context' error message? There appears to be a thread that discussed this very issue, but the link to the answer has been deleted:

http://www.telerik.com/help/reporting/telerik.reporting-telerik.reporting.processing.renderingresult_members.html

 

 

I have a basic report that has about 10 columns and I have created the table and put the =field.XXXX in each text box.  I had it working using the report and saw that I needed to use the table since the export adds merged cells to EXCEL.  What I am trying to figure out is how to bind data to it.  I used a datatable when I created it originally but it doesn't seem to work using the table.  Can someone post a code snippet to populate table cells?  Let me know if you need more information.

 

thanks for help in advance,

Mark