I have a report that shows me a customer's ID, their bank, and a certain fee. When I run the report it shows the correct data in the correct format but the report repeats itself. I should only be getting back one page but I am getting back sometimes 150 pages depending on which customer parameter I choose to run the report on. Here is a simple example of the data I should be getting back.

CustomerID: 123456     Bank: BOA    Fee: $300
CustomerID: 554433     Bank: Wells Fargo     Fee: $324
CustomerID: 225676     Bank: FCU    Fee: $400

However, when I run the report, I am getting back multiple pages containing the same data, like this:

CustomerID: 123456     Bank: BOA    Fee: $300
CustomerID: 554433     Bank: Wells Fargo     Fee: $324
CustomerID: 225676     Bank: FCU    Fee: $400

CustomerID: 123456     Bank: BOA    Fee: $300
CustomerID: 554433     Bank: Wells Fargo     Fee: $324
CustomerID: 225676     Bank: FCU    Fee: $400

CustomerID: 123456     Bank: BOA    Fee: $300
CustomerID: 554433     Bank: Wells Fargo     Fee: $324
CustomerID: 225676     Bank: FCU    Fee: $400

CustomerID: 123456     Bank: BOA    Fee: $300
CustomerID: 554433     Bank: Wells Fargo     Fee: $324
CustomerID: 225676     Bank: FCU    Fee: $400



Any ideas?

I am trying to use the htmltextbox on a report. However, when I add an htmltextbox to the report I see the time it takes to display the report on the screen go from 3 seconds to 70 seconds. I see this time delay even when I don't tie any data to the htmltextbox and just allow it to display the default text. I have tried this with a blank report (table of about 100 records) which only has an htmltextbox on it and the speed to render is too slow to ever use this type of item.
I would appreciate any suggestions about how to resolve this issue.

Hello,

I am currently evaluating your reporting product...  I am attempting to connect to an EF 4.1 Object Context...  I created a partial class with a new method that returns a list of a customized class for the report like so:

namespace Telerik.Reporting.Examples.CSharp
{
    public partial class WOCatalogEntities1
    {
        
        public List<ReportData> GetWorkOrdersForReport()
        {
            
            this.ContextOptions.LazyLoadingEnabled = true;
            var list = this.WorkOrderHeaders.Where(e => e.WOStatusType.is_open_status).Select(e => new ReportData
            {
                WONumber = e.wo_no,
                LastEdited = e.server_updt,
                Status = e.WOStatusType.status_desc,
                Task = e.task,
                Tech = e.WOPersonnel.lname,
                VendorNumber = e.pp_vendorcode,
                WOType = e.WOTaskType.TaskType,
                WOUnit = e.WORentalUnit.unit
            });
 
            return list.Take(50).ToList();;
            
        }
 
 
    }
 
    public class ReportData
    {
 
        public int WONumber { get; set; }
        public string WOUnit { get; set; }
        public string Tech { get; set; }
        public string Status { get; set; }
        public string VendorNumber { get; set; }
        public string Task { get; set; }
        public string WOType { get; set; }
        public DateTime? LastEdited { get; set; }
 
    }
 
 
}

the partial class is in the same assembly AND the same namespace as the Entity Model of the same name...  but I get the error that telerik cannot find the method ???



Telerik.Reporting.Processing.Data.ObjectDataSourceException: Method GetWorkOrdersForReport() not found.
   at Telerik.Reporting.Processing.Data.ObjectQueryProvider.GetSelectMethod(Type type, String name, IDictionary`2 parameters)
   at Telerik.Reporting.Processing.Data.ObjectQueryProvider.ResolveDataSourcePropertiesFromType()
   at Telerik.Reporting.Processing.Data.ObjectQueryProvider.ResolveDataSourceProperties()
   at Telerik.Reporting.Processing.Data.ObjectSchema.FillSchema(ObjectQueryProvider queryProvider)
   at Telerik.Reporting.Processing.Data.ObjectSchema..ctor(ObjectQueryProvider queryProvider)
   at Telerik.Reporting.Processing.Data.ObjectQueryProvider.CreateSchema()
   at Telerik.Reporting.Processing.Data.MultidimensionalQueryProvider.GetSchema()
   at Telerik.Reporting.Design.DataSourceService.GetCurrentDataSourceSchema(Boolean throwOnError)
   at Telerik.Reporting.Design.DataExplorerControl.RefreshDataSource()



Thanks
Greg

I have reports that I want to display without paging so that they expand down the page without having to use the viewer's scrollbars.  Is there a way to do this?  I've got the non-paging reports working by using the GroupKeepTogether property, but I can't seem to set the viewer to not have a scrollbar and to render its full height.  Is this a limitation of using an iframe to render the report?

Hello -
When I print the report I created (it is a web app, so printing via IE) and there is a label [ReportName] (including the brackets) that prints on the report output.  I looked at the properties for my report (in the report lib) and it does have a Name. 

So, where is this coming from and can I set it to be the actual name of the report?

Thanks
 - will

Hi, 

I'm sure this is a common request. Do you have an example of how to report on recurring appointments using the recurrence pattern saved with the appointment?

We have many recurring appointments, and our reports need to include these when getting appointments by a range of dates.
We are using Entity Framework so ideally your example uses a partial class approach.

Thanks

Hi,

I have a telerik report with chart.
The chart data source is a default sql query (I set it by design):

select *
from customers

In my ascx page I have a filter box, for example for the customer location with the values - All, France, Italy, Spain.
If the user selected location and pressed "Generate", I want to change the query to:

select *
from customers
where location = '(The selected value)'

if the selected value is all, I want to run the report as is.

Is there a way to change a chart query in run time?

Thanks!

Hi,

Instead of having data in rows horizontally is it easy to list data vertically in columns.

E.g instead of

Name, Age, Country, Profession
Name, Age, Country, Profession
Name, Age, Country, Profession

I want to achieve

Name                    Name                 Name
Age                       Age                    Age
Country                Country              Country
Profession            Profession         Profession

Thanks,

Ronan

I save chemiscal formula into sql2005 (ex: H2O, 2 is subscript by richtextbox format rtf), i want to show this formula in telerik report but i don't know . Can anyone help me?
Thank you

My main goal is to set up Telerik reporting in my Silverlight application with RIA Services. But I can't get it working. Even not the easy bits.
I have been reading and trying and reading and trying without any luck.

What did I do:
- Server side (the same project that contains my services and Entity Model): create a "Reports" directory, create a Telerik report in it
- In my Services directory, create a "ReportingService.svc" that contains one line of code: 


I also updated my web.config file with the proper WCF settings for the ReportService (bindings and endpoints) as explained in the Telerik article.

On my report I set the DataSource to an objectSource with
DataMember = GetBuildings    // this is the name of the method from my DomainService that returns Buildings
DataSource =  ProjectName.Web.Services.BuildingService // full qualified name of my DomainService

My DomainService (BuildingService)

Where BuildingEntities is my EntityModel.

When in the report designer, I can see the fields of my Building entity. But in the preview windows I receive the error "Exception has been thrown by the target of an invocation. The specified named connection is either not found in the configuration, not intended to be used with the EntityClient provider or not valid."

What am I doing wrong?

I must say that I also tried to create a class library with an new entity model to the database (even using the AdventureWorks db), using the EntityDataSource, and I receive the same errors.