Telerik Forums
Reporting Forum
1 answer
54 views
Hello!

I need to create a report that show's the Tasks of the person in a project. I have a List that contains all the tasks and the projects, what i need to implement is, a way to Group the tasks by projects, like this:

PROJECT A
-----------------------------------------------------------------
Task 1
Task 2
Task 3

PROJECT B
------------------------------------------------------------------
Task 1
Task 2
Task 3

But in the list i can have N numbers of projects, how do i implement this?
Thank you!!!

Peter
Telerik team
 answered on 17 Aug 2011
2 answers
110 views
I'm using Silverlight Report Viewer + WCF like this - http://www.telerik.com/help/reporting/silverlight-hosting-in-iis.html
I need to get the report stream,say pdf bytes then upload to Azure Blob. But there's no ReportProcess class in Telerik Silverlight assembly mentioned in this kb http://www.telerik.com/support/kb/reporting/designing-reports/saving-a-report-into-pdf-format-programmatically.aspx

How can I get the report stream?
Steve
Telerik team
 answered on 17 Aug 2011
1 answer
57 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.2K+ 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
81 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
105 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
193 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
182 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
108 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
611 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
Top users last month
Edmond
Top achievements
Rank 1
Iron
fabrizio
Top achievements
Rank 2
Iron
Veteran
RobMarz
Top achievements
Rank 2
Iron
Fakhrul
Top achievements
Rank 1
Iron
Tejas
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?