Telerik Forums
Reporting Forum
1 answer
193 views
I am using the Stanalone Report Designer Version 7.0.13.426 (Q1 2013 SP1). We want to change the behaviour of the footer rendering when exporting to excel. Because we are using fields to calculate function in the footer of the template.
I know that we have to set 'UseNativePageFooter' to 'false'. But I simply can't find 'UseNativePageFooter', not in the 'Telerik.ReportDesigner.exe.config', not in the .trdx file of the template and not in the gui of the Report Designer. 
Is this function not available for the Standalone Report Designer, or did I overlook it?
If it is not available, what other option do I have to achieve the expected output?
Stef
Telerik team
 answered on 31 Oct 2014
1 answer
79 views
Hi

I would like to show lines connecting child nodes to parent nodes on report. How can I do that.
Or can I change background color of level 2 and its child nodes on report.
Thanks
Nasko
Telerik team
 answered on 31 Oct 2014
2 answers
76 views
I'm getting an ArguementException when setting the viewer's ReportSource to the instanceReportSource.
It was working fine in 2013 Q1, but is broken in 2014 Q3.
Thanks
Stef
Telerik team
 answered on 31 Oct 2014
8 answers
1.0K+ views
I am trying to publish my first Telerik Report to the web. I can display the report when I run it in my development environment. However, when I publish it, I get the following error. (The first error I got told me to insert this     

<add verb="*" path="Telerik.ReportViewer.axd" type = "Telerik.ReportViewer.WebForms.HttpHandler, Telerik.ReportViewer.WebForms, Version=3.2.9.1211, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" />
Line 48: </httpHandlers>
Line 49: <httpModules> ,

and then it says it cant find it.) If I delete it, it tells me to insert it. If I insert it, it says it cant find it. Any ideas?



Configuration Error

Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: Could not load file or assembly 'Telerik.ReportViewer.WebForms, Version=3.2.9.1211, Culture=neutral, PublicKeyToken=a9d7983dfcc261be' or one of its dependencies. The system cannot find the file specified.

Source Error:

Line 45: 			<add path="Telerik.Web.UI.WebResource.axd" verb="*" type="Telerik.Web.UI.WebResource" validate="false"/>
Line 46: 			<add path="ChartImage.axd" verb="*" type="Telerik.Web.UI.ChartHttpHandler, Telerik.Web.UI, Version=2009.2.1007.20, Culture=neutral, PublicKeyToken=121fae78165ba3d4" validate="false"/>
Line 47: <add verb="*" path="Telerik.ReportViewer.axd" type = "Telerik.ReportViewer.WebForms.HttpHandler, Telerik.ReportViewer.WebForms, Version=3.2.9.1211, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" />Line 48: 		</httpHandlers>
Line 49: 		<httpModules>

Source File: E:\readinessandsustainmentwebsite\ActiveWebPages\MPFMods\web.config    Line: 47

Assembly Load Trace: The following information can be helpful to determine why the assembly 'Telerik.ReportViewer.WebForms, Version=3.2.9.1211, Culture=neutral, PublicKeyToken=a9d7983dfcc261be' could not be loaded.

WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].


Version Information: Microsoft .NET Framework Version:2.0.50727.3603; ASP.NET Version:2.0.50727.3082
Marcus
Top achievements
Rank 1
 answered on 31 Oct 2014
1 answer
99 views
My employer has decided to give the Telerik Reporting tools a try. I am only able to use VS2008 @my employer. I just installed the latest version and noticed that VS2008 is not listed. What is the latest version that works with VS2008.
Stef
Telerik team
 answered on 31 Oct 2014
1 answer
141 views
while trying to open craystal report , getting error as attached, with extra details and this error coming because Crystal Reports XI R2 doesnt support on 64 bit machine. due to this error trying to convert craystal report to telerik report

followed all steps mentioned at http://www.telerik.com/support/kb/reporting/details/converting-reports-from-various-versions-of-crystalreports and http://www.telerik.com/help/reporting/faq-available-converters.html

But after this all steps again got same error as attached screenshot. seems like to convert Crystal Reports XI R2 to telerik need 32 bit machine, Is there any way to convert Crystal to telerik reports on 64 bit machine ?




Stef
Telerik team
 answered on 30 Oct 2014
3 answers
137 views
Hi,
Following an test upgrade to .Net 4.5.1 I have had a problem with reporting.  Webpages that used to work now don't workl properly.

I have reduced the page down to a small sample.  The problem is that when a filter button is pressed the ajax call is done with the reportviewer flashing a loading panel then it shows the "The source of the report definition has not been specified." message.  Looking at the codebehind the report is generated OK and is in fact applied to the report viewer.  As mentioned this all works fine with .Net 3.5.

