Telerik Forums
Reporting Forum
1 answer
116 views
I'm getting errors when opening an exported report from the report book.

Telerik.Reporting.OpenXmlRendering.Spreadsheet.Workbook.TrimName

This appears to only trim one instance of an invalid character.
"Report Name 04/24/3013" <= This consists of multiple forward slashes, but only one is removed.

if (!string.IsNullOrEmpty(name))
    {
        string str = ":\\/?*[]";
        for (int i = 0; i < str.Length; i++)
        {
            char chr = str[i];
            int num = name.IndexOf(chr);
            if (num >= 0)
            {
                name = name.Remove(num, 1);
            }
        }
        if (name.Length > 31)
        {
            name = name.Remove(31);
        }
    }
Elian
Telerik team
 answered on 29 Apr 2013
3 answers
175 views
Hello,

I'm building a report using Report Designer Q2 2012 but I have a problem with labels that are too close to each other. I want to hide them in the chart but I can't find a way to do that. So let me explain my scenario:

I have a table with 3 columns: ActivityName, DayNr and NrOfMessages. ActivityName can be many things, so the chart series must be dynamic. I use the property "DataGroupColumn" and assign it value to "ActivityName" and that way I have the dynamic series generated. But now I can't change the series appearance and change "ShowLabels" property to false. I can't make this report using code, it must be done in the designer and I can't use either the "IntelligentLabelsEnabled" as true because I lose a lot of performance. I have put an attachment with a print screen of my resulting graph so you can understand better.

Can you help me?

Best regards,
Paulo Mendonça
Elian
Telerik team
 answered on 29 Apr 2013
4 answers
120 views
Hi All,

I am new to telerik view, I have been trying to learn it and followed the telerik video to design a Sales Dashboard Report.

After I complete the Cross tab report and want to see the report designed so far and click Preview, I am encountering the below error:
Do not know what is the problem. The Error is as below:
"An error has occurred while processing Table 'crosstab1': Value of Top/Bootom  filters evaluate to integer"

