Telerik Forums
Reporting Forum
2 answers
218 views

Hi Telerik,



We've been experiencing performance issues on our reports...

Whenever I run a report, just 1 report... The database server CPU spikes up...

from 1% consumption it spikes up to 99%... drastic...



Please see attached file for DB server specs and other screenshots

 

 

Thank you so much.

Stef
Telerik team
 answered on 05 Aug 2015
2 answers
1.1K+ views

Hi,

I need to put some text in the textboxes which is language dependent. So what am I doing is, I have used combination of static text and dynamic text for each language culture. For example

For English : textBox1.Value="Label" + Fields.Name + ", " + Fields.Address

For ​Russian : textBox1.Value="этикетка" + Fields.Name ​+ ", " + Fields.Address

 Till now I have placed the English part(i.e. "Label" + Fields.Name + ", " + Fields.Address) and Russian part(i.e. "этикетка" + Fields.Name ​+ ", " + Fields.Address) in their respective files.

My question is - Can we place just static part of the expression in the Resx files and keep the rest intact (Means placing just "Label" and "этикетка" in the resx files) ?

If yes then How?

Amar
Top achievements
Rank 1
 answered on 05 Aug 2015
2 answers
705 views

Hi,

I am facing a problem in binding the reports data with expressions. I am using the below expression-

=Fields.Name + ", " + Fields.Address + ", " + Fields.PhoneNo

In this, if any part(like Fields.Name) is null then it makes the whole expression to return null and it leaves the line blank on the report. ​I expect it to concatenate the strings and if there is any null value then it should ignore and should give us the rest as the output(Which is the default behaviour of .Net)

 Please suggest if there is any option to change its behaviour of dealing with null values or is there any alternative ?

 

Amar
Top achievements
Rank 1
 answered on 05 Aug 2015
5 answers
542 views

Hello,

I create ReportViewer with report in my code and place it in Panel. In Javascript I start the printing by calling function PrintReport(). Something like that:

ReportViewer viewer = new Telerik.ReportViewer.WebForms.ReportViewer();
InstanceReportSource source = new InstanceReportSource();
source.ReportDocument = book;
viewer.ReportSource = source;
 
Panel retControl = new System.Web.UI.WebControls.Panel();
retControl.Controls.Add(viewer);

 

But I have the problem with the device information settings for rendering in PDF format. I define them in config file and it works fine, but I need to change them for some cases dynamicaly. I find that I can put hashtable with device info into RenderReport, but it looks there are not accessible any render methods in ReportViewer. Is it possible to these property in my program?

Many thanks

 

Stef
Telerik team
 answered on 04 Aug 2015
1 answer
231 views

We have a multi-value parameter in our report. We added interactive sorting to the report by using the work around mentioned in the following post:

http://www.telerik.com/support/kb/reporting/styling-and-formatting-reports/details/how-to-add-interactive-sorting-to-a-table-item-

When we sort any column, the report reloads and the multi value parameter loses the selection. How can we prevent clearing out of the multi-value parameter control? Is there a way to set the value of the multi-value parameter?

 

Stef
Telerik team
 answered on 04 Aug 2015
1 answer
149 views

We are using Firefox 39.0 and Telerik Reporting Q2 2015. we get the following error on loading of report viewer:

TypeError: Argument 8 of StorageEvent.initStorageEvent does not implement interface Storage.

Is there any solution to make reports work in Firefox?

Stef
Telerik team
 answered on 04 Aug 2015
3 answers
306 views

Hi, 

 

i have a cross tab column, but it will invisible depend on the value, what i did is go to column properties and add binding :

Visible=IIF(Value>0, True, False)​

 

after column invisible, another columns did not fill up the space, how can i solve this, thanks.

 

Regards,

bapuy
Top achievements
Rank 1
 answered on 04 Aug 2015
1 answer
1.1K+ views

I'm having what appears to be a common problem, but I can't find a solution using what I'm seeing suggested by others. A report that previously worked in our software is now failing. We can't find any recent changes in source control, other than that there may be some cells that are filled with a null value that used to be guaranteed to be filled with a decimal. But even with that said, I can control to make sure that doesn't happen, and the error still occurs.

