Telerik Forums
Reporting Forum
3 answers
222 views

For redering manually to PDF it is relatve stright forward, as the code below

ReportProcessor.Render("HTML", aContactRPT, Nothing, mime, extension, encode)

however, what rendering Format for Web Archive (mhtml)?
and how about others?

Chavdar
Telerik team
 answered on 30 May 2008
1 answer
168 views
Hello

I've tried to put several charts on the report and bind programmatically them.  So, the first chart at the header of report binds fine, but other in report body binds to first chart.

private void chart1_NeedDataSource(object sender, System.EventArgs e)

        {

            Telerik.Reporting.Processing.Chart chart = (Telerik.Reporting.Processing.Chart)sender;

            try

            {

                string sql = "select COUNT(*) as Marks_Count, MARK_NAME, Custom_Name from v_marks GROUP BY MARK_NAME, Custom_Name";

                SqlCommand sqlComm = new SqlCommand(sql, new SqlConnection(ConfigurationManager.ConnectionStrings["reportConnectionString"].ConnectionString));

                SqlDataAdapter da = new SqlDataAdapter(sqlComm);

                DataTable dt = new DataTable();

                da.Fill(dt);

                chart1.Series[0].DataLabelsColumn = "Mark_Name";

                chart.DataSource = dt;

            }

            catch (System.Exception ex)

            { System.Diagnostics.Debug.WriteLine( ex.Message); }         

        }

        private void chart2_NeedDataSource(object sender, System.EventArgs e)

        {

            Telerik.Reporting.Processing.Chart chart = (Telerik.Reporting.Processing.Chart)sender;

            try

            {

                string sCustomName = ((DataRowView)chart.DataItem)["Custom_Name"] as string;

                if (!string.IsNullOrEmpty(sCustomName))

                {

                    string sql = string.Format("select COUNT(*) as Marks_Count, MARK_NAME from v_marks WHERE Custom_Name='{0}' GROUP BY MARK_NAME", sCustomName);

                    SqlCommand sqlComm = new SqlCommand(sql, new SqlConnection(ConfigurationManager.ConnectionStrings["reportConnectionString"].ConnectionString));

                    SqlDataAdapter da = new SqlDataAdapter(sqlComm);

                    DataTable dt = new DataTable();

                    da.Fill(dt);

                    chart2.Series[0].DataLabelsColumn = "Mark_Name";

                    chart.DataSource = dt;

                }

            }

            catch (System.Exception ex)

            {System.Diagnostics.Debug.WriteLine(ex.Message);}

        }

----------- The part of Desing file ---------------

//

// reportHeader

//

this.reportHeader.Height = new Telerik.Reporting.Drawing.Unit(12.459259986877441, ((Telerik.Reporting.Drawing.UnitType)(Telerik.Reporting.Drawing.UnitType.Cm)));

this.reportHeader.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {

this.titleTextBox,

this.chart1});

this.reportHeader.Name = "reportHeader";

//

// detail

//

this.detail.Height = new Telerik.Reporting.Drawing.Unit(8.0877304077148438, ((Telerik.Reporting.Drawing.UnitType)(Telerik.Reporting.Drawing.UnitType.Cm)));

this.detail.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {

            this.textBox1,

            this.textBox2,

            this.chart2});

this.detail.Name = "detail";

//

            // chart1

            //

this.chart1.Anchor = System.Windows.Forms.AnchorStyles.Top;

this.chart1.BitmapResolution = 96F;

this.chart1.DefaultType = Telerik.Reporting.Charting.ChartSeriesType.Pie;

this.chart1.ImageFormat = System.Drawing.Imaging.ImageFormat.Emf;

this.chart1.Legend.Appearance.Visible = false;

this.chart1.Legend.Visible = false;

this.chart1.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0.37037038803100586, ((Telerik.Reporting.Drawing.UnitType)(Telerik.Reporting.Drawing.UnitType.Cm))), new Telerik.Reporting.Drawing.Unit(1.3857144117355347, ((Telerik.Reporting.Drawing.UnitType)(Telerik.Reporting.Drawing.UnitType.Cm))));