Please find the code generated by the designer below:
namespace ReportsLibrary
{
    partial class DashboardReport
    {
        #region Component Designer generated code
        /// <summary>
        /// Required method for telerik Reporting designer support - do not modify
        /// the contents of this method with the code editor.
        /// </summary>
        private void InitializeComponent()
        {
            System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(DashboardReport));
            Telerik.Reporting.TableGroup tableGroup1 = new Telerik.Reporting.TableGroup();
            Telerik.Reporting.TableGroup tableGroup2 = new Telerik.Reporting.TableGroup();
            Telerik.Reporting.TableGroup tableGroup3 = new Telerik.Reporting.TableGroup();
            Telerik.Reporting.ReportParameter reportParameter1 = new Telerik.Reporting.ReportParameter();
            Telerik.Reporting.Drawing.StyleRule styleRule1 = new Telerik.Reporting.Drawing.StyleRule();
            this.textBox7 = new Telerik.Reporting.TextBox();
            this.textBox9 = new Telerik.Reporting.TextBox();
            this.textBox8 = new Telerik.Reporting.TextBox();
            this.yeardatasource = new Telerik.Reporting.SqlDataSource();
            this.pageHeaderSection1 = new Telerik.Reporting.PageHeaderSection();
            this.textBox1 = new Telerik.Reporting.TextBox();
            this.pictureBox1 = new Telerik.Reporting.PictureBox();
            this.textBox4 = new Telerik.Reporting.TextBox();
            this.detail = new Telerik.Reporting.DetailSection();
            this.textBox2 = new Telerik.Reporting.TextBox();
            this.crosstab1 = new Telerik.Reporting.Crosstab();
            this.textBox6 = new Telerik.Reporting.TextBox();
            this.textBox10 = new Telerik.Reporting.TextBox();
            this.textBox5 = new Telerik.Reporting.TextBox();
            this.SalesPersonDatasource = new Telerik.Reporting.SqlDataSource();
            this.pageFooterSection1 = new Telerik.Reporting.PageFooterSection();
            this.textBox3 = new Telerik.Reporting.TextBox();
            ((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
            // 
            // textBox7
            // 
            this.textBox7.Name = "textBox7";
            this.textBox7.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1D), Telerik.Reporting.Drawing.Unit.Inch(0.5D));
            this.textBox7.Value = "= \'Q\' + ReportsLibrary.DashboardReport.Qtr(Fields.OrderDate)";
            // 
            // textBox9
            // 
            this.textBox9.Name = "textBox9";
            this.textBox9.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2D), Telerik.Reporting.Drawing.Unit.Inch(0.5D));
            this.textBox9.StyleName = "";
            this.textBox9.Value = "Total";
            // 
            // textBox8
            // 
            this.textBox8.Name = "textBox8";
            this.textBox8.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1D), Telerik.Reporting.Drawing.Unit.Inch(0.5D));
            this.textBox8.Value = "= Fields.SalesPersonFullName";
            // 
            // yeardatasource
            // 
            this.yeardatasource.ConnectionString = "ReportsLibrary.Properties.Settings.AdventureWorks";
            this.yeardatasource.Name = "yeardatasource";
            this.yeardatasource.SelectCommand = "SELECT \r\n  Distinct YEAR(OrderDate) as YEAR\r\n  FROM Sales.SalesOrderHeader so\r\nOR" +
    "DER BY YEAR asc\r\n  ";
            // 
            // pageHeaderSection1
            // 
            this.pageHeaderSection1.Height = Telerik.Reporting.Drawing.Unit.Inch(0.90000009536743164D);
            this.pageHeaderSection1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
            this.textBox1,
            this.pictureBox1,
            this.textBox4});
            this.pageHeaderSection1.Name = "pageHeaderSection1";
            // 
            // textBox1
            // 
            this.textBox1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D), Telerik.Reporting.Drawing.Unit.Inch(3.9378803194267675E-05D));
            this.textBox1.Name = "textBox1";
            this.textBox1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(5.9999213218688965D), Telerik.Reporting.Drawing.Unit.Inch(0.60000008344650269D));
            this.textBox1.Style.BackgroundColor = System.Drawing.Color.White;
            this.textBox1.Style.Color = System.Drawing.Color.FromArgb(((int)(((byte)(135)))), ((int)(((byte)(145)))), ((int)(((byte)(164)))));
            this.textBox1.Style.Font.Name = "Arial Black";
            this.textBox1.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(30D);
            this.textBox1.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
            this.textBox1.Value = "Quarterly Sales";
            // 
            // pictureBox1
            // 
            this.pictureBox1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D), Telerik.Reporting.Drawing.Unit.Inch(3.9378803194267675E-05D));
            this.pictureBox1.MimeType = "image/bmp";
            this.pictureBox1.Name = "pictureBox1";
            this.pictureBox1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.0999606847763062D), Telerik.Reporting.Drawing.Unit.Inch(0.60000008344650269D));
            this.pictureBox1.Value = ((object)(resources.GetObject("pictureBox1.Value")));
            // 
            // textBox4
            // 
            this.textBox4.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0.60011816024780273D));
            this.textBox4.Name = "textBox4";
            this.textBox4.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(5.9999213218688965D), Telerik.Reporting.Drawing.Unit.Inch(0.19988186657428742D));
            this.textBox4.Style.BackgroundColor = System.Drawing.Color.Silver;
            this.textBox4.Style.Color = System.Drawing.Color.FromArgb(((int)(((byte)(135)))), ((int)(((byte)(145)))), ((int)(((byte)(164)))));
            this.textBox4.Style.Font.Name = "Arial Black";
            this.textBox4.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(10D);
            this.textBox4.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
            this.textBox4.Value = "(Internal Use Only)";
            // 
            // detail
            // 
            this.detail.Height = Telerik.Reporting.Drawing.Unit.Inch(2D);
            this.detail.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
            this.textBox2,
            this.crosstab1});
            this.detail.Name = "detail";
            // 
            // textBox2
            // 
            this.textBox2.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D), Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D));
            this.textBox2.Name = "textBox2";
            this.textBox2.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(5.7999610900878906D), Telerik.Reporting.Drawing.Unit.Inch(0.3999999463558197D));
            this.textBox2.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(135)))), ((int)(((byte)(145)))), ((int)(((byte)(164)))));
            this.textBox2.Style.Color = System.Drawing.Color.FromArgb(((int)(((byte)(64)))), ((int)(((byte)(0)))), ((int)(((byte)(64)))));
            this.textBox2.Style.Font.Name = "Arial Black";
            this.textBox2.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(16D);
            this.textBox2.Value = "Top 5 Performing Agents";
            // 
            // crosstab1
            // 
            this.crosstab1.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(Telerik.Reporting.Drawing.Unit.Inch(1D)));
            this.crosstab1.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(Telerik.Reporting.Drawing.Unit.Inch(2D)));
            this.crosstab1.Body.Rows.Add(new Telerik.Reporting.TableBodyRow(Telerik.Reporting.Drawing.Unit.Inch(0.5D)));
            this.crosstab1.Body.SetCellContent(0, 0, this.textBox6);
            this.crosstab1.Body.SetCellContent(0, 1, this.textBox10);
            tableGroup1.Groupings.Add(new Telerik.Reporting.Grouping("= ReportsLibrary.DashboardReport.Qtr(Fields.OrderDate)"));
            tableGroup1.Name = "Quarter";
            tableGroup1.ReportItem = this.textBox7;
            tableGroup1.Sortings.Add(new Telerik.Reporting.Sorting("= ReportsLibrary.DashboardReport.Qtr(Fields.OrderDate)", Telerik.Reporting.SortDirection.Asc));
            //tableGroup2.Name = "Group1";
            tableGroup2.ReportItem = this.textBox9;
            this.crosstab1.ColumnGroups.Add(tableGroup1);
            this.crosstab1.ColumnGroups.Add(tableGroup2);
            this.crosstab1.Corner.SetCellContent(0, 0, this.textBox5);
            this.crosstab1.DataSource = this.SalesPersonDatasource;
            this.crosstab1.Filters.Add(new Telerik.Reporting.Filter("=Fields.OrderDate.Year", Telerik.Reporting.FilterOperator.Equal, "=Parameters.ReportYear.Value"));
            this.crosstab1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
            this.textBox6,
            this.textBox10,
            this.textBox7,
            this.textBox9,
            this.textBox5,
            this.textBox8});
            this.crosstab1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D), Telerik.Reporting.Drawing.Unit.Inch(0.40011820197105408D));
            this.crosstab1.Name = "crosstab1";
            tableGroup3.Filters.Add(new Telerik.Reporting.Filter("= Sum(Fields.SubTotal)", Telerik.Reporting.FilterOperator.TopN, "5"));
            tableGroup3.Groupings.Add(new Telerik.Reporting.Grouping("=Fields.SalesPersonFullName"));
            tableGroup3.Name = "SalesPersonFullName";
            tableGroup3.ReportItem = this.textBox8;
            tableGroup3.Sortings.Add(new Telerik.Reporting.Sorting("= Sum(Fields.SubTotal)", Telerik.Reporting.SortDirection.Desc));
            this.crosstab1.RowGroups.Add(tableGroup3);
            this.crosstab1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(4D), Telerik.Reporting.Drawing.Unit.Inch(1D));
            // 
            // textBox6
            // 
            this.textBox6.Format = "{0:#.}";
            this.textBox6.Name = "textBox6";
            this.textBox6.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1D), Telerik.Reporting.Drawing.Unit.Inch(0.5D));
            this.textBox6.Value = "= Sum(Fields.SubTotal) / 1000.0";
            // 
            // textBox10
            // 
            this.textBox10.Name = "textBox10";
            this.textBox10.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2D), Telerik.Reporting.Drawing.Unit.Inch(0.5D));
            this.textBox10.StyleName = "";
            this.textBox10.Value = "= Sum(Fields.SubTotal) / 1000.0";
            // 
            // textBox5
            // 
            this.textBox5.Name = "textBox5";
            this.textBox5.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1D), Telerik.Reporting.Drawing.Unit.Inch(0.5D));
            this.textBox5.Value = "Sales Person ";
            // 
            // SalesPersonDatasource
            // 
            this.SalesPersonDatasource.ConnectionString = "ReportsLibrary.Properties.Settings.AdventureWorks";
            this.SalesPersonDatasource.Name = "SalesPersonDatasource";
            this.SalesPersonDatasource.Parameters.AddRange(new Telerik.Reporting.SqlDataSourceParameter[] {
            new Telerik.Reporting.SqlDataSourceParameter("@ReportYear", System.Data.DbType.Int32, "=Parameters.ReportYear.Value")});
            this.SalesPersonDatasource.SelectCommand = resources.GetString("SalesPersonDatasource.SelectCommand");
            // 
            // pageFooterSection1
            // 
            this.pageFooterSection1.Height = Telerik.Reporting.Drawing.Unit.Inch(2D);
            this.pageFooterSection1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
            this.textBox3});
            this.pageFooterSection1.Name = "pageFooterSection1";
            // 
            // textBox3
            // 
            this.textBox3.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D), Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D));
            this.textBox3.Name = "textBox3";
            this.textBox3.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(5.7999610900878906D), Telerik.Reporting.Drawing.Unit.Inch(0.3999999463558197D));
            this.textBox3.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(135)))), ((int)(((byte)(145)))), ((int)(((byte)(164)))));
            this.textBox3.Style.Color = System.Drawing.Color.FromArgb(((int)(((byte)(64)))), ((int)(((byte)(0)))), ((int)(((byte)(64)))));
            this.textBox3.Style.Font.Name = "Arial Black";
            this.textBox3.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(16D);
            this.textBox3.Value = "Top 5 Performing Stores";
            // 
            // DashboardReport
            // 
            this.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
            this.pageHeaderSection1,
            this.detail,
            this.pageFooterSection1});
            this.Name = "DashboardReport";
            this.PageSettings.Landscape = true;
            this.PageSettings.Margins = new Telerik.Reporting.Drawing.MarginsU(Telerik.Reporting.Drawing.Unit.Inch(0.30000001192092896D), Telerik.Reporting.Drawing.Unit.Inch(1D), Telerik.Reporting.Drawing.Unit.Inch(0.40000000596046448D), Telerik.Reporting.Drawing.Unit.Inch(1D));
            this.PageSettings.PaperKind = System.Drawing.Printing.PaperKind.Letter;
            reportParameter1.AutoRefresh = true;
            reportParameter1.AvailableValues.DataSource = this.yeardatasource;
            reportParameter1.AvailableValues.DisplayMember = "= Fields.YEAR";
            reportParameter1.AvailableValues.ValueMember = "= Fields.YEAR";
            reportParameter1.Name = "ReportYear";
            reportParameter1.Text = "Sales for Year";
            reportParameter1.Type = Telerik.Reporting.ReportParameterType.Integer;
            reportParameter1.Value = "2001";
            reportParameter1.Visible = true;
            this.ReportParameters.Add(reportParameter1);
            this.Style.BackgroundColor = System.Drawing.Color.White;
            styleRule1.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
            new Telerik.Reporting.Drawing.TypeSelector(typeof(Telerik.Reporting.TextItemBase)),
            new Telerik.Reporting.Drawing.TypeSelector(typeof(Telerik.Reporting.HtmlTextBox))});
            styleRule1.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Point(2D);
            styleRule1.Style.Padding.Right = Telerik.Reporting.Drawing.Unit.Point(2D);
            this.StyleSheet.AddRange(new Telerik.Reporting.Drawing.StyleRule[] {
            styleRule1});
            this.Width = Telerik.Reporting.Drawing.Unit.Inch(6D);
            ((System.ComponentModel.ISupportInitialize)(this)).EndInit();

        }
        #endregion

        private Telerik.Reporting.PageHeaderSection pageHeaderSection1;
        private Telerik.Reporting.DetailSection detail;
        private Telerik.Reporting.PageFooterSection pageFooterSection1;
        private Telerik.Reporting.TextBox textBox1;
        private Telerik.Reporting.PictureBox pictureBox1;
        private Telerik.Reporting.TextBox textBox4;
        private Telerik.Reporting.TextBox textBox2;
        private Telerik.Reporting.TextBox textBox3;
        private Telerik.Reporting.SqlDataSource yeardatasource;
        private Telerik.Reporting.Crosstab crosstab1;
        private Telerik.Reporting.TextBox textBox6;
        private Telerik.Reporting.TextBox textBox7;
        private Telerik.Reporting.TextBox textBox5;
        private Telerik.Reporting.SqlDataSource SalesPersonDatasource;
        private Telerik.Reporting.TextBox textBox8;
        private Telerik.Reporting.TextBox textBox10;
        private Telerik.Reporting.TextBox textBox9;
    }
}

