Hey everyone,

I'm experiencing a problem with Telerik Reporting. First, I desgined all the tables for the Report and added all the static content (like table headers, etc.). Then, I added my data sources. The Problem is: When I drag a field from the Data Explorer and drop it into a table-column, the whole table disappears. When I remove the data source, the table is visible again.

Any ideas on what went wrong?

Thanks,

Simon

 

Hello,

I'm considering to switch from SSRS to Telerik Reporting and I'm testing Clustered Column chart. As datasource I have simple table as this:

BillDate (Date), BillAmount (Money)

 On X axis I have BillDate and I'm showing Sum(BillAmount) as data.

 I set Label step to 7, LabelUnit Days, BaseUnit Auto. It works great for daterange of one or two months, each day has own column of data, label is for seventh column. But When user choses great range for this report, for example from 2015-01-01 to 2015-12-31 then there is too much data, labels ale unreadable. Is it possible to set automatic switch to Month BaseUnit or even Year BaseUnit when there is too much records? Attached are samples of both graphs.

 

Just started out with the reporting tool and have a few questions I can't seem to find.

 1. Is it possible to group by a field's values? Ex. I have a field Fields.Products, and I want to sum the cost of the products that fall under fruits.\

2. Is it possible to specify the order the column group appears in? Ex. meats | fruits | vegetables. I realize I can do ascending/descending but neither of those is what I want.

I have a bubble chart on a report.  The data source lists physicians, issues and counts.  The size of the bubble is based on the Sum(IssuesFound).

Our client base is split between those with only a few issues and those with quite a few.

I am attempting to place a dynamic filter on the chart, so that a points are plotted when there are less than 8 but limit to points with larger bubbles when there are more than 8 bubbles.  At Series > lineSeries2 > SeriesGroup > Filters I entered:

However, the results are that it always shows all items on the chart (the false result of the IIF).
I've added text boxes in the report header to show me the values of Sum(Fields.IssuesFound) and CountDistinct(Fields.AuditIssueId) and they are correct.
I suppose that the IIf is not evaluating properly during the chart rendering.

If I hard code the Values, like =5, the filter works great and only those issues with a count of 5 or more are plotted.
Is it possible to make this dynamic?

Best,
Scott

I would like to present the following use case and ask for suggestions on the best approach we can use in this situation:

My company provides customized reports on demand to our customers.
Customers buy new customized reports on our database. They will be available in the administrative environment of each client on our site. These reports are developed by us and implemented in VBA (Word and Excel). Usually, we develope a stored procedure that will provide data to the report and VBA is used to run the stored procedure and supply data to a spreadsheet or word document. VBA is dealing with a report queue and sending e-mail to customers with these reports attached. This structure has existed for about 12 years and we believe that it is necessary to improve this proccess. The main problem is the VBA instability to the volume of cases, high volume of decentralized code and difficult to maintain (typical procedural code).

We would like to implement improvements that will improve the quality and delivery time of these projects. Especially ensuring stability in the processing of reports and better error handling, among other expectations we have. And I would like to read suggestions and use cases that can assist us in making decisions.

Our doubts and ways we think of tread:
1) Replacement of VBA technology for a modern platform that adds time and quality in the generation of reports, since VBA is quite unstable. Including the SERVER and also SUBMITTED REPORT. We thought of many options: Jasper Reports, Pentaho, Crystal .. and continue research, but still no conclusive results, since I must ensure that the new technology could replace the VBA in everything he does;
2) The creation of stored procedures for data extraction for the report is the same as the best one? Or should we start from for BI tools that can assist in data extraction more efficiently? Something to help us to configure the data extractions easier.

Our plataform:
1. SQL SERVER;
2. Windows machine with VBA runing (control the report queue and proccess/generate reports).

We are open to platform changes. But with respect to use another database management system, it can be a little tricky… as in most cases, I believe.

What do you recommend? What usually employ on your company? Your suggestions will be most welcome!


thank you

hello ,

I want to create a Report with Huge dataset i.e upto millions of records and over 20 columns,

also i have to display Charts on the same report page.

can i do this with telerik reporting and how much time report will take to render ...

pls rply ASAP... 

 

 

HI

Is there have the built-in function to get the filtered data (filtered DataRows) before and after binding :

Binding :

  private void list1_NeedDataSource(object sender, EventArgs e)
  {
    System.Data.DataTable.datatable = dataset.Tables["table1"];
    //
    list1.DataSource = datatable;
    list1.Filters.AddRange(this.Filters);
    ... 
  }

    private void list1_ItemDataBinding(object sender, EventArgs e)
    {
      Telerik.Reporting.Processing.Table list = (Telerik.Reporting.Processing.Table)sender;
      DataTable NewTable = (DataTable)list.DataObject;
      foreach (DataRow LoopRow in NewTable.Rows)
        ... 
    }
 
