I followed the wizzard and made no changes to the report layout besides what the wizzard did and when I export to Excel there are two extra blank rows between every row of data.  What is causing this?

The report has a labels group header and detail...

Hello,
I am using sub-reports. I have a report containing two sub-report. Each sub report points to different business data object. 
In the sub-reports how can we arrange data so that it makes more sense?
In the report you can see the data appears mixed, please refer attachment.
First nine columns are from (Column A to J) subreport1 and last four columns  (Column K to N) are from subreport2.
Can we do some arrangements so that the data is separated as per red markings?
I want data item 2 to start in subrepor1 after we are finished displaying data for data item 1 in subreport2. 
Please advice.
Regards,
Sandeep

Hi,
I'm trying to generate a labeling report form which contains several text boxes, a bar-code section and quantity.
What I would like to do is that setting up a column and create a loop to iterate the column as much an exact number the quantity values.
(FYI : the column has a two sided labels.)

I think, all I need to do is create a loop only in Detail section/OR create a loop WITH Detail section.
So, I generated a form and put all boxes and a barcode in the detail section.
I wrote a code behind by using method; ReportItemBase[] ItemCollection in C#

http://www.telerik.com/community/forums/reporting/telerik-reporting/loop-through-all-controls.aspx

Unfortunately, I can not create a loop to iterate the column as much an exact number of the quantity values.

Change settings, conditional formatting and code behind
Any concerns and comments would be appreciated it.

Sincerely,
H

Hi

I am trying to build a report programmatically. In this report I try to add a textbox on PageHeader.
But the report is still empty. 

I search solution in forum, but I didn't see someone needing help to this problem.

This is a part of what I did, it might be something wrong, I dont know.


Please, can you help me, thanks in advance

Paul S.

Hi

I'm trying to set a background image on a bubble chart, but I haven't managed to get it to appear. It works fine if I set a background on the overall graph, but not on the plotareastyle.

The code generated from the designer is below, any idea where I'm going wrong.

Another quick question, I'm trying to use a background image instead of Marked Zones, as these don't seem to be supported on the Graph object - are they hiding on the Graph object under another name anywhere?

Thanks

---