this.chart1.Name = "chart1";

this.chart1.PlotArea.DataTable.Appearance.CellWidth = 25;

this.chart1.PlotArea.XAxis.MinValue = 1;

chartSeries1.DataXColumn = "Mark_Name";

chartSeries1.DataYColumn = "Marks_Count";

chartSeries1.Name = "Series 1";

chartSeries1.Type = Telerik.Reporting.Charting.ChartSeriesType.Pie;

            this.chart1.Series.AddRange(new Telerik.Reporting.Charting.ChartSeries[] {

            chartSeries1});

            this.chart1.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(15.391534805297852, ((Telerik.Reporting.Drawing.UnitType)(Telerik.Reporting.Drawing.UnitType.Cm))), new Telerik.Reporting.Drawing.Unit(10.873545646667481, ((Telerik.Reporting.Drawing.UnitType)(Telerik.Reporting.Drawing.UnitType.Cm))));

            this.chart1.NeedDataSource += new System.EventHandler(this.chart1_NeedDataSource);

//

// chart2

//

this.chart2.BitmapResolution = 96F;

this.chart2.DefaultType = Telerik.Reporting.Charting.ChartSeriesType.Pie;

this.chart2.ImageFormat = System.Drawing.Imaging.ImageFormat.Emf;

this.chart2.Legend.Appearance.Visible = false;

this.chart2.Legend.Visible = false;

this.chart2.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0.37037038803100586, ((Telerik.Reporting.Drawing.UnitType)(Telerik.Reporting.Drawing.UnitType.Cm))), new Telerik.Reporting.Drawing.Unit(0.74084246158599854, ((Telerik.Reporting.Drawing.UnitType)(Telerik.Reporting.Drawing.UnitType.Cm))));

this.chart2.Name = "chart2";

this.chart2.PlotArea.XAxis.MinValue = 1;

chartSeries2.Name = "Series 1";

chartSeries2.Type = Telerik.Reporting.Charting.ChartSeriesType.Pie;

this.chart2.Series.AddRange(new Telerik.Reporting.Charting.ChartSeries[] {

            chartSeries2});

this.chart2.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(15.391533851623535, ((Telerik.Reporting.Drawing.UnitType)(Telerik.Reporting.Drawing.UnitType.Cm))), new Telerik.Reporting.Drawing.Unit(7.3203325271606445, ((Telerik.Reporting.Drawing.UnitType)(Telerik.Reporting.Drawing.UnitType.Cm))));

this.chart2.NeedDataSource += new System.EventHandler(this.chart2_NeedDataSource);

//

// reportHeader

//

this.reportHeader.Height = new Telerik.Reporting.Drawing.Unit(12.459259986877441, ((Telerik.Reporting.Drawing.UnitType)(Telerik.Reporting.Drawing.UnitType.Cm)));

this.reportHeader.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {

this.titleTextBox,

this.chart1});

this.reportHeader.Name = "reportHeader";

 

//

// detail

//

this.detail.Height = new Telerik.Reporting.Drawing.Unit(8.0877304077148438, ((Telerik.Reporting.Drawing.UnitType)(Telerik.Reporting.Drawing.UnitType.Cm)));

this.detail.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {

            this.textBox1,

            this.textBox2,

            this.chart2});

            this.detail.Name = "detail";

 

//

// chart1

//

this.chart1.Anchor = System.Windows.Forms.AnchorStyles.Top;

this.chart1.BitmapResolution = 96F;

this.chart1.DefaultType = Telerik.Reporting.Charting.ChartSeriesType.Pie;

this.chart1.ImageFormat = System.Drawing.Imaging.ImageFormat.Emf;

this.chart1.Legend.Appearance.Visible = false;

this.chart1.Legend.Visible = false;

this.chart1.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0.37037038803100586, ((Telerik.Reporting.Drawing.UnitType)(Telerik.Reporting.Drawing.UnitType.Cm))), new Telerik.Reporting.Drawing.Unit(1.3857144117355347, ((Telerik.Reporting.Drawing.UnitType)(Telerik.Reporting.Drawing.UnitType.Cm))));