or I need to filter the datarows by myself then set the list1.DataSource ?

Best regards

Chris
 
 

Hello,
I am using Telerik Reporting for web to create shipping labels and it looks great to print out one label at a time but if I want to print in a different position based on a parameter. I am using Avery label (template number is 5264) and it has 6 (2x3) labels on a sheet. Currently the label is a static design

How can I do it? 

For example,
----------
| A | B |
| C | D |
| E | F |
---------

 I am passing over a parameter to signify where to print the label and how many. For example, I pass over parameter for starting position of 2 and how many to print of 2 then the label should start out in column B and go to C since the user wants to two copies of the label and calculate the page number for example column B would 1 of 2 and then column C would be 2 of 2.

Shipment ID: SM00125486
Starting Position: 3
PageCount: 3 <-- this tells how many to print
Orign_Name: Shipper Test
Orign_Address_1: 1212 Spooky Spooky Avenue
Orign_Address_2: 
Orign_City: Kansas City
Orign_State: MO
Orign_Postal_Code: 64015
Orign_Contact_Name: sender
Orign_Contact_Phone: (123)456-7890
Orign_Est_Date_Time: 03/09/2015 <-- Pickup Date textBox
Reference: 1234PO

Dest_Name: Herman Munson
Dest_Address_1: 1234 main
Dest_Address_2:
Dest_City: beverly hills
Dest_State: CA
Dest_Postal_Code: 90210
Dest_Contact_Name: receiver
Dest_Contact_Phone: (1234)456-7898
Dest_Est_Date_Time: 03/13/15 <-- Est Deliv Date
Reference: 1234PO

Page Number: calculate the first page number and use pagecount parameter