Please the attached code for the userdefined function Qtr(Quarter).
namespace ReportsLibrary
{
    using System;
    using System.ComponentModel;
    using System.Drawing;
    using System.Windows.Forms;
    using Telerik.Reporting;
    using Telerik.Reporting.Drawing;

    /// <summary>
    /// Summary description for DashboardReport.
    /// </summary>
    public partial class DashboardReport : Telerik.Reporting.Report
    {
        public DashboardReport()
        {
            //
            // Required for telerik Reporting designer support
            //
            InitializeComponent();

            //
            // TODO: Add any constructor code after InitializeComponent call
            //
        }
        public static int Qtr(DateTime date)
        {
            return (1 + ((date.Month - 1) / 3));
        }
    } 
}

Thanks in advance.

Rgds,
Nirmal
Peter
Telerik team
 answered on 29 Apr 2013
4 answers
971 views
Hi there,

I've created  a set of reports, most of which have a chart and a grid.
The reports pull data from a SQL data source, and pass in a StartDate and EndDate parameter.
I've set these up as Report Parameters, and these are visible when viewing the report as users will need to change date ranges.

The report parameters have a default value, i.e. I set the value in design time using a function. This sets StartDate to first day of the current month, and EndDate to last day of the current month.

However, when changing the values of these parameters on the report viewer, it seems to always use the design time set values, the value the user enters is never used.

