Telerik Forums
Reporting Forum
1 answer
306 views
Hi,

   Howcome telerik does not support nested aggregate functions?
   I need to use Min(Sum(Fields.Value)) in a crosstab detail section. How can i achieve this?

Thanks,
sivam
 
Chris Gillies
Top achievements
Rank 1
 answered on 21 Jul 2010
1 answer
195 views

Hi,

How do I format data bound field from int to string with mask like - ToString("00-000") ?

Jacob
Top achievements
Rank 1
 answered on 21 Jul 2010
8 answers
725 views
I keep getting "Failed to map the path '/'. " error while trying to run a report using the WebViewer module.

I thought it might have something to do with AJAX or other controls on the page, so I started fresh on a blank page, but the problem persists.

Also, the report is in my App_Code folder.  I moved it to a different location, but that just made it disappear from the Properties window (Report prop).

Here's a copy of that code.  Any help is greatly appreaciated.

<%

@ Page Language="VB" AutoEventWireup="false" CodeFile="Default2.aspx.vb" Inherits="Default2" %>

<%

@ Register assembly="Telerik.ReportViewer.WebForms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" namespace="Telerik.ReportViewer.WebForms" tagprefix="telerik" %>

<!

DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<

html xmlns="http://www.w3.org/1999/xhtml">

<

head runat="server">

<title>Untitled Page</title>

</

head>

<

body>

<form id="form1" runat="server">

<div>

<telerik:ReportViewer ID="ReportViewer1" runat="server"

Report="monthly_admin_log_in_report, App_Code.epo0catl, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null" />

</div>

</form>

</

body>

</

html>

Chavdar
Telerik team
 answered on 21 Jul 2010
1 answer
97 views
Hi,

I'm trying to add a ReportViewer to my WebApplication. I've added the reportviewer to one of my usercontrols. When I load the usercontrol I get the following error message:

Runtime-fout Microsoft JScript: Sys.ScriptLoadFailedException: The script '/Arbeidsvoorwaarden/Telerik.ReportViewer.axd?name=Resources.ReportViewer.js&version=4.1.10.714&optype=Resource' could not be loaded.

I've attached an image to show what happens (you can see resource errors as well in the image).

We are using the scriptmanager from the AJAX control toolkit (version 3.5.40412.2). For testing we tried both, ajaxcontroltoolkit scriptmanager and telerik scriptmanager but both gave an error (altough a bit different).

<

 

telerik:ReportViewer ID="rvVerlofurenReport" runat="server"></telerik:ReportViewer>

Report is loaded in code behind (just an empty report for testing).

I've added the following rule to my web.config:

<add name="Telerik.ReportViewer.axd_*" path="Telerik.ReportViewer.axd" verb="*" type ="Telerik.ReportViewer.WebForms.HttpHandler, Telerik.ReportViewer.WebForms, Version=4.1.10.714, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" preCondition="integratedMode"/>

I hope anybody can help
Best regards Patrick

P.J. Keukens
Top achievements
Rank 1
 answered on 21 Jul 2010
4 answers
328 views
hi guys,

i'm wondering, is there a way to make the ReportViewer skip the printer dialog box when printing a report?
i don't want the user to deal with printing options and want to set these things through code,
things like number of copies, default printer etc.
i tried to find a PreviewPrintReport or something like that - haven't find it.

any suggestions?

thanks.

Peter
Telerik team
 answered on 20 Jul 2010
1 answer
122 views
Hi,

I've added two datasources to my report project. the first one is for the report itself, the second one for a chart.
Please see the code below.

<connectionStrings>
   <add name="ReportPlugin.Properties.Settings.Development"
connectionString="Data Source=*****;Initial Catalog=*****;Integrated Security=True"
       providerName="System.Data.SqlClient" />
 </connectionStrings>


//
// sqlDataSource1
//
this.sqlDataSource1.ConnectionString = "ReportPlugin.Properties.Settings.Development";
this.sqlDataSource1.Name = "sqlDataSource1";
this.sqlDataSource1.SelectCommand = resources.GetString("sqlDataSource1.SelectCommand");
//
// sqlDataSource2
//
this.sqlDataSource2.ConnectionString = "ReportPlugin.Properties.Settings.Development";
this.sqlDataSource2.Name = "sqlDataSource2";
this.sqlDataSource2.Parameters.AddRange(new Telerik.Reporting.SqlDataSourceParameter[] {
new Telerik.Reporting.SqlDataSourceParameter("country.id", System.Data.DbType.Int32, "=Parameters.CountryId.Value")});
this.sqlDataSource2.SelectCommand = resources.GetString("sqlDataSource2.SelectCommand");