this.chart1.Name = "chart1";

this.chart1.PlotArea.DataTable.Appearance.CellWidth = 25;

this.chart1.PlotArea.XAxis.MinValue = 1;

chartSeries1.DataXColumn = "Mark_Name";

chartSeries1.DataYColumn = "Marks_Count";

chartSeries1.Name = "Series 1";

chartSeries1.Type = Telerik.Reporting.Charting.ChartSeriesType.Pie;

            this.chart1.Series.AddRange(new Telerik.Reporting.Charting.ChartSeries[] {

            chartSeries1});

            this.chart1.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(15.391534805297852, ((Telerik.Reporting.Drawing.UnitType)(Telerik.Reporting.Drawing.UnitType.Cm))), new Telerik.Reporting.Drawing.Unit(10.873545646667481, ((Telerik.Reporting.Drawing.UnitType)(Telerik.Reporting.Drawing.UnitType.Cm))));

            this.chart1.NeedDataSource += new System.EventHandler(this.chart1_NeedDataSource);

//

// chart2

//

this.chart2.BitmapResolution = 96F;

this.chart2.DefaultType = Telerik.Reporting.Charting.ChartSeriesType.Pie;

this.chart2.ImageFormat = System.Drawing.Imaging.ImageFormat.Emf;

this.chart2.Legend.Appearance.Visible = false;

this.chart2.Legend.Visible = false;

this.chart2.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0.37037038803100586, ((Telerik.Reporting.Drawing.UnitType)(Telerik.Reporting.Drawing.UnitType.Cm))), new Telerik.Reporting.Drawing.Unit(0.74084246158599854, ((Telerik.Reporting.Drawing.UnitType)(Telerik.Reporting.Drawing.UnitType.Cm))));

this.chart2.Name = "chart2";

this.chart2.PlotArea.XAxis.MinValue = 1;

chartSeries2.Name = "Series 1";

chartSeries2.Type = Telerik.Reporting.Charting.ChartSeriesType.Pie;

this.chart2.Series.AddRange(new Telerik.Reporting.Charting.ChartSeries[] {

            chartSeries2});

this.chart2.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(15.391533851623535, ((Telerik.Reporting.Drawing.UnitType)(Telerik.Reporting.Drawing.UnitType.Cm))), new Telerik.Reporting.Drawing.Unit(7.3203325271606445, ((Telerik.Reporting.Drawing.UnitType)(Telerik.Reporting.Drawing.UnitType.Cm))));

this.chart2.NeedDataSource += new System.EventHandler(this.chart2_NeedDataSource);

 

Kirill Ugolnikov
Top achievements
Rank 1
 answered on 30 May 2008
10 answers
195 views
Hi

I've just upgraded to the final production releases of RadControls for ASP.NET AJAX and Telerik reporting.

I'm having a problem with Charts in Reporting.

My report either binds to a datasource OR in some cases I create the chart programmatically....

Before upgrading, the programmatic charts worked fine but now I simply get a message on the chart saying there IS NO OR EMPTY SERIES.

