Telerik Forums
Reporting Forum
3 answers
278 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
67 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
163 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
119 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
179 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
1 answer
112 views

Hi,

 I am trying to display new graph using the Telerik.Reporting.Graph tool on each page of the report. Each page is displaying the grades of a particular student. So how do I get the bar chart to display the correct graph for each student on the page. Currently it is just showing the same graph on every page and the values are not changing according to the student id displayed at the top of every page. 

 (I am using C# in Visual Studio)

 Thanks!

 

Nasko
Telerik team
 answered on 03 Aug 2015
2 answers
116 views

Hi All

 I have a report that uses a subreport to display a series of questions (1-24), just using a detail section (not a table).

Each one of these questions has up to five checkboxes for further options that have been selected.

They each have different labels as well depending on which question it is.

 I have managed to get out the question no on the detail_ItemDataBinding event and the report works fine but..

I want to reference the 5 checkboxes for each particular question, hiding the ones not required and changing the text value for those in use??

 

Cheers

Ade

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

Hello,

 

I create a Report on runtime with ;

 

for (int i = 0; i <= ds.Tables[0].Columns.Count - 1; i++)
            {
                var tableGroupColumn = new TableGroup();
                tableGroupColumn.Name = i.ToString();
                table1.ColumnGroups.Add(item: tableGroupColumn);
 
                txtGroup = new HtmlTextBox
                               {
                                   Size = new SizeU(Unit.Inch(2.1), Unit.Inch(0.3)),
                                   Value = ds.Tables[0].Columns[i].ColumnName,
                                   Style =
                                       {
                                           BackgroundColor = System.Drawing.Color.FromArgb(59,100,141),
                                           Color = System.Drawing.Color.White,
                                           BorderStyle = { Default = BorderType.Solid },
                                           TextAlign = HorizontalAlign.Center,
                                           VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle,
                                           BorderColor = { Default = Color.Black }
                                       },
                                   StyleName = "Corporate.TableHeader",
                               };
                tableGroupColumn.ReportItem = txtGroup;
 
                txtTable = new HtmlTextBox()
                               {
                                   Size = new SizeU(Unit.Inch(2.2), Unit.Inch(0.3)),
                                   Value = "=Fields.[" + ds.Tables[0].Columns[i].ColumnName + "]",
                                   //Value = data.Rows[rowIndex][i].ToString(),
                                   Style =
                                       {
                                           BorderStyle = { Default = BorderType.Solid },
                                           TextAlign = HorizontalAlign.Center,
                                           VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle,
                                           BorderColor = { Default = Color.Black }
                                       },
                                       StyleName = "Corporate.TableHeader",
                               };
 
                table1.Body.SetCellContent(0, columnIndex: i, item: txtTable);
                //rowIndex++;
                table1.Items.AddRange(items: new ReportItemBase[] { txtTable, txtGroup });
            }

and i want to add a Total with sum function but i cant do this.

Nasko
Telerik team
 answered on 03 Aug 2015
4 answers
248 views

Hi Telerik,

 

Recently, we've been experiencing timeouts in our reports, where can we do the configuration of the prolong timeout limit? Can we do it via HTML Viewer, or the Reports API or the Report itself??

Thank you...

Efren
Top achievements
Rank 1
 answered on 03 Aug 2015
Top users last month
Cynthia
Top achievements
Rank 1
Iron
Toby
Top achievements
Rank 3
Iron
Iron
Iron
Danielle
Top achievements
Rank 1
Iron
Iron
Joel
Top achievements
Rank 3
Bronze
Bronze
Iron
yw
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?