To further test I disable Ajax on the AjaxManager and then following the post back the control works as it should so this is definitly an Ajax issue of some sort.  I am posting the code below.

It is worth noting that I have tried this on two distinct website solutions that I have and exactly the same issue appears.  

Many thanks for any help.

Regards

Jon

<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="Reports.aspx.vb" Inherits="NJC.WasteMonitor.Web.Gen.Reports" %>
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <head runat="server">
        <title></title>
    </head>
    <body>
        <form id="form1" runat="server">
            <telerik:RadStyleSheetManager ID="pgRadStyleSheetManager" runat="server"></telerik:RadStyleSheetManager>
            <telerik:RadScriptManager ID="pgRadScriptManager" runat="server"></telerik:RadScriptManager>
            <telerik:ReportViewer ID="uxReportViewer" runat="server" Width="100%" Height="500px" Skin="Office2007"></telerik:ReportViewer>
            <telerik:RadButton ID="uxLoginButton" Text="Test" runat="server" UseSubmitBehavior="false"  OnClick="uxLoginButtonClick"
                               CausesValidation="false"></telerik:RadButton>
            <telerik:RadAjaxManager ID="uxRadAjaxManager" runat="server"  >
                <AjaxSettings>
                    <telerik:AjaxSetting AjaxControlID="uxLoginButton">
                        <UpdatedControls>
                            <telerik:AjaxUpdatedControl ControlID="uxReportViewer" LoadingPanelID="uxLoadingPanel" />
                        </UpdatedControls>
                    </telerik:AjaxSetting>
                    <telerik:AjaxSetting AjaxControlID="uxReportViewer">
                        <UpdatedControls>
                            <telerik:AjaxUpdatedControl ControlID="uxReportViewer" LoadingPanelID="uxLoadingPanel" />
                        </UpdatedControls>
                    </telerik:AjaxSetting>
                </AjaxSettings>
            </telerik:RadAjaxManager>
            <telerik:RadAjaxLoadingPanel ID="uxLoadingPanel" runat="server"></telerik:RadAjaxLoadingPanel>
        </form>
    </body>
</html>


Partial Public Class Reports
    Inherits System.Web.UI.Page
 
    Protected Sub uxLoginButtonClick(ByVal sender As Object, ByVal e As EventArgs)
        Dim _report As WasteReportReport = New WasteReportReport(GetWasteMonitorConnectionString, "4,5,2", _
                                                                      1, _
                                                                      CDate("01-Aug-2014"), _
                                                                      CDate("06-Aug-2014"), _
                                                                      "", _
                                                                      "", _
                                                                      "", _
                                                                      "", _
                                                                      "")
 
 
        ' Define a reportsource and add the report to it
        Dim _instanceReportSource As Telerik.Reporting.InstanceReportSource = New Telerik.Reporting.InstanceReportSource()
        _instanceReportSource.ReportDocument = _report
 
        ' Add the report source to the report viewer
        uxReportViewer.ReportSource = _instanceReportSource
    End Sub
End Class


Jon
Top achievements
Rank 1
 answered on 29 Oct 2014
4 answers
222 views
Hiya.  I am new to Telerik, using Telerik 2011 Q3 in Visual Studios 2010 on a latop running Windows 7.  Currently I am trying to create a Telerik report using Oracle data and am confused by what is happening with the query. 

The query is fairly large, but executes properly in TOAD.  When I move it to Visual Studios I get mixed results:

1.  When I try to execute the query in Query Builder, I get an "SQL Syntax Errors Encountered" message that says
"Error in SELECT clause: expression near 'SELECT'.
Missing FROM clause.
Error in SELECT clause: expression near ','.
Error in SELECT clause: expression near 'FROM'.
Unable to parse query text."

2. If I bypass Query Builder and continue to the Preview Data Source Results and click Execute Query, the query completes consistantly in approx 2 min.