private void chart1_NeedDataSource(object sender, EventArgs e)
{
    Telerik.Reporting.Processing.Chart chart = sender as Telerik.Reporting.Processing.Chart;
    chart.DataSource = sqlDataSource2;
}

The first datasource connects perfectly. The second doesn't. They make use of the same ConnectionString.
The error is:
An error has occurred while processing Chart 'chart1':
Unable to connect to database. Please verify that your connection string is valid; in case you use a connection string from the application configuration file, make sure the name is correct and the connection string settings are present in the configuration file of your application.

Any ideas?

Thnx,
Robert
Peter
Telerik team
 answered on 20 Jul 2010
1 answer
37 views
Hi,

I posted a question about how bars in a chart can be colored depending ion their value but it seems to have gone missing. Its URL was:

http://www.telerik.com/community/forums/reporting/telerik-reporting/specify-color-of-individual-bars.aspx

Has it been deleted for some reason? Shall I repost the question?

Thanks,
Jason
Steve
Telerik team
 answered on 16 Jul 2010
7 answers
200 views
I'm having a difficult time getting reporting to work with the Silverlight Report Viewer.

I've viewed the video you reference, and I'm at the point where I'm supposed to set the Report property on the Silverlight Report Viewer equal to the assembly qualified name of the report, but I haven't the slightest idea where I get that information.

In another post, you used the following example for the assembly qualified name, 'Report="Telerik.Reporting.Examples.CSharp.BarcodesReport, CSharp.ReportLibrary, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null" '.

Where are these pieces of information coming from?

It would appear as if "CSharp.ReportLibrary" is the name of the class library containing the report, but what is "Telerik.Reporting.Examples.CSharp.BarcodesReport"?

In the video, he uses "Telerik.Reporting.Examples.CSharp.ProductCatalog", but never explains what this is or where it's from. It looks like it's a namespace, but when I put in the namespace I think I should be using it doesn't work.

Can you please break down where these pieces of information come from and how you get the information to include in your project?

Thank you.
Peter
Telerik team
 answered on 16 Jul 2010
1 answer
128 views
We're looking into replacing our very old (10 years+) ActiveReports reporting system with Telerik.  I have a general question which i have not seen in the documentation:
Can Telerik reports (now or in the next few versions) be created dynamically at run time?  
For example, say we store the layout, columns, groupings, filters, etc in our database, can we generate the full report layout at runtime?
Steve
Telerik team
 answered on 16 Jul 2010
4 answers
232 views

Hello,

     I am having some troubles building my first report with Telerik Reporting. I read the docs in order up to this point. I followed the "creating a simple report page" and it seems like all went well for building the library with one simple report. However, onto the next step, displaying the report in a report viewer in wpf does not work. First off, there is no dock property as shown in step 4. The bigger problem however, is setting the report property of the reportViewer.

Here is a code snippet:

     

Public Class ReportView


    Private Sub WindowLoaded(ByVal sender As System.Object, ByVal e As System.Windows.RoutedEventArgs) Handles MyBase.Loaded

Dim routeReport as New ReportingLibrary.RouteReport

        ReportViewer1.Report = routeReport

    End Sub

End Class



And here is the error that I get:

Set property 'System.Windows.ResourceDictionary.DeferrableContent' threw an exception.


RouteReport.vb is report that was created with the report wizard, and previews correctly. I checked the target framework  .NET Framework 4.0 (not the client profile). Any suggestions would be greatly appreciated.



Thanks in advance

Steve
Telerik team
 answered on 16 Jul 2010
Top users last month
Jay
Top achievements
Rank 3
Bronze
Iron
Iron
yw
Top achievements
Rank 2
Iron
Iron
Stefan
Top achievements
Rank 2
Iron
Iron
Iron
Kao Hung
Top achievements
Rank 1
Iron
Bohdan
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?