Telerik Forums
Reporting Forum
8 answers
103 views
I recently went to add a new report into an existing project. I added the parameters to the report and went to add my filter. When I click the ellipse to add the filter, the entire report locks up and I have to close the file using ctrl-alt-delete.

I have created a new report, openened other existing reports, upgraded to the latest build of terlerik reporting and have the same issue no matter what I do. Any ideas as to what is going on here? I have created an extremely simple new report, and have this issue regardless of what I do.
wja
Top achievements
Rank 2
 answered on 27 May 2010
1 answer
87 views
I have been observing your site looking for the 10.1 release of your tools, as you have mention that you can install the reports locally with Silverlight and render them.  GREAT!!!  I downloaded and installed your trial tools....

I've been digging for about an hour now in your documentation, etc. and cannot find a way of creating a Silverlight *.dll, add a report to it, and then subsequently render that report.  The only examples I seem to see all need a web service to render properly.

Am I missing something here?

(link to mentioning of Out of Browser here.)

If all you are saying is that the SL Report Viewer can be installed locally, then your marcomm is rather misleading.
Steve
Telerik team
 answered on 27 May 2010
4 answers
75 views
I have a question about what happens "behind the scenes" with a report filter.

Scenario:  I have a web app with a report that uses a SQLServer view as its data source.  The view contains data for all clients.  For sake of an example, let's say there are 10,000 clients.  The report has 1 ReportParameter, the ClientID, and that parameter is used to Filter the results shown on the report.

What happens behind the scenes to pull data onto the report?  I can imagine two possibilities:

1) The report viewer opens the view, and 10,000 rows of data are passed from the SQLServer to the WebServer.  The report viewer filters the data down to 1 row by ClientID and displays the report to the end user.
OR
2) The report viewer reads the ReportParameter and passes a query string to the SQLServer like "Select * from View WHERE ClientID = 'XYZ'".  Then, the SQLServer passes just 1 row of data to the Webserver, and the report viewer displays the report.

I expect the answer is #1, but I hope for #2.  Clearly, #2 results in a LOT less network traffic.
Peter
Telerik team
 answered on 27 May 2010
4 answers
4.6K+ views
Testing a field for null value does not work with Q2 2009 and SQL Server.
I tried
=IIf(Fields.myField = Null, "Some text " + Fields.myField, "N/A") 
and I always get "N/A" even when Field.myField is not null.

Any idea?
Thanks!
Janus Pedersen
Top achievements
Rank 2
 answered on 27 May 2010
2 answers
213 views
In addition to the post "RadComboBox.SelectionBoxItemTemplate is read only" error in Silverlight viewer", I have this Issue on the dev build for Silverlight 4 (RadControls_for_Silverlight_4_2010_1_0422_DEV)  too.
Valeri
Top achievements
Rank 1
 answered on 27 May 2010
0 answers
89 views
Hi,

I am using telerik report for my project, the reports generated are very big and thus time consuming.That is teh reason what we are doing is :

Generating summary report on the button click and sending the another asynchorous request for the detailed report. As that request might take upto 15mins to generate taht report and we can't ask our website user's to wait for the report generation for such a long period.The user can view report in PDF format as and when it ready though async request.

The problem we are facing is that the summary report is not rendered until the PDF that is being generated through asyn request. This is due to the reason that only 1  instance of the report  is avaliable for both the requests. Dont know what is the intance for it.
SearchAnalysisReportPDF rpt = new SearchAnalysisReportPDF(dsSearchReport);  
ReportProcessor reportProcessor = new ReportProcessor();  
RenderingResult result = reportProcessor.RenderReport("PDF", rpt , null);  
using (FileStream fs = new FileStream(fileName, FileMode.Create))  
{  
    fs.Write(result.DocumentBytes, 0, result.DocumentBytes.Length);  
    fs.Close();  
}  
 
 

Please reply.

Thanks and Regards,
Yuvika
Yuvika
Top achievements
Rank 1
 asked on 27 May 2010
1 answer
122 views
Hi

I no similar questions have been asked but the answer has always been to use client side.

I have an intranet application and need to print from the webserver because at one button click i need to loop through and print many reports.

By ajusting security, system impersonation or whatever is it posible to print on the webserver.

Many Thanks

Al
Al
Top achievements
Rank 1
Iron
 answered on 27 May 2010
1 answer
152 views
Dear all,
I am preparing a report that calculates all kinds of things from an objectSource which gets its input from a database view.
The customer wants to only see certain total values which I have grouped. I do need all detail rows because of the selections that have to be made through report parameters, in order to show the right information.

Unfortunately, the customer also wants to be able to sort the report (being the totals) in a few ways. On a detail-level I know how to implement sorting using a dropdown list (I found that on the blog), but so far I have not been able to find a way to sort the report totals.

On http://www.telerik.com/help/reporting/p_telerik_reporting_group_sorting.html I found that there must be a way to do this, but the info on the page:

Gets a SortingCollection that defines the sort column(s), and their type and order for the Group
Collapse imageSyntax
C#
public SortingCollection Sorting { get; }

is not much help to me.

The report shows movie-titles, revenue and number of seats (yes, this is about a movie theatre), and I need to be able to sort those (title ascending, revenue or number of seats descending).

Is there a knowledgeable soul who can tell me how to do this?

Thank you!

Paul
Paul Kater
Top achievements
Rank 1
 answered on 27 May 2010
1 answer
111 views
Are there any plans to add a web based designer in the future?  Something that would allow end users to edit / create reports via a browser.
Steve
Telerik team
 answered on 27 May 2010
3 answers
201 views
Hi, I try to do the same thing you do on one of your Telerik video. I am using silverlight 4 with RIA service.

I use the Business Application templace and add a ReportLibrary in the solution.
In this ReportLibrary I add a simple report named BasicReport.cs

Each time the RaportViewer try to load the rapport i got this error:
Could not load file or assembly 'ReportLibrary, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified.

Here my test page:
<navigation:Page   
  x:Class="GestionMembre.About"   
  xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"   
  xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"   
  xmlns:d="http://schemas.microsoft.com/expression/blend/2008" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" 
  xmlns:navigation="clr-namespace:System.Windows.Controls;assembly=System.Windows.Controls.Navigation" 
  xmlns:RepportViewer="clr-namespace:Telerik.ReportViewer.Silverlight;assembly=Telerik.ReportViewer.Silverlight" 
  mc:Ignorable="d" d:DesignWidth="640" d:DesignHeight="480"    
  Style="{StaticResource PageStyle}" xmlns:riaControls="clr-namespace:System.Windows.Controls;assembly=System.Windows.Controls.DomainServices" xmlns:sdk="http://schemas.microsoft.com/winfx/2006/xaml/presentation/sdk">  
 
    <Grid x:Name="LayoutRoot">  
        <RepportViewer:ReportViewer x:Name="xReportViewer" ReportServiceUri="../ReportService.svc" Report="ReportLibrary.BasicReport, ReportLibrary, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null">  
        </RepportViewer:ReportViewer> 
          
    </Grid> 
 
</navigation:Page> 


I test with Reflector to be sure of my assembly name...

Any suggestion?
john baker
Top achievements
Rank 1
 answered on 26 May 2010
Top users last month
Chester
Top achievements
Rank 1
Iron
Simon
Top achievements
Rank 1
Iron
Douglas
Top achievements
Rank 2
Iron
Iron
SUNIL
Top achievements
Rank 3
Iron
Iron
Iron
Marco
Top achievements
Rank 3
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?