So, the issue is that when I click to create my report, it populates with an empty white window that says "Object Reference not set to an instance of an object".

In the output window of VS, the following is the top of the error:

An error has occurred while rendering the report: System.NullReferenceException: Object reference not set to an instance of an object.
   at Telerik.Reporting.Processing.Table.ForEachCell(Action`1 action)
   at Telerik.Reporting.Processing.Table.MeasureDataItemContent(IMeasureContext context, SizeRF availableClientSize)
   at Telerik.Reporting.Processing.DataItem.MeasureContent(IMeasureContext context, SizeRF availableClientSize)
   at Telerik.Reporting.Processing.LayoutElement.MeasureCore(IMeasureContext context, SizeRF availableSize)
   at Telerik.Reporting.Processing.VisualElement.MeasureCore(IMeasureContext context, SizeRF availableSize)
   at Telerik.Reporting.Processing.ProcessingElement.MeasureCore(IMeasureContext context, SizeRF availableSize)
   at Telerik.Reporting.Processing.LayoutElement.Measure(IMeasureContext context, SizeRF availableSize)
   at Telerik.Reporting.Processing.AbsolutePositionLayout.MeasureChildItems(IMeasureContext context, SizeRF availableClientSize)
   at Telerik.Reporting.Processing.AbsolutePositionLayout.MeasureContent(IMeasureContext context, SizeRF availableClientSize)
   at Telerik.Reporting.Processing.ReportSectionBase.MeasureContent(IMeasureContext context, SizeRF availableClientSize)
   at Telerik.Reporting.Processing.LayoutElement.MeasureCore(IMeasureContext context, SizeRF availableSize)
   at Telerik.Reporting.Processing.VisualElement.MeasureCore(IMeasureContext context, SizeRF availableSize)
   at Telerik.Reporting.Processing.ProcessingElement.MeasureCore(IMeasureContext context, SizeRF availableSize)

 

I'll post the designer file:

 

namespace CompanyNameABC.SoftwareNameXYZ.UI.Visuals.Reports
{
    partial class HistoricalQuoteReport
    {
        #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()
        {
            Telerik.Reporting.TableGroup tableGroup1 = new Telerik.Reporting.TableGroup();
            Telerik.Reporting.TableGroup tableGroup2 = new Telerik.Reporting.TableGroup();
            Telerik.Reporting.InstanceReportSource instanceReportSource1 = new Telerik.Reporting.InstanceReportSource();
            System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(HistoricalQuoteReport));
            Telerik.Reporting.Drawing.StyleRule styleRule1 = new Telerik.Reporting.Drawing.StyleRule();
            this.detail = new Telerik.Reporting.DetailSection();
            this.list1 = new Telerik.Reporting.List();
            this.panel1 = new Telerik.Reporting.Panel();
            this.subReport1 = new Telerik.Reporting.SubReport();
            this.pageHeaderSection1 = new Telerik.Reporting.PageHeaderSection();
            this.textBox104 = new Telerik.Reporting.TextBox();
            this.txtAgentInfo = new Telerik.Reporting.TextBox();
            this.pictureBox1 = new Telerik.Reporting.PictureBox();
            this.pictureBox2 = new Telerik.Reporting.PictureBox();
            this.HistoricalQuoteReportData = new Telerik.Reporting.ObjectDataSource();
            this.txtTitle = new Telerik.Reporting.TextBox();
            ((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
            //
            // detail
            //
            this.detail.Height = Telerik.Reporting.Drawing.Unit.Inch(1.2000001668930054D);
            this.detail.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
            this.list1});
            this.detail.Name = "detail";
            //
            // list1
            //
            this.list1.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(Telerik.Reporting.Drawing.Unit.Inch(0.5D)));
            this.list1.Body.Rows.Add(new Telerik.Reporting.TableBodyRow(Telerik.Reporting.Drawing.Unit.Inch(0.3999999463558197D)));
            this.list1.Body.SetCellContent(0, 0, this.panel1);
            tableGroup1.Groupings.Add(new Telerik.Reporting.Grouping(null));
            tableGroup1.Name = "DetailGroup";
            this.list1.ColumnGroups.Add(tableGroup1);
            this.list1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
            this.panel1});
            this.list1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0D));
            this.list1.Name = "list1";
            tableGroup2.Name = "ColumnGroup";
            this.list1.RowGroups.Add(tableGroup2);
            this.list1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.5D), Telerik.Reporting.Drawing.Unit.Inch(0.3999999463558197D));
            this.list1.NeedDataSource += new System.EventHandler(this.list1_NeedDataSource);
            //
            // panel1
            //
            this.panel1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
            this.subReport1});
            this.panel1.Name = "panel1";
            this.panel1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.5D), Telerik.Reporting.Drawing.Unit.Inch(0.3999999463558197D));
            //
            // subReport1
            //
            this.subReport1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0D));
            this.subReport1.Name = "subReport1";
            instanceReportSource1.ReportDocument = null;
            this.subReport1.ReportSource = instanceReportSource1;
            this.subReport1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.40000000596046448D), Telerik.Reporting.Drawing.Unit.Inch(0.3999999463558197D));
            //
            // pageHeaderSection1
            //
            this.pageHeaderSection1.Height = Telerik.Reporting.Drawing.Unit.Inch(0.97011816501617432D);
            this.pageHeaderSection1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
            this.textBox104,
            this.txtAgentInfo,
            this.pictureBox1,
            this.pictureBox2,
            this.txtTitle});
            this.pageHeaderSection1.Name = "pageHeaderSection1";
            //
            // textBox104
            //
            this.textBox104.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(2.5966284275054932D), Telerik.Reporting.Drawing.Unit.Inch(3.9401806134264916E-05D));
            this.textBox104.Name = "textBox104";
            this.textBox104.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(6.8000006675720215D), Telerik.Reporting.Drawing.Unit.Inch(0.15000000596046448D));
            this.textBox104.Style.Font.Bold = true;
            this.textBox104.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(8D);
            this.textBox104.Style.Font.Underline = true;
            this.textBox104.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
            this.textBox104.Value = "Agent Information";
            //
            // txtAgentInfo
            //
            this.txtAgentInfo.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(2.5966284275054932D), Telerik.Reporting.Drawing.Unit.Inch(0.15628939867019653D));
            this.txtAgentInfo.Name = "txtAgentInfo";
            this.txtAgentInfo.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(6.8000006675720215D), Telerik.Reporting.Drawing.Unit.Inch(0.15000002086162567D));
            this.txtAgentInfo.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(8D);
            this.txtAgentInfo.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
            this.txtAgentInfo.Value = "[Agent Info Here]";
            //
            // pictureBox1
            //
            this.pictureBox1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.0028777541592717171D), Telerik.Reporting.Drawing.Unit.Inch(3.9401806134264916E-05D));
            this.pictureBox1.Name = "pictureBox1";
            this.pictureBox1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2.2999999523162842D), Telerik.Reporting.Drawing.Unit.Inch(0.56999999284744263D));
            this.pictureBox1.Style.BackgroundImage.ImageData = ((System.Drawing.Image)(resources.GetObject("pictureBox1.Style.BackgroundImage.ImageData")));
            this.pictureBox1.Style.BackgroundImage.MimeType = "image/png";
            this.pictureBox1.Style.BackgroundImage.Repeat = Telerik.Reporting.Drawing.BackgroundRepeat.NoRepeat;
            //
            // pictureBox2
            //
            this.pictureBox2.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(9.4299612045288086D), Telerik.Reporting.Drawing.Unit.Inch(3.9401806134264916E-05D));
            this.pictureBox2.Name = "pictureBox2";
            this.pictureBox2.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.56999999284744263D), Telerik.Reporting.Drawing.Unit.Inch(0.56999999284744263D));
            this.pictureBox2.Style.BackgroundImage.ImageData = ((System.Drawing.Image)(resources.GetObject("pictureBox2.Style.BackgroundImage.ImageData")));
            this.pictureBox2.Style.BackgroundImage.MimeType = "image/png";
            //
            // HistoricalQuoteReportData
            //
            this.HistoricalQuoteReportData.DataSource = typeof(Silveus.Salestools.UI.Visuals.ViewModels.HistoricalQuoteVM);
            this.HistoricalQuoteReportData.Name = "HistoricalQuoteReportData";
            //
            // txtTitle
            //
            this.txtTitle.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.099999986588954926D), Telerik.Reporting.Drawing.Unit.Inch(0.699999988079071D));
            this.txtTitle.Name = "txtTitle";
            this.txtTitle.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(9.8000001907348633D), Telerik.Reporting.Drawing.Unit.Inch(0.22988177835941315D));
            this.txtTitle.Style.Font.Bold = true;
            this.txtTitle.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(14D);
            this.txtTitle.Style.Font.Underline = true;
            this.txtTitle.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
            this.txtTitle.Value = "[Title]";
            //
            // HistoricalQuoteReport
            //
            this.DataSource = this.HistoricalQuoteReportData;
            this.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
            this.detail,
            this.pageHeaderSection1});
            this.Name = "HistoricalQuoteReport";
            this.PageSettings.Landscape = true;
            this.PageSettings.Margins = new Telerik.Reporting.Drawing.MarginsU(Telerik.Reporting.Drawing.Unit.Inch(0.5D), Telerik.Reporting.Drawing.Unit.Inch(0.5D), Telerik.Reporting.Drawing.Unit.Inch(0.5D), Telerik.Reporting.Drawing.Unit.Inch(0.5D));
            this.PageSettings.PaperKind = System.Drawing.Printing.PaperKind.Letter;
            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(10D);
            ((System.ComponentModel.ISupportInitialize)(this)).EndInit();
 
        }
        #endregion
 
        private Telerik.Reporting.DetailSection detail;
        private Telerik.Reporting.ObjectDataSource HistoricalQuoteReportData;
        private Telerik.Reporting.List list1;
        private Telerik.Reporting.Panel panel1;
        private Telerik.Reporting.SubReport subReport1;
        private Telerik.Reporting.PageHeaderSection pageHeaderSection1;
        private Telerik.Reporting.TextBox textBox104;
        private Telerik.Reporting.TextBox txtAgentInfo;
        private Telerik.Reporting.PictureBox pictureBox1;
        private Telerik.Reporting.PictureBox pictureBox2;
        private Telerik.Reporting.TextBox txtTitle;
    }
}

 If you already can help, that'd be fantastic. If you need to know more, I can explain more. Please help.
I'm using Q3 2013, btw.

Stef
Telerik team
 answered on 03 Aug 2015
1 answer
86 views

Is there a Design Time Toolbar for Telerik Reporting in Visual Studio 2013?

 Thanks

Stef
Telerik team
 answered on 03 Aug 2015
2 answers
181 views
Hi,

I am new to Telerik reporting.  I am using Telerik Q1 2015. I am facing three problem in Telerik reporting

"Target Image.bmp" shows the target report that I want to make in Telerik reporting. (It was made in excel)

1) While exporting to Excel I am not able to export image as shown in "Result Image Excel.bmp"

2) I want to fix the size of detail section to size of 6 items as shown in "Target Image.bmp" but it size reduced when item reduce as shown in "Result Image.bmp"

3) I want watermark image to appear only once in detail section as shown in "Target Image.bmp" but it appear as many time as the quantity of items as shown in "Iteration Image.bmp"

"Report Image.bmp" shows how I made the report. Please help that how can I achieve the report as shown in "Target Image.bmp"
Nasko
Telerik team
 answered on 03 Aug 2015
Top users last month
Marco
Top achievements
Rank 4
Iron
Iron
Iron
Hiba
Top achievements
Rank 1
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
Max
Top achievements
Rank 1
Veteran
Iron
Alina
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?