Why is this? Should I be setting the default value in another manner?
I've tried setting 'Value' in the ReportParameter Collection Editor from design mode in VS2012, and I've tried setting it in the constructor of the report after InitializeComponent.
Stephen
Top achievements
Rank 1
 answered on 29 Apr 2013
12 answers
326 views
Hello,
the enclosed code was working with the 2011 Q3 version of Telerik Reporting but not with the 2012 Q1 version.
The idea is to define a class that inherits from Telerik.Reporting.Report and to base the reports on this class instead of the Telerik one. The goal is to put in this class code that is common to more than one report to avoid duplicating code.
So I define a class like this:
using System;
using Telerik.Reporting;
 
namespace TestInheritedReport
{
  public class MyReport : Telerik.Reporting.Report
  {
  }
}
And now my report inherits from MyReport instead of Telerik.Reporting.Report.
The problem is now that every time I change something in the designer and click on the preview tab, I have an error message that says:
The service Telerik.Reporting.Design.Interfaces.IRootDesignerPresenter already
exists in the service container. Parameter name: serviceType


And the call stack is:
at System.ComponentModel.Design.ServiceContainer.AddService(Type serviceType,
ServiceCreatorCallback callback, Boolean promote)
at
System.ComponentModel.Design.ServiceContainer.AddService(Type serviceType,
ServiceCreatorCallback callback)
at
Telerik.Reporting.Design.VisualStudio.DependencyLoader.Initialize(IDesignerHost
host)
at Telerik.Reporting.Design.ReportRootDesigner.LoadDependencies()
at
Telerik.Reporting.Design.ReportRootDesigner.Initialize(IComponent
component)
at
System.ComponentModel.Design.DesignerHost.AddToContainerPostProcess(IComponent
component, String name, IContainer containerToAddTo)
at
System.ComponentModel.Design.DesignerHost.PerformAdd(IComponent component,
String name)
at
System.ComponentModel.Design.DesignerHost.System.ComponentModel.Design.IDesignerHost.CreateComponent(Type
componentType, String name)
at
System.ComponentModel.Design.Serialization.DesignerSerializationManager.CreateInstance(Type
type, ICollection arguments, String name, Boolean addToContainer)
at
System.ComponentModel.Design.Serialization.DesignerSerializationManager.System.ComponentModel.Design.Serialization.IDesignerSerializationManager.CreateInstance(Type
type, ICollection arguments, String name, Boolean addToContainer)
at
System.ComponentModel.Design.Serialization.TypeCodeDomSerializer.Deserialize(IDesignerSerializationManager
manager, CodeTypeDeclaration declaration)
at
System.ComponentModel.Design.Serialization.CodeDomDesignerLoader.PerformLoad(IDesignerSerializationManager
manager)
at
Microsoft.VisualStudio.Design.Serialization.CodeDom.VSCodeDomDesignerLoader.PerformLoad(IDesignerSerializationManager
serializationManager)
at
System.ComponentModel.Design.Serialization.BasicDesignerLoader.BeginLoad(IDesignerLoaderHost
host)


