Telerik Forums
Reporting Forum
2 answers
690 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
537 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
221 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
145 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
295 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
81 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
175 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
1 answer
130 views

I have my  Report in MVC and displaying the report in IFrame. I have search Fields Parameters and In report I want to use those fields. 

Means my main point to is to send the value from MVC view to  Report Backend code. I think it should be something by setting report parameter. 

But I do not how? I have set for help. 

I need urgent help.

Nasko
Telerik team
 answered on 03 Aug 2015
1 answer
189 views

I am using telerik reporting(Q2014) for my web application:

here is my database tables

setNO           Names                  salary         

1                  Girmay                   5000

1                  Genet                      5000

2                 Kenenisa                   5000

2                 Lemlem                   4000

2                  Abebe                    4000

3              Melat                          6500

3               Haile                           6500

now i want to display this using crosstab telerik, and so that i can avoid repetitions of data. it works for me  likes

setNO  salary   Names

1            5000     ...here namelists

2            4000       here name list

3       65000    here name lists

but i want to make on this order

setno  Names   Price

i cannot add row groups to the right side of the table, it only works on the left side?

could help me please? i new for telerik

Stef
Telerik team
 answered on 03 Aug 2015
Top users last month
Chester
Top achievements
Rank 1
Iron
Simon
Top achievements
Rank 1
Iron
Douglas
Top achievements
Rank 2
Iron
Iron
SUNIL
Top achievements
Rank 3
Iron
Iron
Iron
Marco
Top achievements
Rank 3
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?