namespace ReportTest
{
partial class Report1
{
#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.GraphGroup graphGroup1 = new Telerik.Reporting.GraphGroup();
Telerik.Reporting.GraphGroup graphGroup4 = new Telerik.Reporting.GraphGroup();
Telerik.Reporting.GraphTitle graphTitle1 = new Telerik.Reporting.GraphTitle();
Telerik.Reporting.NumericalScale numericalScale1 = new Telerik.Reporting.NumericalScale();
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Report1));
Telerik.Reporting.NumericalScale numericalScale2 = new Telerik.Reporting.NumericalScale();
Telerik.Reporting.DataColumn dataColumn1 = new Telerik.Reporting.DataColumn();
Telerik.Reporting.DataColumn dataColumn2 = new Telerik.Reporting.DataColumn();
Telerik.Reporting.DataColumn dataColumn3 = new Telerik.Reporting.DataColumn();
Telerik.Reporting.DataColumn dataColumn4 = new Telerik.Reporting.DataColumn();
Telerik.Reporting.GraphGroup graphGroup2 = new Telerik.Reporting.GraphGroup();
Telerik.Reporting.GraphGroup graphGroup3 = new Telerik.Reporting.GraphGroup();
Telerik.Reporting.Drawing.StyleRule styleRule1 = new Telerik.Reporting.Drawing.StyleRule();
this.detailSection1 = new Telerik.Reporting.DetailSection();
this.graph1 = new Telerik.Reporting.Graph();
this.cartesianCoordinateSystem1 = new Telerik.Reporting.CartesianCoordinateSystem();
this.graphAxis1 = new Telerik.Reporting.GraphAxis();
this.graphAxis2 = new Telerik.Reporting.GraphAxis();
this.csvDataSource1 = new Telerik.Reporting.CsvDataSource();
this.lineSeries1 = new Telerik.Reporting.LineSeries();
((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
//
// detailSection1
//
this.detailSection1.Height = Telerik.Reporting.Drawing.Unit.Cm(11.795207977294922D);
this.detailSection1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
this.graph1});
this.detailSection1.Name = "detailSection1";
//
// graph1
//
graphGroup1.Name = "seriesGroup";
this.graph1.CategoryGroups.Add(graphGroup1);
this.graph1.CoordinateSystems.Add(this.cartesianCoordinateSystem1);
this.graph1.DataSource = this.csvDataSource1;
this.graph1.Docking = Telerik.Reporting.DockingStyle.Fill;
this.graph1.Legend.Style.LineColor = System.Drawing.Color.LightGray;
this.graph1.Legend.Style.LineWidth = Telerik.Reporting.Drawing.Unit.Cm(0D);
this.graph1.Legend.Style.Visible = false;
this.graph1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Cm(0D), Telerik.Reporting.Drawing.Unit.Cm(0D));
this.graph1.Name = "graph1";
this.graph1.PlotAreaStyle.BackgroundImage.ImageData = ((System.Drawing.Image)(resources.GetObject("graph1.PlotAreaStyle.BackgroundImage.ImageData")));
this.graph1.PlotAreaStyle.BackgroundImage.MimeType = "image/png";
this.graph1.PlotAreaStyle.BackgroundImage.Repeat = ((Telerik.Reporting.Drawing.BackgroundRepeat)((Telerik.Reporting.Drawing.BackgroundRepeat.RepeatX | Telerik.Reporting.Drawing.BackgroundRepeat.RepeatY)));
this.graph1.PlotAreaStyle.LineColor = System.Drawing.Color.LightGray;
this.graph1.PlotAreaStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Cm(0D);
this.graph1.PlotAreaStyle.Visible = true;
this.graph1.Series.Add(this.lineSeries1);
graphGroup4.Groupings.Add(new Telerik.Reporting.Grouping("=Fields.Label"));
graphGroup4.Name = "labelGroup";
graphGroup4.Sortings.Add(new Telerik.Reporting.Sorting("=Fields.Label", Telerik.Reporting.SortDirection.Asc));
this.graph1.SeriesGroups.Add(graphGroup4);
this.graph1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Cm(17.799999237060547D), Telerik.Reporting.Drawing.Unit.Cm(11.795207977294922D));
this.graph1.Style.BackgroundImage.MimeType = "image/png";
this.graph1.Style.Padding.Bottom = Telerik.Reporting.Drawing.Unit.Pixel(10D);
this.graph1.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Pixel(10D);
this.graph1.Style.Padding.Right = Telerik.Reporting.Drawing.Unit.Pixel(10D);
this.graph1.Style.Padding.Top = Telerik.Reporting.Drawing.Unit.Pixel(10D);
graphTitle1.Position = Telerik.Reporting.GraphItemPosition.TopCenter;
graphTitle1.Style.LineColor = System.Drawing.Color.LightGray;
graphTitle1.Style.LineWidth = Telerik.Reporting.Drawing.Unit.Cm(0D);
graphTitle1.Text = "October 2014";
this.graph1.Titles.Add(graphTitle1);
//
// cartesianCoordinateSystem1
//
this.cartesianCoordinateSystem1.Name = "cartesianCoordinateSystem1";
this.cartesianCoordinateSystem1.XAxis = this.graphAxis1;
this.cartesianCoordinateSystem1.YAxis = this.graphAxis2;
//
// graphAxis1
//
this.graphAxis1.MajorGridLineStyle.LineColor = System.Drawing.Color.LightGray;
this.graphAxis1.MajorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
this.graphAxis1.MinorGridLineStyle.LineColor = System.Drawing.Color.LightGray;
this.graphAxis1.MinorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
this.graphAxis1.MinorGridLineStyle.Visible = false;
this.graphAxis1.Name = "graphAxis1";
numericalScale1.Maximum = 10D;
numericalScale1.Minimum = 0D;
this.graphAxis1.Scale = numericalScale1;
this.graphAxis1.Title = "X - Label";
//
// graphAxis2
//
this.graphAxis2.MajorGridLineStyle.LineColor = System.Drawing.Color.LightGray;
this.graphAxis2.MajorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
this.graphAxis2.MajorGridLineStyle.Visible = true;
this.graphAxis2.MinorGridLineStyle.LineColor = System.Drawing.Color.LightGray;
this.graphAxis2.MinorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
this.graphAxis2.MinorGridLineStyle.Visible = false;
this.graphAxis2.Name = "graphAxis2";
numericalScale2.Maximum = 10D;
numericalScale2.Minimum = 0D;
this.graphAxis2.Scale = numericalScale2;
this.graphAxis2.Title = "Y - Label";
//
// csvDataSource1
//
dataColumn1.Name = "A";
dataColumn1.Type = Telerik.Reporting.SimpleType.Integer;
dataColumn2.Name = "B";
dataColumn2.Type = Telerik.Reporting.SimpleType.Integer;
dataColumn3.Name = "C";
dataColumn3.Type = Telerik.Reporting.SimpleType.Integer;
dataColumn4.Name = "Label";
this.csvDataSource1.Columns.Add(dataColumn1);
this.csvDataSource1.Columns.Add(dataColumn2);
this.csvDataSource1.Columns.Add(dataColumn3);
this.csvDataSource1.Columns.Add(dataColumn4);
this.csvDataSource1.FieldSeparators = new char[] {
','};
this.csvDataSource1.HasHeaders = true;
this.csvDataSource1.Name = "csvDataSource1";
this.csvDataSource1.RecordSeparators = new char[] {
'\r',
'\n'};
this.csvDataSource1.Source = "A,B,C,Label\r\n1,2,3,Item One\r\n2,3,5,Item Two\r\n5,4,9,Item Three\r\n8,6,14,Item Four";
//
// lineSeries1
//
graphGroup2.Name = "seriesGroup";
this.lineSeries1.CategoryGroup = graphGroup2;
this.lineSeries1.CoordinateSystem = this.cartesianCoordinateSystem1;
this.lineSeries1.DataPointLabel = "=Fields.Label + \",\" + Sum(Fields.C)";
this.lineSeries1.DataPointLabelStyle.Visible = true;
this.lineSeries1.DataPointStyle.Visible = true;
this.lineSeries1.LegendItem.Value = "C";
this.lineSeries1.LineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
this.lineSeries1.LineStyle.Visible = false;
this.lineSeries1.MarkerMaxSize = Telerik.Reporting.Drawing.Unit.Pixel(50D);
this.lineSeries1.MarkerMinSize = Telerik.Reporting.Drawing.Unit.Pixel(5D);
this.lineSeries1.MarkerSize = Telerik.Reporting.Drawing.Unit.Pixel(5D);
this.lineSeries1.MarkerType = Telerik.Reporting.DataPointMarkerType.Circle;
this.lineSeries1.Name = "lineSeries1";
graphGroup3.Groupings.Add(new Telerik.Reporting.Grouping("=Fields.Label"));
graphGroup3.Name = "labelGroup";
graphGroup3.Sortings.Add(new Telerik.Reporting.Sorting("=Fields.Label", Telerik.Reporting.SortDirection.Asc));
this.lineSeries1.SeriesGroup = graphGroup3;
this.lineSeries1.Size = "=Sum(Fields.C)";
this.lineSeries1.X = "=Sum(Fields.A)";
this.lineSeries1.Y = "=Sum(Fields.B)";
//
// Report1
//
this.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
this.detailSection1});
this.Name = "Report1";
this.PageSettings.Margins = new Telerik.Reporting.Drawing.MarginsU(Telerik.Reporting.Drawing.Unit.Mm(25.399999618530273D), Telerik.Reporting.Drawing.Unit.Mm(25.399999618530273D), Telerik.Reporting.Drawing.Unit.Mm(25.399999618530273D), Telerik.Reporting.Drawing.Unit.Mm(25.399999618530273D));
this.PageSettings.PaperKind = System.Drawing.Printing.PaperKind.A4;
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.Cm(17.799999237060547D);
((System.ComponentModel.ISupportInitialize)(this)).EndInit();

}
#endregion

