Telerik Forums
Reporting Forum
3 answers
165 views
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?
Steve
Telerik team
 answered on 04 Nov 2011
4 answers
180 views
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
Steve
Telerik team
 answered on 04 Nov 2011
1 answer
93 views
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
Yana
Telerik team
 answered on 04 Nov 2011
1 answer
276 views
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!
Peter
Telerik team
 answered on 03 Nov 2011
9 answers
684 views
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

Steve
Telerik team
 answered on 03 Nov 2011
6 answers
165 views
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
Kevin Y
Top achievements
Rank 1
 answered on 03 Nov 2011
1 answer
73 views
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: 

<%@ ServiceHost Service="Telerik.Reporting.Service.ReportService, Telerik.Reporting.Service, Version=5.1.11.928, Culture=neutral, PublicKeyToken=A9D7983DFCC261BE" %>

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)
public class BuildingService : LinqToEntitiesDomainService<BuildingEntities>

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.
Peter
Telerik team
 answered on 03 Nov 2011
1 answer
110 views
I was hoping that if I had HTML markup in an HtmlTextBox then when it was exported (to an appropriate format) it would be rendered appropriately.

However, it seems that if I export to either PDF or RTF all I get is the HTML markup.

Am I doing it wrong? Or am I to just be disappointed?

-- 
Stuart
Peter
Telerik team
 answered on 03 Nov 2011
1 answer
121 views
I have an app wherein HTML text is saved in the DB (output from a RadEditor) and I have a requirement to print it.

Now, I've had some success with the HtmlTextBox in Reporting, but, by no means, complete success.

I note from a much earlier thread that the HtmlTextBox doesn't support rendering of an <img> tag and, back then, there was no plan to change that. Is this likely to change? If not what are my options?

-- 
Stuart
Peter
Telerik team
 answered on 03 Nov 2011
6 answers
227 views
Using a Silverlight application and Telerik ReportViewer  we're having the following issue.

We have a drop down to pick a client.  That is passed to the report SQL and is all working fine.

If I run a smaller client report (up to about 60 pages or so works fine), it comes back fine.

If I run a larger client report... I get the following message.

Error: System.Reflection.TargetInvocationException : An exception occurred during the operation, making the result invalid.  Check InnerException for exception details.
   at System.ComponentModel.AsyncCompletedEventArgs.RaiseExceptionIfNecessary()
   at Telerik.Reporting.Service.SilverlightClient.RenderAndCacheEventArgs.get_RenderingResult()
   at Telerik.ReportViewer.Silverlight.ReportViewerModel.OnRenderAndCacheCompleted(Object sender, RenderAndCacheEventArgs e)
 
------------- InnerException: -------------
 
System.ServiceModel.CommunicationException : The remote server returned an error: NotFound.
   at System.ServiceModel.Channels.Remoting.RealProxy.Invoke(Object[] args)
   at proxy_3.EndRenderAndCache(IAsyncResult )
   at Telerik.Reporting.Service.SilverlightClient.ReportServiceClient.OnEndRenderAndCache(IAsyncResult result)
   at System.ServiceModel.ClientBase`1.OnAsyncCallCompleted(IAsyncResult result)
 
------------- InnerException: -------------
 
System.Net.WebException : The remote server returned an error: NotFound.
   at System.Net.Browser.AsyncHelper.BeginOnUI(SendOrPostCallback beginMethod, Object state)
   at System.Net.Browser.ClientHttpWebRequest.EndGetResponse(IAsyncResult asyncResult)
   at System.ServiceModel.Channels.HttpChannelFactory.HttpRequestChannel.HttpChannelAsyncRequest.CompleteGetResponse(IAsyncResult result)
 
------------- InnerException: -------------
 
System.Net.WebException : The remote server returned an error: NotFound.
   at System.Net.Browser.ClientHttpWebRequest.InternalEndGetResponse(IAsyncResult asyncResult)
   at System.Net.Browser.ClientHttpWebRequest.<>c__DisplayClass5.<EndGetResponse>b__4(Object sendState)
   at System.Net.Browser.AsyncHelper.<>c__DisplayClass4.<BeginOnUI>b__1(Object sendState)

Same report... only difference is the volume of data.  I can subsequently pick a smaller client and it reloads and renders just fine.

This error occurs (by me counting) about 40 seconds after the initial call.

I have tried setting the binding as follows (and confirmed the code gets called)

public ReportServiceClient Create(Uri remoteAddress)
{
    var binding = new BasicHttpBinding() // or BasicHttpBinding(BasicHttpSecurityMode.Transport) overload if SSL is used
    {
        MaxBufferSize = int.MaxValue,
        MaxReceivedMessageSize = int.MaxValue,
        ReceiveTimeout = new TimeSpan(0, 15, 0),
        SendTimeout = new TimeSpan(0, 15, 0),
        OpenTimeout = new TimeSpan(0, 15, 0)
    };
 
    var endpointAddress = new EndpointAddress(remoteAddress);
 
    return new ReportServiceClient(binding, endpointAddress);
}

The report is configured using a SqlDataSource object and the CommandTimeout there is set to 900 seconds.  After that SQL text is used with a single parameter.

Again it only fails on large amounts of data... It works fine in Preview mode (design time) as well.  One big one is 1400+ pages which is only about 42,000 rows.
Kevin
Top achievements
Rank 1
 answered on 03 Nov 2011
Top users last month
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
Sergii
Top achievements
Rank 1
Iron
Iron
Dedalus
Top achievements
Rank 1
Iron
Iron
Lan
Top achievements
Rank 1
Iron
Doug
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?