Telerik Forums
Reporting Forum
1 answer
135 views
Hi, I'm using the Telerik chart control to create a Gantt chart. I have managed to produce something close to what I need using sample code I found on these forums, but I have a couple questions.

I need milestones and tasks to be on separate lines, like they are in a Microsoft Project Gantt chart. I have one series for milestones and one for tasks, so that I can the milestones to show up as symbols, and the tasks to show up as bars. However, in order to have this work properly, I needed to do a workaround where my datasource is a list of all milestones and tasks combined into 1 table, and if the start date and end date are the same, I assume that it is a milestone. Is this the correct way to accomplish this? It does not seem correct to me, because I have to create a "fake" column in the database to hold Milestone information, just so that symbols are drawn only on the correct lines. Here is my code that creates the data table. I then bind my chart to this data table.

DataTable table = new DataTable();
table.Columns.Add("Name", typeof(string));
table.Columns.Add("From", typeof(double));
table.Columns.Add("Milestone", typeof(double));
table.Columns.Add("To", typeof(double));
  
for (int i = 0; i < names.Count; i++)
{
    DataRow row = table.NewRow();
    row["Name"] = names[i];
    row["From"] = startDates[i].ToOADate();
    row["To"] = endDates[i].ToOADate();
    if (startDates[i] == endDates[i])
        row["Milestone"] = startDates[i].ToOADate();
    table.Rows.Add(row);
}
  
return table;

Also, is there a way that I can draw dependency lines between tasks, to show if a task is dependent upon other tasks? Thank you.
Hadib Ahmabi
Top achievements
Rank 1
 answered on 17 Jan 2012
2 answers
113 views
Why is there a copy of the the max y value and the max x value showing in the top left? Stacked on top of each other. (See screenshot). Q2 2010 version.



dennis
Top achievements
Rank 1
 answered on 17 Jan 2012
6 answers
239 views
Hello,
    Is it possible to have multiple y axis stacked one on other, (i.e) if i have 4 series have 4 y axis?  The graph would look like 4 Y-axis in the left side since 4 series displayed all the 4 would be having different scaling.
I do not want some thing similar to the "Y Axis Type".

I am using visual studio 2010, Telerik Reporting (licensed -TV446243)

Regards,
Saravanan.R
Saravanan
Top achievements
Rank 1
 answered on 17 Jan 2012
0 answers
144 views
Hey guys,
  
I am working on a .NET 4 Windows Forms application. The application reads data from a VistaDB 4.1 database located in the installation directory, and display a report using Telerik Reporting. The data is phone usage statistics for different people. The db therefore contains a Client table identifying the people in the system and Statistics table, with a foreign key of the client ID and containing the usage statistics for the user.
  
I want to display a listbox on the report allowing the user to select a client from the Client table. Then, the report should only view the data that pertains to this selected client from the Statistics table. The user should be able to keep switching between clients to get a different report.  
  
I know about report parameters, but how exactly do I use them to achieve this goal while working with VistadB? I am working with a manual connection to Vista and NOT a dataset (using the VistaDBConnection object).  
  
Thank you!
John
Top achievements
Rank 1
 asked on 16 Jan 2012
2 answers
212 views
I have an application that uses Silverlight for it's UI front end.
RIA Services (with Entity Framwork) is used for fetching and changing the Entities to POCO objects.

I have 4 projects (Not the actual names of the projects, but suffixes are correct):
Application (Main SL application)
Application.Web (startup Web project)
Domain (SL Class library)
Domain.Web (Main RIA service project with all the services and EntityModels)

There is a RIAService Link between Domain and Domain.Web.
There is a reference to Domain.Web from Application.Web.
There is a reference to Application.Domain from Application.

I am now adding a new ClassLibrary project "ReportLibrary" to house all the reports. I want to use the POCO objects returned by my methods in the services as the source of the reports, but I'm having trouble making the connections needed.
This application is to be deployed to many clients, so the connection string is being stored in the web.config of Application.Web.

My question is:
How do I set up the ReportLibrary project to work with the RIA Service structure I have?

I have looked at this blog Using Telerik Reporting with RIA Services but I don't seem to be able to replicate it. It doesn't really have the same Solution structure.
I tried adding a reference to Domain.Web in ReportLibrary, but when I test the report, it gives the following error:
"The specified named connection is either not found in the configuration, not intended to be used with the EntityClient provider..."
I also tried adding the EntityFramework connection that I used on the web.config in Application.Web, but it did not fix it.

Thanks,
Elian
Telerik team
 answered on 16 Jan 2012
3 answers
211 views
I have a table which is bound to a dataset using the NeedDataSource event.  Within the table layout I have a SubReport which requires a value to be passed to it (SignItemId) which is taken from the data.

I have worked through all the binding events for the table and for the SubReport but try as I might I am unable to find a way to pass this value to the SubReport.

This is what I am trying at the moment in the SubReport ItemDataBinding event.  It dosent matter where I place the code the DataObject is always returned as nothing.
Dim subReport As Telerik.Reporting.Processing.SubReport = TryCast(sender, Telerik.Reporting.Processing.SubReport)
 
        Dim processingTable As Telerik.Reporting.Processing.Table = TryCast(subReport.Parent, Telerik.Reporting.Processing.Table)
 
        Dim dataRow As System.Data.DataRowView = TryCast(processingTable.DataObject, System.Data.DataRowView)
        If dataRow IsNot Nothing Then
            MastDetails1.SignId = CInt((dataRow("SignItemId")))
        End If
Elian
Telerik team
 answered on 16 Jan 2012
2 answers
219 views
I have a current report that works fine when using a single parameter. I attempted to change the gunnumber parameter to multivalue, but can not get the selections to work I changed the = to In, but the dropdown checkbox will not accept the selection.

I have attached pictures of the my parameter and filter. Can someone tell me how to properly convert this to a Multivalue parameter?
Elian
Telerik team
 answered on 16 Jan 2012
1 answer
115 views

Hi,

I am using Telerik Reports Q2 2011 with Silverlight 4. I added an empty chart in a report without specifying a DataSource and with Default Type “Pie”. I assigned a Chart Series to this chart in NeedDataSource Event. In this way, chart successfully created and loaded in silverlight report viewer. But, whenever I try to export that report in any format I get an empty chart in the resulting file with the message “There is no or empty series”. Please, suggest a possible solution for this.

Thanks!

Adil

Steve
Telerik team
 answered on 16 Jan 2012
0 answers
112 views
hi,

i have a parameter its name is namesurname.its datasource is employees which

select command text is ="SELECT DISTINCT EMPID, NAME + ' ' + SURNAME AS NAMESURNAME, BRANCHID
FROM            EMPLOYEES
WHERE        (BRANCHID = @BRANCHID)"

its display text and value is both NAMESURNAME

how can i assign branchid(Guid) value from session while on pageload?
Teoman
Top achievements
Rank 1
 asked on 15 Jan 2012
1 answer
191 views
hi,

i have a parameter which filters product name  and its multi value property is true.when i select only one product from parameter it works.but when i select multiple value or select all it gives incorrect syntax near ','.Can you help me please?
Teoman
Top achievements
Rank 1
 answered on 15 Jan 2012
Top users last month
Miljana
Top achievements
Rank 2
Iron
Iron
Joel
Top achievements
Rank 3
Bronze
Bronze
Bronze
Cynthia
Top achievements
Rank 1
John
Top achievements
Rank 1
Iron
Mozart
Top achievements
Rank 1
Iron
Veteran
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?