Telerik Forums
Reporting Forum
1 answer
96 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
146 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
171 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
282 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
3 answers
115 views

Hi,

I have a long report with 10 sections and it shows all sections on web page

but when I export to RTF it splits to first 3 pages and then it does NOT split to 4th pages but instead it continues on the same page and all other section get hidden due to going out of margin.

Please give any suggestions to fix?
(same happens on word export)

Thanks

Steve
Telerik team
 answered on 03 Nov 2011
1 answer
373 views
Hi,

Image of screen attached.
I have built a cross tab that has a number of row groups.
I have three columns which perform a sum aggregate.
Local Column - marked as 1 on screenshot  (which is a field from the EntityDataSource that the grid is bound to) works fine and simply sums the field values for each group
Columns 2 and 3 are bound to sub reports. The sub reports simply sums all items grouped by id. In isolation this works fine.My plan was that the master report would pass in the Id(s) to the sub report as parameters and the sum would happen. However this is not the case.

Problem
When I put the sub reports into the cells as shown beneath 2 and 3 - no values are returned. The sub reports are passed in the parameter that is meant to represent the current row Id - but it does not appear that these are passed in for every master report item.
So the totals are not calculated.
I also need to sum column 1, 2 and 3. 

Please advise if this can be done and how best to do it. An example would be great. C#.

Thanks
Simon
Simon
Top achievements
Rank 1
 answered on 03 Nov 2011
1 answer
94 views
Hi,

Is it possible to pass in the record id to a report on the server so that it reports on only one record?
We want to be able to print a report using a single record that is selected in the Silverlight UI.ie 'Print selected client details'.

Thanks
Simon
Vesko
Top achievements
Rank 2
 answered on 03 Nov 2011
3 answers
433 views
I have images in my project whose build action are set to Resource.  On a WPF form i can use relative paths to access the images as they are embedded in the resources.dll for the project.  When i try to bind a picture box to the relative path of the image, it gives file not found as it builds the path as though it is a physical path.  How can you bind a picture box to an image whose build action is resource?
Chris Rathermel
Top achievements
Rank 1
 answered on 02 Nov 2011
3 answers
142 views
Hello All,

I have to create reports to calculate the total hours of the appointments with the details from the Appointments table.
As the recurring appointments get generated on fly and do not get stored in the database how should we include these recurring hours in the total hours?
Please reply as soon as possible.

Thanks,
Roshani
Peter
Telerik team
 answered on 02 Nov 2011
1 answer
144 views
Is there any way i can get the source for the following Link: http://telerikreporting.cloudapp.net/SilverlightViewer.aspx? I keep getting errors when running in Azure environment in both DevFabric and Deployed to Azure. When I run locally in IIS it works fine.

I just want the code to use as reference to see what I'm doing wrong.
Steve
Telerik team
 answered on 02 Nov 2011
Top users last month
Tien
Top achievements
Rank 1
Iron
Krasimir
Top achievements
Rank 3
Bronze
Iron
Iron
Cedar
Top achievements
Rank 1
Iron
Emil
Top achievements
Rank 1
Iron
Kyle Watson
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?