In C#, I had to close the designer and open it again to make it work. In Oxygene (Delphi Prism), I had to close Visual Studio and open it again to make the designer work again; otherwise, it displays a black page with just a rectangle!
It's really a waste of time to work this way

Patrick
IvanY
Telerik team
 answered on 26 Apr 2013
2 answers
1.0K+ views
I have a report designed while using the Demo version of the reporting software.  Upon purchasing/upgrading to the latest Telerik reporting, the report is no longer viewable in the VB.NET design mode.
The screen is filled with over 200 errors like: 'Object of type 'Telerik.Reporting.Drawing.Unit' cannot be converted to type 'Telerik.Reporting.Drawing.Unit'. '  All errors are linked to the designer code.  The program functions correctly, when running, and the 'errors' all show as only warnings when building the solution. The reference in the project is Telerik.Reporting v3.2.9.1211.

The errors all point to a line like the following:
Me.pnlShortTerm.Size = New Telerik.Reporting.Drawing.SizeU(New Telerik.Reporting.Drawing.Unit(7.9998421669006348, Telerik.Reporting.Drawing.UnitType.Inch), New Telerik.Reporting.Drawing.Unit(1.3999999761581421, Telerik.Reporting.Drawing.UnitType.Inch)) 


Is there any way to salvage the report, so that I can modify it using the designer?
Ramazan
Top achievements
Rank 1
 answered on 26 Apr 2013