3. When I go to the Telerik Report Preview mode, enter the variables and click PREVIEW, the hour glass spins but the query never completes.  I have waited 15 min by the clock and not gotten any results (remember the query completes in 2 min in the Preview Data Source Results pane.

I don't know Visual Studios well enough to understand the significance of it working in the  Preview Data Source Results but failing in both the Query Builder and the Report Preview.  It seems strange to me that the Query Builder reports multiple syntax errors, yet the query completes successfully in Preview Data Source Results. I've never seen an SQL query with syntax errors work before, so I am sceptical about the Query Builder error message.  The report does have nested SELECTstatements, which I  assume has something to do with the messages about problems near SELECT and FROM. At the same time, it isn't completing in PREVIEW mode in the report, so something is obviously wrong.

Can someone please shed some light on what is happening?

Thanks!
Kevin
Peter
Telerik team
 answered on 29 Oct 2014
8 answers
483 views
Hello 

I have been evaluating the Telerik-Reports and so far I find them very good. However, when it comes to hierarchical data, I just can't get the reports to work at all. I made up a simplified example, that would be very typical for our company. Should we be able to generate reports using such a hierarchy as datasource, I could convince my boss to purchase Telerik-Reports ;)

I have been trying with subreports as well as groups and tables. However, I can not get it to display any of the sub-classes if they contain either a dictionary or a list. I think the problem is, that it won't recognize the DataSource correctly.

Background for the problem:
I have a list with people (drivers) and I would want to display a report where you can see on what days the people worked and how much work they have done. 

I use the free trial version (Q1_2012_v6_0_12_302) and .NET 4.0 and I am certain that my list contains valid test data. Note, that I have a dictionary as well as lists inside the Classes.

List<DriverDto> drivers;    // this would be the DataSource

// the corresponding data structure
public class DayDto
{
    public DateTime Day { get; set; }
    public int CalendarWeek { get; set; }
    public int Work { get; set; }
    public int Break { get; set; }
}

public class YearDto
{
    public List<DayDto> Days { get; set; }
    public string Year { get; set; }

    public YearDto()
    {
        Days = new List<DayDto>();
    }
}

public class DriverDto
{
    public string Surname { get; set; }
    public string FirstName { get; set; }
    public Dictionary<int, YearDto> Years { get; set; }

    public DriverDto()
    {
        Years = new Dictionary<int, YearDto>();
    }
}

Desired outcome:
The report should look something like this.

=============================================
Peter Parker
=============================================
2011
------------------------------------------------------------------------
January
Date                                 Work (Hours)      Break (Hours)
2011.01.01                         2.5                     1.0
2011.01.02                         2.0                     0.5
Total CalendarWeek 52    4.5      1.5

2011.01.03   3.5                     0.7
2011.01.04                         1.0                     0.2
2011.01.05                         3.0                     0.2
2011.01.06                         2.3                     0.5
2011.01.07                         2.5                     0.2
2011.01.08                         2.7                     0.5
2011.01.09                         3.2                     0.2
Total CalendarWeek 01     18.2                    2.5

2011.01.10                         3.5                      0.7
2011.01.11                         1.0                      0.2
2011.01.12                         3.0                      0.2
2011.01.13                         2.3                      0.5
2011.01.14                         2.5                      0.2
2011.01.15                         2.7                      0.5
2011.01.16                         3.2                      0.2
Total CalendarWeek 02     18.2                     2.5

Total January                      40.9                    6.5
------------------------------------------------------------------------

=============================================
Bruce Banner
=============================================
2011
------------------------------------------------------------------------
January
Date                                 Work (Hours)      Break (Hours) 
2011.01.01                         2.5                    1.0
2011.01.02                         2.0                    0.5
Total CalendarWeek 52      4.5                    1.5

2011.01.03                         3.5                     0.7
2011.01.04                         1.0                     0.2
2011.01.05                         3.0                     0.2
2011.01.06                         2.3                     0.5
2011.01.07                         2.5                     0.2
2011.01.08                         2.7                     0.5
2011.01.09                         3.2                     0.2
Total CalendarWeek 01     18.2                    2.5

2011.01.10                         3.5                     0.7
2011.01.11                         1.0                     0.2
2011.01.12                         3.0                     0.2
2011.01.13                         2.3                     0.5
2011.01.14                         2.5                     0.2
2011.01.15                         2.7                     0.5
2011.01.16                         3.2                     0.2
Total CalendarWeek 02     18.2                    2.5

Total January                     40.9                    6.5
------------------------------------------------------------------------ 

2012
------------------------------------------------------------------------ 
January
Date                                 Work (Hours)      Break (Hours) 
2011.01.01                         2.5                     1.0
Total CalendarWeek 52     2.5                      1.0

2011.01.02                         2.0                     1.0
2011.01.03                         2.0                     1.0
2011.01.04                         2.5                     1.5
2011.01.05                         2.0                     1.5
2011.01.06                         2.0                     1.0
2011.01.07                         2.0                     1.5
2011.01.08                         2.5                     1.5
Total CalendarWeek 01     15.0                    9.0

Total January                     20.0                   10.0
------------------------------------------------------------------------ 

Any hint about how to achieve this would be greatly appreciated.
Stef
Telerik team
 answered on 29 Oct 2014
6 answers
450 views
I just installed version 6.2.13.110 of the Report Designer.  According to the documentation, when adding a SQL Data Source, there should be a "Query Builder" button on the "Configure Data Source Command" screen.  This does not appear to be the case - see attached file.

Any idea why it is missing?
Peter
Telerik team
 answered on 29 Oct 2014
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?