Labels.Designer.cs
namespace ReportLibrary.CommonReports
{
    partial class Labels
    {
        #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.Drawing.FormattingRule formattingRule1 = new Telerik.Reporting.Drawing.FormattingRule();
            Telerik.Reporting.Drawing.FormattingRule formattingRule2 = new Telerik.Reporting.Drawing.FormattingRule();
            Telerik.Reporting.Drawing.FormattingRule formattingRule3 = new Telerik.Reporting.Drawing.FormattingRule();
            Telerik.Reporting.Drawing.FormattingRule formattingRule4 = new Telerik.Reporting.Drawing.FormattingRule();
            Telerik.Reporting.Drawing.FormattingRule formattingRule5 = new Telerik.Reporting.Drawing.FormattingRule();
            Telerik.Reporting.ReportParameter reportParameter1 = new Telerik.Reporting.ReportParameter();
            Telerik.Reporting.ReportParameter reportParameter2 = new Telerik.Reporting.ReportParameter();
            Telerik.Reporting.ReportParameter reportParameter3 = new Telerik.Reporting.ReportParameter();
            Telerik.Reporting.ReportParameter reportParameter4 = new Telerik.Reporting.ReportParameter();
            Telerik.Reporting.Drawing.StyleRule styleRule1 = new Telerik.Reporting.Drawing.StyleRule();
            Telerik.Reporting.Drawing.StyleRule styleRule2 = new Telerik.Reporting.Drawing.StyleRule();
            Telerik.Reporting.Drawing.StyleRule styleRule3 = new Telerik.Reporting.Drawing.StyleRule();
            Telerik.Reporting.Drawing.StyleRule styleRule4 = new Telerik.Reporting.Drawing.StyleRule();
            Telerik.Reporting.Drawing.StyleRule styleRule5 = new Telerik.Reporting.Drawing.StyleRule();
            this.MailingLabels = new Telerik.Reporting.SqlDataSource();
            this.detail = new Telerik.Reporting.DetailSection();
            this.panel1 = new Telerik.Reporting.Panel();
            this.textBox1 = new Telerik.Reporting.TextBox();
            this.textBox2 = new Telerik.Reporting.TextBox();
            this.textBox3 = new Telerik.Reporting.TextBox();
            this.textBox4 = new Telerik.Reporting.TextBox();
            this.textBox5 = new Telerik.Reporting.TextBox();
            this.textBox6 = new Telerik.Reporting.TextBox();
            this.textBox7 = new Telerik.Reporting.TextBox();
            this.lblShipmentId = new Telerik.Reporting.TextBox();
            this.textBox9 = new Telerik.Reporting.TextBox();
            this.textBox10 = new Telerik.Reporting.TextBox();
            this.textBox11 = new Telerik.Reporting.TextBox();
            this.textBox13 = new Telerik.Reporting.TextBox();
            this.textBox14 = new Telerik.Reporting.TextBox();
            this.textBox15 = new Telerik.Reporting.TextBox();
            this.textBox16 = new Telerik.Reporting.TextBox();
            this.textBox17 = new Telerik.Reporting.TextBox();
            this.textBox18 = new Telerik.Reporting.TextBox();
            this.textBox19 = new Telerik.Reporting.TextBox();
            this.shape1 = new Telerik.Reporting.Shape();
            this.textBox20 = new Telerik.Reporting.TextBox();
            this.textBox21 = new Telerik.Reporting.TextBox();
            this.textBox22 = new Telerik.Reporting.TextBox();
            this.textBox23 = new Telerik.Reporting.TextBox();
            this.textBox24 = new Telerik.Reporting.TextBox();
            this.textBox25 = new Telerik.Reporting.TextBox();
            this.textBox26 = new Telerik.Reporting.TextBox();
            this.textBox27 = new Telerik.Reporting.TextBox();
            this.textBox28 = new Telerik.Reporting.TextBox();
            this.textBox29 = new Telerik.Reporting.TextBox();
            this.textBox30 = new Telerik.Reporting.TextBox();
            this.textBox31 = new Telerik.Reporting.TextBox();
            this.lblReportInfo = new Telerik.Reporting.TextBox();
            ((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
            // 
            // MailingLabels
            // 
            this.MailingLabels.ConnectionString = "ReportLibrary.Properties.Settings.RRSmartFreightSolutions";
            this.MailingLabels.Name = "MailingLabels";
            this.MailingLabels.Parameters.AddRange(new Telerik.Reporting.SqlDataSourceParameter[] {
            new Telerik.Reporting.SqlDataSourceParameter("@shipment_id", System.Data.DbType.AnsiString, "= Parameters.shipmentid.Value")});
            this.MailingLabels.SelectCommand = "GetLTLFullLabel";
            this.MailingLabels.SelectCommandType = Telerik.Reporting.SqlDataSourceCommandType.StoredProcedure;
            // 
            // detail
            // 
            this.detail.Height = Telerik.Reporting.Drawing.Unit.Inch(3.3299999237060547D);
            this.detail.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
            this.panel1});
            this.detail.Name = "detail";
            // 
            // panel1
            // 
            this.panel1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
            this.textBox1,
            this.textBox2,
            this.textBox3,
            this.textBox4,
            this.textBox5,
            this.textBox6,
            this.textBox9,
            this.textBox10,
            this.textBox11,
            this.textBox13,
            this.textBox14,
            this.textBox15,
            this.textBox16,
            this.textBox17,
            this.textBox18,
            this.textBox19,
            this.shape1,
            this.textBox20,
            this.textBox21,
            this.textBox22,
            this.textBox23,
            this.textBox24,
            this.textBox25,
            this.textBox26,
            this.textBox27,
            this.textBox28,
            this.textBox29,
            this.textBox30,
            this.textBox31,
            this.textBox7,
            this.lblShipmentId,
            this.lblReportInfo});
            this.panel1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D), Telerik.Reporting.Drawing.Unit.Inch(3.9659440517425537E-05D));
            this.panel1.Name = "panel1";
            this.panel1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(4D), Telerik.Reporting.Drawing.Unit.Inch(3.3299999237060547D));
            // 
            // textBox1
            // 
            this.textBox1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(2.6000003814697266D), Telerik.Reporting.Drawing.Unit.Inch(2.2007901668548584D));
            this.textBox1.Name = "textBox1";
            this.textBox1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.1999603509902954D), Telerik.Reporting.Drawing.Unit.Inch(0.2000788152217865D));
            this.textBox1.Style.Font.Name = "Times New Roman";
            this.textBox1.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
            this.textBox1.Value = "= Fields.DEST_CONTACT_PHONE";
            // 
            // textBox2
            // 
            this.textBox2.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(2.8250792026519775D), Telerik.Reporting.Drawing.Unit.Inch(2.00071120262146D));
            this.textBox2.Name = "textBox2";
            this.textBox2.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.97488147020339966D), Telerik.Reporting.Drawing.Unit.Inch(0.20000004768371582D));
            this.textBox2.Style.Font.Name = "Times New Roman";
            this.textBox2.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
            this.textBox2.Value = "= Fields.DEST_EST_DATE_TIME.Month+\"/\"+ Fields.DEST_EST_DATE_TIME.Day+\"/\"+ Fields." +
    "DEST_EST_DATE_TIME.Year";
            // 
            // textBox3
            // 
            this.textBox3.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(2.699960470199585D), Telerik.Reporting.Drawing.Unit.Inch(0.700158417224884D));
            this.textBox3.Name = "textBox3";
            this.textBox3.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.1000003814697266D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
            this.textBox3.Style.Font.Name = "Times New Roman";
            this.textBox3.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
            this.textBox3.Value = "= Fields.ORIGN_CONTACT_PHONE";
            // 
            // textBox4
            // 
            this.textBox4.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(2.89996075630188D), Telerik.Reporting.Drawing.Unit.Inch(0.5000794529914856D));
            this.textBox4.Name = "textBox4";
            this.textBox4.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.89999991655349731D), Telerik.Reporting.Drawing.Unit.Inch(0.20000004768371582D));
            this.textBox4.Style.Font.Name = "Times New Roman";
            this.textBox4.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
            this.textBox4.Value = "= Fields.ORIGN_EST_DATE_TIME.Month+\"/\"+ Fields.ORIGN_EST_DATE_TIME.Day+\"/\"+ Field" +
    "s.ORIGN_EST_DATE_TIME.Year";
            // 
            // textBox5
            // 
            this.textBox5.CanGrow = true;
            this.textBox5.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(2.9001178741455078D), Telerik.Reporting.Drawing.Unit.Inch(0D));
            this.textBox5.Name = "textBox5";
            this.textBox5.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.90000003576278687D), Telerik.Reporting.Drawing.Unit.Inch(0.25423699617385864D));
            this.textBox5.Style.Font.Name = "Times New Roman";
            this.textBox5.StyleName = "Data";
            this.textBox5.Value = "= Fields.CARPRO";
            // 
            // textBox6
            // 
            this.textBox6.CanGrow = true;
            this.textBox6.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(2.4999606609344482D), Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D));
            this.textBox6.Name = "textBox6";
            this.textBox6.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.40007838606834412D), Telerik.Reporting.Drawing.Unit.Inch(0.25419718027114868D));
            this.textBox6.Style.Font.Name = "Times New Roman";
            this.textBox6.StyleName = "Caption";
            this.textBox6.Value = "Pro:";
            // 
            // textBox7
            // 
            this.textBox7.CanGrow = true;
            this.textBox7.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(1.0792850255966187D), Telerik.Reporting.Drawing.Unit.Inch(0D));
            this.textBox7.Name = "textBox7";
            this.textBox7.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.2186709642410278D), Telerik.Reporting.Drawing.Unit.Inch(0.21670609712600708D));
            this.textBox7.Style.Font.Bold = true;
            this.textBox7.Style.Font.Name = "Times New Roman";
            this.textBox7.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(12D);
            this.textBox7.StyleName = "Data";
            this.textBox7.Value = "= Fields.SHIPMENT_ID";
            // 
            // lblShipmentId
            // 
            this.lblShipmentId.CanGrow = true;
            this.lblShipmentId.CanShrink = true;
            this.lblShipmentId.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D), Telerik.Reporting.Drawing.Unit.Inch(0.012074152939021587D));
            this.lblShipmentId.Name = "lblShipmentId";
            this.lblShipmentId.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.0791667699813843D), Telerik.Reporting.Drawing.Unit.Inch(0.21670594811439514D));
            this.lblShipmentId.Style.Font.Name = "Times New Roman";
            this.lblShipmentId.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(12D);
            this.lblShipmentId.StyleName = "Caption";
            this.lblShipmentId.Value = "Shipment ID:";
            // 
            // textBox9
            // 
            this.textBox9.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.033333778381347656D), Telerik.Reporting.Drawing.Unit.Inch(2.00071120262146D));
            this.textBox9.Name = "textBox9";
            this.textBox9.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.4208335876464844D), Telerik.Reporting.Drawing.Unit.Inch(0.19999973475933075D));
            this.textBox9.Style.Font.Name = "Times New Roman";
            this.textBox9.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
            this.textBox9.Value = "= Fields.DEST_NAME";
            // 
            // textBox10
            // 
            this.textBox10.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.033333778381347656D), Telerik.Reporting.Drawing.Unit.Inch(2.6010255813598633D));
            this.textBox10.Name = "textBox10";
            this.textBox10.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.4208335876464844D), Telerik.Reporting.Drawing.Unit.Inch(0.19976377487182617D));
            this.textBox10.Style.Font.Name = "Times New Roman";
            this.textBox10.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
            this.textBox10.Value = "= Fields.DEST_CITY+\", \"+ Fields.DEST_STATE+\" \"+ Fields.DEST_POSTAL_CODE";
            // 
            // textBox11
            // 
            formattingRule1.Filters.Add(new Telerik.Reporting.Filter("= Fields.DEST_ADDRESS_2", Telerik.Reporting.FilterOperator.Equal, "\"\""));
            formattingRule1.Style.Visible = false;
            this.textBox11.ConditionalFormatting.AddRange(new Telerik.Reporting.Drawing.FormattingRule[] {
            formattingRule1});
            this.textBox11.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.033333778381347656D), Telerik.Reporting.Drawing.Unit.Inch(2.4008684158325195D));
            this.textBox11.Name = "textBox11";
            this.textBox11.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.4208334684371948D), Telerik.Reporting.Drawing.Unit.Inch(0.20007848739624023D));
            this.textBox11.Style.Font.Name = "Times New Roman";
            this.textBox11.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
            this.textBox11.Value = "= Fields.DEST_ADDRESS_2";
            // 
            // textBox13
            // 
            this.textBox13.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.033333778381347656D), Telerik.Reporting.Drawing.Unit.Inch(2.800868034362793D));
            this.textBox13.Name = "textBox13";
            this.textBox13.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.5666269063949585D), Telerik.Reporting.Drawing.Unit.Inch(0.2003941535949707D));
            this.textBox13.Style.Font.Name = "Times New Roman";
            this.textBox13.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
            this.textBox13.Value = "Contact:";
            // 
            // textBox14
            // 
            this.textBox14.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.6375001072883606D), Telerik.Reporting.Drawing.Unit.Inch(2.8008677959442139D));
            this.textBox14.Name = "textBox14";
            this.textBox14.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.5D), Telerik.Reporting.Drawing.Unit.Inch(0.20039448142051697D));
            this.textBox14.Style.Font.Name = "Times New Roman";
            this.textBox14.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
            this.textBox14.Value = "= Fields.DEST_CONTACT_NAME";
            // 
            // textBox15
            // 
            this.textBox15.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.033333778381347656D), Telerik.Reporting.Drawing.Unit.Inch(3.0013411045074463D));
            this.textBox15.Name = "textBox15";
            this.textBox15.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.70208299160003662D), Telerik.Reporting.Drawing.Unit.Inch(0.20000012218952179D));
            this.textBox15.Style.Font.Name = "Times New Roman";
            this.textBox15.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
            this.textBox15.Value = "Reference:";
            // 
            // textBox16
            // 
            this.textBox16.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.73549556732177734D), Telerik.Reporting.Drawing.Unit.Inch(3.0013411045074463D));
            this.textBox16.Name = "textBox16";
            this.textBox16.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.2000001668930054D), Telerik.Reporting.Drawing.Unit.Inch(0.20031547546386719D));
            this.textBox16.Style.Font.Name = "Times New Roman";
            this.textBox16.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
            this.textBox16.Value = "= Fields.PO";
            // 
            // textBox17
            // 
            this.textBox17.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(1.9476817846298218D), Telerik.Reporting.Drawing.Unit.Inch(2.00071120262146D));
            this.textBox17.Name = "textBox17";
            this.textBox17.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.8522789478302002D), Telerik.Reporting.Drawing.Unit.Inch(0.20000004768371582D));
            this.textBox17.Style.Font.Name = "Times New Roman";
            this.textBox17.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
            this.textBox17.Value = "Est Deliv Date:";
            // 
            // textBox18
            // 
            this.textBox18.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(1.9476817846298218D), Telerik.Reporting.Drawing.Unit.Inch(2.2007901668548584D));
            this.textBox18.Name = "textBox18";
            this.textBox18.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.45227915048599243D), Telerik.Reporting.Drawing.Unit.Inch(0.2000788152217865D));
            this.textBox18.Style.Font.Name = "Times New Roman";
            this.textBox18.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
            this.textBox18.Value = "Phone:";
            // 
            // textBox19
            // 
            this.textBox19.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.033333778381347656D), Telerik.Reporting.Drawing.Unit.Inch(1.800632119178772D));
            this.textBox19.Name = "textBox19";
            this.textBox19.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.2000001668930054D), Telerik.Reporting.Drawing.Unit.Inch(0.20000012218952179D));
            this.textBox19.Style.Font.Bold = true;
            this.textBox19.Style.Font.Name = "Times New Roman";
            this.textBox19.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(12D);
            this.textBox19.Value = "CONSIGNEE:";
            // 
            // shape1
            // 
            this.shape1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.033333778381347656D), Telerik.Reporting.Drawing.Unit.Inch(1.700553297996521D));
            this.shape1.Name = "shape1";
            this.shape1.ShapeType = new Telerik.Reporting.Drawing.Shapes.LineShape(Telerik.Reporting.Drawing.Shapes.LineDirection.EW);
            this.shape1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(3.7666268348693848D), Telerik.Reporting.Drawing.Unit.Inch(0.1000000610947609D));
            // 
            // textBox20
            // 
            this.textBox20.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(2.0248820781707764D), Telerik.Reporting.Drawing.Unit.Inch(0.700158417224884D));
            this.textBox20.Name = "textBox20";
            this.textBox20.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.50007849931716919D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
            this.textBox20.Style.Font.Name = "Times New Roman";
            this.textBox20.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
            this.textBox20.Value = "Phone:";
            // 
            // textBox21
            // 
            this.textBox21.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(2.0248820781707764D), Telerik.Reporting.Drawing.Unit.Inch(0.5000794529914856D));
            this.textBox21.Name = "textBox21";
            this.textBox21.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.77507781982421875D), Telerik.Reporting.Drawing.Unit.Inch(0.20000004768371582D));
            this.textBox21.Style.Font.Name = "Times New Roman";
            this.textBox21.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
            this.textBox21.Value = "Pickup Date:";
            // 
            // textBox22
            // 
            this.textBox22.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.837500274181366D), Telerik.Reporting.Drawing.Unit.Inch(1.5004743337631226D));
            this.textBox22.Name = "textBox22";
            this.textBox22.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.2999998331069946D), Telerik.Reporting.Drawing.Unit.Inch(0.20000012218952179D));
            this.textBox22.Style.Font.Name = "Times New Roman";
            this.textBox22.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
            this.textBox22.Value = "= Fields.PO";
            // 
            // textBox23
            // 
            this.textBox23.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.15625016391277313D), Telerik.Reporting.Drawing.Unit.Inch(1.5004743337631226D));
            this.textBox23.Name = "textBox23";
            this.textBox23.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.6437104344367981D), Telerik.Reporting.Drawing.Unit.Inch(0.20000012218952179D));
            this.textBox23.Style.Font.Name = "Times New Roman";
            this.textBox23.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
            this.textBox23.Value = "Reference:";
            // 
            // textBox24
            // 
            this.textBox24.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.735495388507843D), Telerik.Reporting.Drawing.Unit.Inch(1.3003953695297241D));
            this.textBox24.Name = "textBox24";
            this.textBox24.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.5D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
            this.textBox24.Style.Font.Name = "Times New Roman";
            this.textBox24.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
            this.textBox24.Value = "= Fields.ORIGN_CONTACT_NAME";
            // 
            // textBox25
            // 
            this.textBox25.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.1354166716337204D), Telerik.Reporting.Drawing.Unit.Inch(1.3003953695297241D));
            this.textBox25.Name = "textBox25";
            this.textBox25.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.60000008344650269D), Telerik.Reporting.Drawing.Unit.Inch(0.19960515201091766D));
            this.textBox25.Style.Font.Name = "Times New Roman";
            this.textBox25.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
            this.textBox25.Value = "Contact:";
            // 
            // textBox26
            // 
            this.textBox26.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.13541650772094727D), Telerik.Reporting.Drawing.Unit.Inch(1.1003164052963257D));
            this.textBox26.Name = "textBox26";
            this.textBox26.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.8000000715255737D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
            this.textBox26.Style.Font.Name = "Times New Roman";
            this.textBox26.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
            this.textBox26.Value = "= Fields.ORIGN_CITY+\", \"+ Fields.ORIGN_STATE+\" \"+ Fields.ORIGN_POSTAL_CODE";
            // 
            // textBox27
            // 
            formattingRule2.Filters.Add(new Telerik.Reporting.Filter("= Fields.ORIGN_ADDRESS_2", Telerik.Reporting.FilterOperator.Equal, "\"\""));
            formattingRule2.Style.Visible = false;
            this.textBox27.ConditionalFormatting.AddRange(new Telerik.Reporting.Drawing.FormattingRule[] {
            formattingRule2});
            this.textBox27.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.13742129504680634D), Telerik.Reporting.Drawing.Unit.Inch(0.90023738145828247D));
            this.textBox27.Name = "textBox27";
            this.textBox27.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.4000000953674316D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
            this.textBox27.Style.Font.Name = "Times New Roman";
            this.textBox27.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
            this.textBox27.Value = "= Fields.ORIGN_ADDRESS_2";
            // 
            // textBox28
            // 
            this.textBox28.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.13541650772094727D), Telerik.Reporting.Drawing.Unit.Inch(0.700158417224884D));
            this.textBox28.Name = "textBox28";
            this.textBox28.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.4000000953674316D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
            this.textBox28.Style.Font.Name = "Times New Roman";
            this.textBox28.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
            this.textBox28.Value = "= Fields.ORIGN_ADDRESS_1";
            // 
            // textBox29
            // 
            this.textBox29.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.1354166716337204D), Telerik.Reporting.Drawing.Unit.Inch(0.5000794529914856D));
            this.textBox29.Name = "textBox29";
            this.textBox29.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.3999999761581421D), Telerik.Reporting.Drawing.Unit.Inch(0.20000004768371582D));
            this.textBox29.Style.Font.Name = "Times New Roman";
            this.textBox29.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
            this.textBox29.Value = "= Fields.ORIGN_NAME";
            // 
            // textBox30
            // 
            this.textBox30.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.033333778381347656D), Telerik.Reporting.Drawing.Unit.Inch(0.30000051856040955D));
            this.textBox30.Name = "textBox30";
            this.textBox30.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.2000001668930054D), Telerik.Reporting.Drawing.Unit.Inch(0.20000004768371582D));
            this.textBox30.Style.Font.Bold = true;
            this.textBox30.Style.Font.Name = "Times New Roman";
            this.textBox30.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(12D);
            this.textBox30.Value = "SHIPPER:";
            // 
            // textBox31
            // 
            this.textBox31.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.033333778381347656D), Telerik.Reporting.Drawing.Unit.Inch(2.2007896900177D));
            this.textBox31.Name = "textBox31";
            this.textBox31.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.4208335876464844D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
            this.textBox31.Style.Font.Name = "Times New Roman";
            this.textBox31.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
            this.textBox31.Value = "= Fields.DEST_ADDRESS_1";
            // 
            // lblReportInfo
            // 
            this.lblReportInfo.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(2.2999608516693115D), Telerik.Reporting.Drawing.Unit.Inch(3.0013411045074463D));
            this.lblReportInfo.Name = "lblReportInfo";
            this.lblReportInfo.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.5D), Telerik.Reporting.Drawing.Unit.Inch(0.2995656430721283D));
            this.lblReportInfo.Style.Font.Bold = true;
            this.lblReportInfo.Style.Font.Name = "Times New Roman";
            this.lblReportInfo.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(12D);
            this.lblReportInfo.Value = "=Parameters.CurPage.Value+\" of \"+ Parameters.PageCount.Value";
            // 
            // Labels
            // 
            formattingRule3.Filters.Add(new Telerik.Reporting.Filter("= Parameters.StartingPosition.Value", Telerik.Reporting.FilterOperator.Equal, "1"));
            formattingRule3.Style.Font.Name = "Times New Roman";
            formattingRule3.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Inch(0D);
            formattingRule3.Style.Padding.Top = Telerik.Reporting.Drawing.Unit.Inch(0D);
            formattingRule4.Filters.Add(new Telerik.Reporting.Filter("= Parameters.StartingPosition.Value", Telerik.Reporting.FilterOperator.Equal, "2"));
            formattingRule4.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Inch(0D);
            formattingRule4.Style.Padding.Top = Telerik.Reporting.Drawing.Unit.Inch(0D);
            formattingRule5.Filters.Add(new Telerik.Reporting.Filter("= Parameters.StartingPosition.Value", Telerik.Reporting.FilterOperator.Equal, "3"));
            formattingRule5.Style.Padding.Bottom = Telerik.Reporting.Drawing.Unit.Inch(0D);
            formattingRule5.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Inch(0D);
            formattingRule5.Style.Padding.Right = Telerik.Reporting.Drawing.Unit.Inch(0D);
            formattingRule5.Style.Padding.Top = Telerik.Reporting.Drawing.Unit.Inch(0D);
            this.ConditionalFormatting.AddRange(new Telerik.Reporting.Drawing.FormattingRule[] {
            formattingRule3,
            formattingRule4,
            formattingRule5});
            this.DataSource = this.MailingLabels;
            this.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
            this.detail});
            this.Name = "Detail";
            this.PageSettings.ColumnCount = 2;
            this.PageSettings.ColumnSpacing = Telerik.Reporting.Drawing.Unit.Inch(0D);
            this.PageSettings.Landscape = false;
            this.PageSettings.Margins = new Telerik.Reporting.Drawing.MarginsU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0.64999997615814209D), Telerik.Reporting.Drawing.Unit.Inch(0D));
            this.PageSettings.PaperKind = System.Drawing.Printing.PaperKind.Letter;
            reportParameter1.Name = "shipmentid";
            reportParameter1.Value = "SM00125468";
            reportParameter2.Name = "StartingPosition";
            reportParameter2.Type = Telerik.Reporting.ReportParameterType.Integer;
            reportParameter2.Value = "3";
            reportParameter3.Name = "PageCount";
            reportParameter3.Type = Telerik.Reporting.ReportParameterType.Integer;
            reportParameter4.Name = "CurPage";
            reportParameter4.Type = Telerik.Reporting.ReportParameterType.Integer;
            this.ReportParameters.Add(reportParameter1);
            this.ReportParameters.Add(reportParameter2);
            this.ReportParameters.Add(reportParameter3);
            this.ReportParameters.Add(reportParameter4);
            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);
            styleRule2.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
            new Telerik.Reporting.Drawing.StyleSelector("Title")});
            styleRule2.Style.Color = System.Drawing.Color.Black;
            styleRule2.Style.Font.Bold = true;
            styleRule2.Style.Font.Italic = false;
            styleRule2.Style.Font.Name = "Tahoma";
            styleRule2.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(18D);
            styleRule2.Style.Font.Strikeout = false;
            styleRule2.Style.Font.Underline = false;
            styleRule3.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
            new Telerik.Reporting.Drawing.StyleSelector("Caption")});
            styleRule3.Style.Color = System.Drawing.Color.Black;
            styleRule3.Style.Font.Name = "Tahoma";
            styleRule3.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(10D);
            styleRule3.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
            styleRule4.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
            new Telerik.Reporting.Drawing.StyleSelector("Data")});
            styleRule4.Style.Font.Name = "Tahoma";
            styleRule4.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
            styleRule4.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
            styleRule5.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
            new Telerik.Reporting.Drawing.StyleSelector("PageInfo")});
            styleRule5.Style.Font.Name = "Tahoma";
            styleRule5.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(8D);
            styleRule5.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
            this.StyleSheet.AddRange(new Telerik.Reporting.Drawing.StyleRule[] {
            styleRule1,
            styleRule2,
            styleRule3,
            styleRule4,
            styleRule5});
            this.Width = Telerik.Reporting.Drawing.Unit.Inch(4D);
            ((System.ComponentModel.ISupportInitialize)(this)).EndInit();

        }
        #endregion

        private Telerik.Reporting.SqlDataSource MailingLabels;
        private Telerik.Reporting.DetailSection detail;
        private Telerik.Reporting.Panel panel1;
        private Telerik.Reporting.TextBox textBox1;
        private Telerik.Reporting.TextBox textBox2;
        private Telerik.Reporting.TextBox textBox3;
        private Telerik.Reporting.TextBox textBox4;
        private Telerik.Reporting.TextBox textBox5;
        private Telerik.Reporting.TextBox textBox6;
        private Telerik.Reporting.TextBox textBox7;
        private Telerik.Reporting.TextBox lblShipmentId;
        private Telerik.Reporting.TextBox textBox9;
        private Telerik.Reporting.TextBox textBox10;
        private Telerik.Reporting.TextBox textBox11;
        private Telerik.Reporting.TextBox textBox13;
        private Telerik.Reporting.TextBox textBox14;
        private Telerik.Reporting.TextBox textBox15;
        private Telerik.Reporting.TextBox textBox16;
        private Telerik.Reporting.TextBox textBox17;
        private Telerik.Reporting.TextBox textBox18;
        private Telerik.Reporting.TextBox textBox19;
        private Telerik.Reporting.Shape shape1;
        private Telerik.Reporting.TextBox textBox20;
        private Telerik.Reporting.TextBox textBox21;
        private Telerik.Reporting.TextBox textBox22;
        private Telerik.Reporting.TextBox textBox23;
        private Telerik.Reporting.TextBox textBox24;
        private Telerik.Reporting.TextBox textBox25;
        private Telerik.Reporting.TextBox textBox26;
        private Telerik.Reporting.TextBox textBox27;
        private Telerik.Reporting.TextBox textBox28;
        private Telerik.Reporting.TextBox textBox29;
        private Telerik.Reporting.TextBox textBox30;
        private Telerik.Reporting.TextBox textBox31;
        private Telerik.Reporting.TextBox lblReportInfo;

    }
}

 

