Telerik Forums
Reporting Forum
3 answers
80 views
Upgraded to latest Telerik Reporting -  It the old designer, no fancy tabs, or Rulers, etc.

Also,  Can't seem to do a total in the footer.

Any ideas?

Thanks,
David
David
Top achievements
Rank 1
 answered on 03 Jun 2008
5 answers
167 views
Hi, I'm creating some reports with Pie charts.
I need to know, how I change the Chart title. The property name for class Chart doesn't change the char title, and ChartTitle is read only.
The other question is how I show the name of the series and the percent.

Best Regards,
Sebastián Reale
Steve
Telerik team
 answered on 02 Jun 2008
1 answer
96 views
Hi, have anyone of you have come across this? rather a bit strange.
When i open the reportviewer at IE7 in vista, as the page is in RADwindow as frame, it simply not showing "Internet explorer cannot open... etc"
Steve
Telerik team
 answered on 02 Jun 2008
1 answer
83 views
Hi All,

I want to know,how to export the telerik reports programmitically to pdf format in winforms.
Rossen Hristov
Telerik team
 answered on 02 Jun 2008
3 answers
286 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
203 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
228 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
139 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
607 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
189 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
Top users last month
Simon
Top achievements
Rank 2
Iron
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Marco
Top achievements
Rank 4
Iron
Iron
Iron
Grant
Top achievements
Rank 3
Iron
Iron
Iron
Kao Hung
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?