To try to resolve the problem I've stripped my code down to the following basic code:

    Private Sub Chart1_NeedDataSource(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Chart1.NeedDataSource

        With Me.Chart1
            .ChartTitle.Visible = True
            .ChartTitle.TextBlock.Text = "MY TEST"
            .DefaultType = Charting.ChartSeriesType.Bar

            .Series.RemoveSeries()

            Dim ChartSeries As New Charting.ChartSeries("Test", Charting.ChartSeriesType.Bar)
            ChartSeries.Items.Add(New Charting.ChartSeriesItem(600, "Test"))

            .Series.Add(ChartSeries)


        End With

However I'm still not getting the chart produced...

The code worked fine in the previous release of Reporting.

Binding to a datasource still works OK

Regards

Martin Hoey

Martin
Top achievements
Rank 1
 answered on 29 May 2008
1 answer
130 views
I've created a simple page which contains nothing but a Telerik report viewer. When I run the web application in the IDE, the control shows up on the page as expected.  When I create a virtual directory in IIS 6, and point it to my web application and browse to the page, the report viewer control has broken images and gives javascript errors.

I'm using Visual Studio 2008 on Vista.

httpHandlers in system.web contains 

<add verb="*" path="Telerik.ReportViewer.axd" type="Telerik.ReportViewer.WebForms.HttpHandler, Telerik.ReportViewer.WebForms, Version=2.5.8.414, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" /> 

and system.webServer handlers section contains

<add name="Telerik.ReportViewer.axd_*" path="Telerik.ReportViewer.axd" verb="*" type="Telerik.ReportViewer.WebForms.HttpHandler, Telerik.ReportViewer.WebForms, Version=1.5.1.0, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" preCondition="integratedMode,runtimeVersionv2.0" /> 

Please advise! Thank you...

Andy
Top achievements
Rank 1
 answered on 28 May 2008
2 answers
532 views
Hi,

the samples and posts in the forum are not very clear about that:

Say I have a List<MyDataObject> as Datasource, and MyDataObject has three Properties: double Value1, double Value2 and bool NeedsReformatting. On the Report I have in the detail area two textboxes, one for Value1 and one for Value2.

If NeedsReformatting is false, the Textboxes should display the values, if it is true they should display a dash "-".

I tried this with the Item DataBound event, but using the Processing classes the value is not changed and using the Reporting classes I cannot access the original value of the Data object bound to the current row.

Can you post a simple sample showing how to change the senders (Textbox) text regarding to a certain value of the databound object?

Thanks in advance
Steve
Telerik team
 answered on 28 May 2008
7 answers
164 views
We upgraded an older project from 1.5 to the latest release.  The new changes are exactly what we needed, thanks.  Specifically, the zoom in the designer and the warning for box overlap.  Great work.

One thing we have not been able to resolve is the page numbering.  In the reportviewer a 2 page report shows the first page as "Page 1 of 0", the tool bar show 1 of 2.  The second page shows correctly as 2 of 2 in both the toolbar and reportviewer.  The PDF export properly shows page 1 of 2 and 2 of 2 when exported. Code behind is simply
txtPageCount.Value = "='Page ' + PageNumber + ' of ' + PageCount"

Is there a new method by any chance?  We did not experience this in 1.5 that I can remember.
Steve
Telerik team
 answered on 27 May 2008
1 answer
91 views
Hi all,

The button groups (navigation buttons, print buttons and refresh buttons) appear twice in my ReportViewer. One of the buttons appear as disabled, the other one is enabled. ReportViewer is placed in a UserControl.
Any solution for this problem?

Thanks.
Chavdar
Telerik team
 answered on 27 May 2008
1 answer
54 views
   Dim telerik2 As ChartSeries()
  I want to assign the chart series type inside a if loop
     IF something>10 Then
here i want to give chart series type
     END  IF
Radchart1.Series,.Add(telerik2)
Steve
Telerik team
 answered on 26 May 2008
1 answer
409 views
I'm using Telerik reporting, and I have to create a report with many sections that are configurable. So I've made a main report with subreports for each section. In my main report, I'd like to use the header, to set the title of each section. How do I set a textbox's value dynamically in the header of the main report, based on the subreport displayed on the current page?

I've seen in the expression editor that there's a Global Object ReportItem, is there example on how to use that ? Could that be used to get what I want ?

Thanks a lot.

Milen | Product Manager @DX
Telerik team
 answered on 26 May 2008
1 answer
139 views
It appears that the Web Report Viewer doesn't work too well when AJAX-ified.  Are there any plans to make the Report Viewer more AJAX-friendly?
Chavdar
Telerik team
 answered on 26 May 2008
Top users last month
Will
Top achievements
Rank 2
Iron
Motti
Top achievements
Rank 1
Iron
Hester
Top achievements
Rank 1
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Thomas
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?