Thanks

I'm using: Report Designer Q3 2014 and I can not get run a report that I need to export a report directly to PDF, without the need to go through the web viewer. I'm in a WEB .NET (C#) application and all the examples does not run for one reason or other!!.

I need to pass three parameters to the report and I can not find a usefull example. I already see the article: "Exporting a report to PDF programmatically" but still not function.

For example I've used this code:

Telerik.Reporting.Processing.ReportProcessor reportProcessor =
    new Telerik.Reporting.Processing.ReportProcessor();
// set any deviceInfo settings if necessary
System.Collections.Hashtable deviceInfo =
    new System.Collections.Hashtable();
Telerik.Reporting.TypeReportSource typeReportSource =
             new Telerik.Reporting.TypeReportSource();
// reportName is the Assembly Qualified Name of the report
typeReportSource.TypeName = reportName;
Telerik.Reporting.Processing.RenderingResult result =
    reportProcessor.RenderReport("PDF", typeReportSource, deviceInfo);
string fileName = result.DocumentName + "." + result.Extension;
string path = System.IO.Path.GetTempPath();
string filePath = System.IO.Path.Combine(path, fileName);
using (System.IO.FileStream fs = new System.IO.FileStream(filePath, System.IO.FileMode.Create))
{
    fs.Write(result.DocumentBytes, 0, result.DocumentBytes.Length);
}

 

And in this case shows the next error:

Line 88: Telerik.Reporting.Processing.RenderingResult result = Line 89:                 reportProcessor.RenderReport("PDF", typeReportSource, deviceInfo);

Looks like is NULL de "deviceInfo"....

 

Please help!...any help would be appreciated

David

Do I need to buy Report Server in order to use the "interactivity" feature in Report Designer?