private Telerik.Reporting.DetailSection detailSection1;
private Telerik.Reporting.Graph graph1;
private Telerik.Reporting.CartesianCoordinateSystem cartesianCoordinateSystem1;
private Telerik.Reporting.GraphAxis graphAxis1;
private Telerik.Reporting.GraphAxis graphAxis2;
private Telerik.Reporting.CsvDataSource csvDataSource1;
private Telerik.Reporting.LineSeries lineSeries1;

}
}

Hello

i follow this sample to create a report multi column.

http://www.telerik.com/help/reporting/advanced-creating-multi-column-reports.html


But i have the column on top to bottom , not the left to right,
i try with 2 columns or 3 Columns or 4 , it's the same,

What is the good way to get a good report multi column ? like this

http://demos.telerik.com/reporting/product-tags/demo.aspx

thanks for your help

Hi,

I am using HTML 5 report viewer in my web site which has a fixed width of 1024px. I want my reports to occupy full width of the report viewer and fits on to an A4 sheet when printing.

 I have adjusted the columns to fit an A4 sheet but this makes the report to only take half of the report viewer width. How can manage both layouts?

Using Telerik.Reporting, Version=8.1.14.804.
Visual Studio solution in C# with report designer.
Data from database returns column 'Field1' of SQL type REAL.
Textbox on report with expression : 
= Abs(Fields.Field1)

