Telerik Forums
Reporting Forum
1 answer
47 views

Hello,

Can I add the result of a report in the viewer without using silverlight serviceTelerik Reporting?

ie:
Server side: Can I get a stream
Silverlight viewer side: Can I manually add stream to display the report?

Regards.
Gerard.
Peter
Telerik team
 answered on 17 Aug 2011
18 answers
1.1K+ views
Hello!

My scenario is as follows.

I have a report that is bound to a DataSet. That DataSet has 2 Tables, Table and Table1. In the detail section I display information from Table and have a List where I am showing data from Table1. I now want to be able to filter the data in the List, using a filter expression. The criteria I need to filter is this:

Table.Person_ID = Table1.Student_ID

Is this possible and how? I've tried with Fields.Person_ID = Fields.Student_ID and nothing...

The DataMember properties are properly defined on the report and on the list.

Any ideas?

Regards!
Bader
Top achievements
Rank 1
 answered on 17 Aug 2011
1 answer
71 views
Hi, when charting values up to 100% we initally had the Y axis going up to 120%.
Once this was resolved we had a Y with 100%, however the data being plotted is often at or around 100% and so the labels on both our column and line graphs are being cut off (because there is no room above the plot for the "100%" or the "99.95%" to be displayed.

image attached
Steve
Telerik team
 answered on 17 Aug 2011
1 answer
89 views
Hi all.
why does not your Product(telerik Reporting Q2 2011) support in .Net Framework 4 Client Profile and it's support in .Net Framework 4?
Steve
Telerik team
 answered on 16 Aug 2011
1 answer
183 views

Hi all!

I have a Master report containing a sub report. In the sub report i'm trying to use a userdefined function called returnThis(). Below are the two versions of the function.

 

public static double returnThis()

        {

            return 22.6;

        }

 

        //public static double returnThis(double avgMark)

        //{

        //    //SqlConnection conn = null;

 

        //    //conn = new SqlConnection("Data Source=AGAHIMBARE-PC;Initial Catalog=VTLARIMS;Integrated Security=True");

 

        //    //conn.Open();

        //    //string strSQLCommand = "SELECT Top(1) GradePoint FROM  GradeMarks WHERE avgMark BETWEEN LowerPercentage AND UpperPercentage";

        //    //SqlCommand command = new SqlCommand(strSQLCommand, conn);

        //    //string xx = command.ExecuteScalar().ToString();

        //    //   double returnvalue = System.Convert.ToDouble(xx);

        //    //conn.Close();

        //   // return returnvalue;

        //    return avgMark;

        //}

 

when i use the one without any argument, it works fine ie. returns 22.6
However when i use the one which is passed a parameter (the disabled one) i get "An error occured while trying to process text box. The expression contains undefined function call returnThis()"

 

 

I call the function using  =returnThis(52.1) as the value for a textbox on the subreport.

 

Can anyone help me here plz. Thnx so much.

Mike
Top achievements
Rank 1
 answered on 15 Aug 2011
3 answers
157 views
Hi,

I'm trying to color the series items in the Pie chart, but I failed.
Here is my code:

//Pie chart Item Data Binding
        private void pieChart_ItemDataBinding_1(object sender, EventArgs e)
        {
            Telerik.Reporting.Processing.Chart chart = sender as Telerik.Reporting.Processing.Chart;
            Telerik.Reporting.Processing.DetailSection section = (Telerik.Reporting.Processing.DetailSection)chart.Parent;
            Telerik.Reporting.Processing.IDataObject dataObject = (Telerik.Reporting.Processing.IDataObject)section.DataObject;
            object rowdata = (object)section.DataObject.RawData;
            Telerik.Reporting.Processing.TextBox procTextbox = (Telerik.Reporting.Processing.TextBox)section.ChildElements.Find("taskIDTextBox", true)[0];
  
            Telerik.Reporting.Chart chartDef = (Telerik.Reporting.Chart)chart.ItemDefinition;
            Telerik.Reporting.Charting.ChartSeries series = new Telerik.Reporting.Charting.ChartSeries();
            series.Type = ChartSeriesType.Pie;
            Telerik.Reporting.Charting.ChartLegend legend = new Telerik.Reporting.Charting.ChartLegend();
  
            string CoverDescription;
            int itemValue;
  
            string commandText = string.Empty;
            SqlConnection connection = new SqlConnection(global::QTaskReporting.Properties.Settings.Default.QTDbConnString);
            commandText = "SELECT COUNT(*) AS ItemCount, SDesc, SColor FROM vwSubTasksAndStatuses where TaskID = " + procTextbox.Value + " GROUP BY SDesc,SColor";
            SqlCommand cmd = new SqlCommand(commandText, connection);
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataSet ds = new DataSet();
            da.Fill(ds);
  
            foreach (DataRow rowView in ds.Tables[0].Rows)
            {
                Telerik.Reporting.Charting.ChartSeriesItem seriesItem = new Telerik.Reporting.Charting.ChartSeriesItem();
  
                //The chart Y value will be based on the Value amount 
                seriesItem.YValue = Convert.ToInt32(rowView["ItemCount"]);
                seriesItem.Appearance.FillStyle.FillType = Telerik.Reporting.Charting.Styles.FillType.Solid;
  
                //The chart item label should be set to the Value amount 
                itemValue = Convert.ToInt32(rowView["ItemCount"]);
                seriesItem.Label.TextBlock.Text = rowView["SColor"].ToString().Trim() + " - " + rowView["SDesc"].ToString();
                seriesItem.Label.Appearance.LabelLocation = Telerik.Reporting.Charting.Styles.StyleSeriesItemLabel.ItemLabelLocation.Inside;
                seriesItem.Label.TextBlock.Appearance.TextProperties.Color = System.Drawing.Color.FromArgb(((int)(((byte)(28)))), ((int)(((byte)(58)))), ((int)(((byte)(112)))));
                seriesItem.Appearance.FillStyle.FillType = Telerik.Reporting.Charting.Styles.FillType.Solid;
                seriesItem.Appearance.FillStyle.MainColor = ColorTranslator.FromHtml("#" + rowView["SColor"].ToString().Trim());
  
                //Assign the chart item description
                CoverDescription = rowView["SDesc"].ToString();
                seriesItem.Name = CoverDescription.Trim();
  
                //Give the "New" chart item an exploded appearance
                if (seriesItem.Name == "New")
                {
                    seriesItem.Appearance.Exploded = true;
                }
  
                series.AddItem(seriesItem);
  
            }
  
            //Display the legend
            series.Appearance.LegendDisplayMode = ChartSeriesLegendDisplayMode.ItemLabels;
            series.Appearance.Border.Color = System.Drawing.Color.White;
            series.Appearance.Border.Visible = false;
            series.Appearance.DiameterScale = .90;
  
            series.Appearance.ExplodePercent = 10;
  
            chartDef.Series.Clear();
            chartDef.Series.Add(series);
  
            chartDef.Legend.Appearance.Position.AlignedPosition = Telerik.Reporting.Charting.Styles.AlignedPositions.TopRight;
        }

View attached screen-shots in order to show you that the Pie chart doesn't display the colors I sat for the items.
By the way the pie chart displays the real data, but the colors are wrong.

Please, I need your help in order to solve the above problem.
It is appreciated to send me the modified code.

Regards,
Bader
Steve
Telerik team
 answered on 15 Aug 2011
1 answer
96 views
Does the Telerik Reporting Support Security Methods Like Encryption and Password protection.

On all Exported Types
Steve
Telerik team
 answered on 15 Aug 2011
4 answers
571 views
Hi,

I have a strange question for you : it is possible to add parameters to the report viewer using JS ? In my case, I have a splitter with 3 panes (take a look to the attached png) and I want my report (in the right lower pane) to show the value of the textbox in the upper pane. Moreover, I don't want my left pane (the one with the tree view) and my upper pane to be refresh each time I reload the report. In other words, when I click on the button "preview", the report should be updated with the good values, but not the upper pane neither the left pane. So, I think I should use javaScript, but I'm not sure if it possible to realise my scenario with JS.

Does anyone have a solution for me ?
Thank you

David
Plamen
Telerik team
 answered on 15 Aug 2011
3 answers
104 views
I worked for 1 year with XtraReport of DevExpress, but I've only had problems, very unstable, unfriendly, simple things end up being very complicated. The designer has many many many bugs and work with this has been torture. I can write 50 or 60 lines of problems encountered with the XtraReport.

For 5 days I have been testing the Telerik.Reporting and I'm happy, we are seriously evaluating purchase, ease of use is incredible. I really like the ReportViewer is simple but very powerful, I have to write too much code to use.

Let me clarify, I develop applications for Windows Forms.

I have 2 basic questions:

1.- I can use my connection object instead of the connection string?
2.- How I can bind a datable to the report. I've tried in many ways without success

Dim oTabla As New DataTable
       oTabla.Columns.Add("F1")
       oTabla.Columns.Add("F2")
       oTabla.Columns.Add("F3")
       oTabla.Columns.Add("F4")
 
       Dim objectDataSource3 As New Telerik.Reporting.ObjectDataSource()
       Dim oReport3 As New ReportNew1
       oReport3.DataSource = oTabla
 
       Dim oFrm As New FrmReportViewer
       oFrm.ReportViewer1.Report = oReport3
       oFrm.ReportViewer1.RefreshReport()
       oFrm.ShowDialog()      

Thanks you.

Wonderful product.!!

David.


Peter
Telerik team
 answered on 15 Aug 2011
3 answers
180 views
I have a couple of parameterd on my report which have about 9500 string items in them.

I use a Telerik.Reporting.SqlDataSource to fill these up and i am displaying the report in the silvelright report viewer.

The problem is that when you drop down the combo box it take about 20-30 sec for it to happen and also once done it very sluggish scrolling up and down.

Does any one know how to fix this?

Thanks
Peter
Telerik team
 answered on 15 Aug 2011
Top users last month
Rob
Top achievements
Rank 3
Iron
Iron
Iron
Atul
Top achievements
Rank 1
Iron
Iron
Iron
Alexander
Top achievements
Rank 1
Veteran
Iron
Serkan
Top achievements
Rank 1
Iron
Shawn
Top achievements
Rank 1
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?