3 answers
121 views
I have downloaded .trdx file from my web application to client machine
after changes being done from client in trdx i want to save this updated *.trdx on server
is there any way to do it using telerik report designer(standalone)?

Please help me out i am stuck with this.Its requirement of client.
So Please tell me how is it possible using telerik report designer.

Thanks in advance
Unknown
Top achievements
Rank 1
 answered on 25 Apr 2013
1 answer
139 views
Hi.

We have a Silverlight ReportViewer that talks to a WCF Report Service.

This report service looks implements "ApplicationPath" which according to its description should allow relative report file names when the silverlight viewer requests to render a report.

ReportingService : ReportServiceBase, IReportService
{
        private static string _applicationPath = null;
   
        /// <summary>
        /// From <see cref="Telerik.Reporting.ReportServiceBase"/>
        /// When implemented, returns the file system path of the current application's root directory.
        /// It is used to resolve the relative paths of the <see cref="Telerik.Reporting.UriReportSource"/>s.
        /// </summary>
        protected override string ApplicationPath
        {
            get
            {
                if (_applicationPath == null)
                {
                    _applicationPath = XXXX.Helpers.LoadExternal.GetReportsPath(); // This sets a FullName path like C:\ProgramData\OurProgram\Reports
                }
                return _applicationPath;
            }
        }
  
.....
}

Our silverlight reportview uses standard binding to the "Report" attribute

<telerikReporting:ReportViewer ReportServiceClientFactory="{Binding ReportServiceClientFactory}"
                                       ReportServiceUri="{Binding ReportServiceUrl}"
                                       Report="{Binding ReportName}"
                                       Visibility="{Binding ReportVisibility}" />

The report renders correctly when "ReportName" is

  • a fully qualified name that represents a report stored in a loaded dll on the server side
  • "C:\ProgramData\OurApp\Reports\MyReport.trdx" - a fullName file path for a report stored on the server file system

However, if we try to set "ReportName" to a relative path it fails. We have tried

  • MyReport.trdx
  • MyReport
  • ./MyReport.trdx

These produce a rendering error: 
A report can't be created from Barcodes Report.trdx

The "ApplicationPath" does not seem to get called.

I can confirm by calling it manually that the correct path is returned (and ends in a slash char) and that MyReport.trdx exists and it is a valid report at this location.

From Silverlight report viewer how are we meant to specify a relative file path?

We would like to be able to specify only a relative path from Silverlight to not give away the full server path in any server communication.

Is this possible?

Looking at ReportFileResolver code it is not, so do we have to create a custom resolver or is this a possible feature for future versions?

Thanks.

Adrian.
Chavdar
Telerik team
 answered on 25 Apr 2013
2 answers
117 views
Dear team,
I set a font family to a textbox in my report and when it render in my local machine it display the right font but when i run the report in the online website it get different font family and i don't know why.
kindly check the attached snapshots.
Regards,
Mohammed
Mohammed
Top achievements
Rank 2
 answered on 24 Apr 2013
5 answers
551 views
Hi team,
I have a drill through sub report.
when I run it in winform simple form application it work fine but when i run it in webforms i get the below exception i don't know why


