Telerik Forums
Reporting Forum
2 answers
323 views

When I try to run the report on a specific machine, I am getting the following error message. This program runs locally, and on other servers just fine.

System.ArgumentException: Unable to find the requested .Net Framework Data Provider.

Full Error message and call stack:

Telerik.Reporting.Processing.Data.SqlDataSourceException: Unable to establish a connection to the database. Please, 
verify that your connection string is valid. In case you use a named 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. ---> 
System.ArgumentException: Unable to find the requested .Net Framework Data Provider.  It may not be installed.
   at System.Data.Common.DbProviderFactories.GetFactory(String providerInvariantName)
   at Telerik.Reporting.Processing.Data.SqlProviderFactory.CreateConnection()
   at Telerik.Reporting.Processing.Data.SqlCommandProvider.CreateConnection(String connectionString)
   at Telerik.Reporting.Processing.Data.SqlQueryProvider.CreateConnection()
   --- End of inner exception stack trace ---
   at Telerik.Reporting.Processing.Data.SqlQueryProvider.CreateConnection()
   at Telerik.Reporting.Processing.Data.SqlDataEnumerable.<GetEnumerator>d__0.MoveNext()
   at Telerik.Reporting.Processing.Data.ResultSetAdapter.Fill(ResultSet resultSet, IEnumerable`1 data)
   at Telerik.Reporting.Processing.Data.SimpleDataProvider`1.Execute(MultidimensionalQuery query)
   at Telerik.Reporting.Processing.Report.ResolveData()
   at Telerik.Reporting.Processing.Report.ProcessItemCore()
   at Telerik.Reporting.Processing.Report.ProcessItem()
   at Telerik.Reporting.Processing.ReportItemBase.ProcessElement()
   at Telerik.Reporting.Processing.ProcessingElement.Process(IDataMember dataContext)
Donald
Top achievements
Rank 1
 answered on 28 Apr 2014
6 answers
509 views
Hi,

I create reports using standalone report designer. Reports are run on reportviewer in an asp.net webform. Is there anyway to capture report generation start and end time? Also is there anyway to capture timeout message and customize it?
Stef
Telerik team
 answered on 28 Apr 2014
3 answers
129 views
Hi, 

We are facing issues with the Telerik reporting' print... It was working previously, after newer adobe update: version Adobe Reader XI (11.0.02) nothing happens on the click of the print button. current reporting version installed on the server 5.1.11.713.

Thanks,
Anuj
Stef
Telerik team
 answered on 28 Apr 2014
1 answer
497 views
Hi,

I am creating a report for a membership database that lists all members of the organization, grouped by US state. For each state, each member record is displayed in a row with several columns of data (e.g., first name, last name, address, etc.). One of the columns is called "member type" and has values such as "youth", "adult", and "honorary". What I would like to do in the group footer is display a summary of the count of each member type found in the given US state. The table should look like this:

Member Type            Members
-------------------            -------------
Adult                                105
Youth                                 28
Honorary                             5
......

I created the report and everything looks great except I cannot figure out how to create this summary data in the group footer. Each state's members are grouped and displayed correctly but each state should have its own table at the end of each group section. I have tried a crosstab, creating a subreport but to no avail. Any advice is much appreciated.

Ivan Hristov
Telerik team
 answered on 28 Apr 2014
3 answers
260 views
Hi,

I am trying to convert an application that uses Crystal reports to use Telerik reporting

The issue I have is this... In my Crystal Report I have a cross tab that has months as columns and items as rows so I can see the value for each item month by month. There are also total columns and rows so I can see the total for each month as well as the total for each item. The cross tab is sorted so that the items with the highest total is at the top This is all fine and I have got this working in Terlerik reporting.

However, although this is fine if I want to show all items, what I actually want to show is the Top 5 items and everything else bundled into a 6th Item labelled "Other". I can do this in Crystal by using the "Cross-Tab Top N and Sort Expert", but how do I do this in Telerik?

Many thanks in advance

Regards



Huw
Stef
Telerik team
 answered on 28 Apr 2014
1 answer
200 views
I am trying to use the report viewer widget in my Existing MVC 4 project.  I followed the steps found on this tutorial:
.  http://www.telerik.com/help/reporting/mvc-report-viewer-extension-embedding.html
The difference I change from the guide posted to my own project was to put the styleing in my MVC project css and add the the javascript files with the MVC bundles.  

I am trying to view the reports from the reportviewer widget and am trying to use the follwing view to instantiate the widget

    @(Html.TelerikReporting().ReportViewer()
        .Id("reportViewer1")
        .ServiceUrl("/api/reports/")
        .TemplateUrl("/ReportViewer/templates/telerikReportViewerTemplate.html")
        .ReportSource(report)
        .ViewMode(ViewModes.INTERACTIVE)
        .ScaleMode(ScaleModes.SPECIFIC)
        .Scale(1.0)
        .PersistSession(false)  )
but I am getting     an error in the ReportViewer-8.0.14 file in the throwIfNoReportInstance() function saying the report instance Id is undefined.  I know this is because the report instance is not created, but I am wondering where the report is instantiated at.  Thanks






KS
Top achievements
Rank 1
 answered on 28 Apr 2014
4 answers
152 views
What's the best way of creating a report with a dynamic number of columns?

For an example let's say I need to get the data of a person who has been scored in different subjects and by different scorers.

Subject      Scorer 1 |  Scorer 2 | Scorer 3...
Sub 1              2               3                6
Sub 2              1               4                4
Sub 3              5               3                1
Total                8               10              11
Max score       10            10               12

I do not know at the start how many subjects there will be or how many scorers there will be.  I also need to have each page of the report have a different person's scores on it.

I have tried using a crosstab, but I can't get the crosstab to page break between each person.  Which through some research it doesn't look like it's possible to page break within a crosstab.



Stef
Telerik team
 answered on 28 Apr 2014
2 answers
138 views
Hi,

Can I install Telerik Reporting to a Windows 2012 server?

In the Telerik Reporting download page (http://www.telerik.com/products/reporting/download.aspx) only up to Windows 2008 server is mentioned.

Thanks,
Indrajith
Indrajith
Top achievements
Rank 1
 answered on 27 Apr 2014
1 answer
149 views
Hi,
I try add ReportViewer control to the VisualWebPart.ascx
<%@ Assembly Name="$SharePoint.Project.AssemblyFullName$" %>
<%@ Assembly Name="Microsoft.Web.CommandUI, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>
<%@ Register Tagprefix="SharePoint" Namespace="Microsoft.SharePoint.WebControls" Assembly="Microsoft.SharePoint, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>
<%@ Register Tagprefix="Utilities" Namespace="Microsoft.SharePoint.Utilities" Assembly="Microsoft.SharePoint, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>
<%@ Register Tagprefix="asp" Namespace="System.Web.UI" Assembly="System.Web.Extensions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" %>
<%@ Import Namespace="Microsoft.SharePoint" %>
<%@ Register Tagprefix="WebPartPages" Namespace="Microsoft.SharePoint.WebPartPages" Assembly="Microsoft.SharePoint, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>
<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="VisualWebPart1.ascx.cs" Inherits="testRap.VisualWebPart1.VisualWebPart1" %>

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


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

But when I open project and go to the designer of visual web part, I got message:



"The ReportViewer control failed to setup the http handler in the web.config file. You may experience troubles when viewing the report. Exception details: Object reference not set to an instance of an object."


I added to the C:\inetpub\wwwroot\wss\VirtualDirectories\80\web.config

 <add name="Telerik.ReportViewer.axd_*" path="Telerik.ReportViewer.axd" verb="*" type="Telerik.ReportViewer.WebForms.HttpHandler, Telerik.ReportViewer.WebForms, Version=8.0.14.225, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" preCondition="integratedMode" />  
in tags
 <system.webServer> 
    <handlers>

I have IIS 8.0 and Visual Studio 2012.

Best Regards
Pawel
  
Stef
Telerik team
 answered on 25 Apr 2014
3 answers
109 views
I recently upgraded my project to use Q1 2014 from Q3 2012 .  Ever since, I have been unable to use the arrow keys to position items in the report designer.  (I'm using VS2010.)  I really miss this feature!  Is there something I have to do to enable this?

Thanks
Stef
Telerik team
 answered on 25 Apr 2014
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?