In preview a red exception box is shown with message : 'Specified cast is not valid.'

As a workaround we now have:

= Abs(CDbl(Fields.Field1))

Should it work with a real (Single in C#?) from the database? Or are we doing something wrong?

I am building a report which is going to be used as a sub-report from within several other master reports.  The sub-report is pretty simple: one Table in the details section bound to a data source displaying a bunch of records, and a few header rows displaying column headers.  I want to include a header which displays some information about the records on the page such as 'Records #1 through #20" on page 1 and "Records #21 through #40" on page 2, etc.  This seems like the perfect application for the 'PageExec' function, however since I am using this as a sub-report anything in the Page Header and Footer will not be displayed.  Is there a way to do such a header value on each page of a sub-report?

I also tried looking into using the 'RunningValue' function but was unable to figure out a 'scope' value which would allow me to do such a thing.  Is it possible via some other method?

Hi! I am new to telerik reporting and creating simple report using stored procedure which takes one parameter. I am designing my report in standalone report designer using sqldatasource and using generated .trdx file in my ASP.Net MVC application in VS 2012. I already tried to create simple report using sql query/ stored procedure without parameter as shown in your article, this works great but when I am trying to use stored procedure with parameter it's not working. Report content like header and other static information is displaying in report but data coming from stored procedure is not displaying. There is no issue in Stored Procedure as I checked it's working in Sql server. I am using following code to pass parameter

@{
        var DataSource = new UriReportSource() { Uri = ViewBag.TemplateName };
       DataSource.Parameters.Add(new Telerik.Reporting.Parameter("SiteID", 1));        
    }

    @(Html.TelerikReporting().ReportViewer()    
       .Id("reportViewer1")
       .ServiceUrl("/api/reports/")
       .TemplateUrl("/ReportViewer/templates/telerikReportViewerTemplate-8.1.14.804.html")
       .ReportSource(DataSource)
       .ViewMode(ViewModes.INTERACTIVE)
       .ScaleMode(ScaleModes.SPECIFIC)
       .Scale(1.0)
       .PersistSession(false)
       ) 

This is working code and works with sql query/stored procedure without parameter but not working when I use stored procedure with parameter. 

Thanks......