Server Error in '/leadslightning' Application.

The method or operation is not implemented.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.NotImplementedException: The method or operation is not implemented.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[NotImplementedException: The method or operation is not implemented.]
   Telerik.Reporting.Html5Rendering.Writers.Svg.SvgPathBuilder.Visit(BezierSegment bezier) +28
   Telerik.Reporting.Processing.Primitives.BezierSegment.Accept(PathSegmentVisitor visitor) +12
   Telerik.Reporting.Processing.Primitives.PathSegmentVisitor.Visit(PathSegment seg) +12
   Telerik.Reporting.Html5Rendering.Writers.Svg.SvgPathBuilder.GetSvgPath(PathGeometry geometry) +304
   Telerik.Reporting.Html5Rendering.Writers.Svg.PrimitivesWriter.Visit(PathGeometry pathGeometry) +637
   Telerik.Reporting.Processing.Primitives.PathGeometry.Accept(PrimitiveElementVisitor visitor) +12
   Telerik.Reporting.Html5Rendering.Writers.Svg.PrimitivesWriter.Write(ICanvas canvas) +78
   Telerik.Reporting.Html5Rendering.Writers.Svg.Canvas.Write(LayoutElement element, ElementPageInfo pageInfo, Padding padding) +521
   Telerik.Reporting.Html5Rendering.Writers.Svg.Graph.Begin(LayoutElement element, ElementPageInfo pageInfo) +1034
   Telerik.Reporting.Html5Rendering.Writers.Report.WriteStartElement(LayoutElement element, ElementPageInfo pageInfo) +49
   Telerik.Reporting.BaseRendering.PageHandler.Telerik.Reporting.Paging.IPageHandler.StartElement(LayoutElement element, ElementPageInfo info) +14
   Telerik.Reporting.Paging.PageStartElement.AddToPage(IPageHandler handler) +19
   Telerik.Reporting.Paging.PageElementLayer.AddToPage(IPageHandler handler) +69
   Telerik.Reporting.Paging.PageElementManager.AddToPage(IPageHandler handler) +34
   Telerik.Reporting.Paging.PageCompositionBase.AddElementsToPage() +31
   Telerik.Reporting.Paging.PageCompositionBase.SendPhysicalPages() +38
   Telerik.Reporting.Paging.PageCompositionBase.OutputPage() +550
   Telerik.Reporting.Paging.PageCompositionBase.CreatePages() +766
   Telerik.Reporting.Paging.PagerBase.Telerik.Reporting.Paging.IPager.CreatePages(IPageHandler handler, Report report) +42
   Telerik.Reporting.BaseRendering.RenderingExtensionBase.Render(Report report, Hashtable renderingContext, Hashtable deviceInfo, CreateStream createStreamCallback, EvaluateHeaderFooterExpressions evalHeaderFooterCallback) +320
   Telerik.Reporting.Processing.ReportProcessor.RenderCore(ExtensionInfo extensionInfo, IList`1 reports, Hashtable deviceInfo, IRenderingContext renderingContext, CreateStream createStreamCallback) +891
   Telerik.Reporting.Processing.ReportProcessor.RenderCore(String format, IList`1 reports, Hashtable deviceInfo, IRenderingContext renderingContext, CreateStream createStreamCallback) +49
   Telerik.ReportViewer.WebForms.ReportPageOperation.RenderReport(String format, IList`1 processingReports, Hashtable deviceInfo, IRenderingContext renderingContext) +85
   Telerik.ReportViewer.WebForms.ReportRenderOperation.PerformOperationOverride() +206
   Telerik.ReportViewer.WebForms.ReportPageOperation.PerformOperationOverride() +88
   Telerik.ReportViewer.WebForms.HandlerOperation.PerformOperation(HttpContext context, ICacheManager cacheManager) +49
   Telerik.ReportViewer.WebForms.BasicHandler.ProcessRequest(HttpContext context) +194
   System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +341
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +69
Peter
Telerik team
 answered on 24 Apr 2013
Top users last month
Rob
Top achievements
Rank 3
Iron
Iron
Iron
Atul
Top achievements
Rank 1
Iron
Iron
Iron
Alexander
Top achievements
Rank 1
Veteran
Iron
Serkan
Top achievements
Rank 1
Iron
Shawn
Top achievements
Rank 1
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?