Telerik Forums
Reporting Forum
5 answers
867 views

Hi,

I'm trying to integrate reporting rest service to Winforms Report Viewer

I'm getting the below error during report rendering

An exception has occurred while processing 'table1' item:

System.InvalidOperationException: The data provider of type 'Telerik.Reporting.Processing.WebServiceDataSource.WebServiceDataProvider, Telerik.Reporting.WebServiceDataSource, Version=13.0.19.116, Culture=neutral, PublicKeyToken=a9d7983dfcc261be' defined for data sources of type 'Telerik.Reporting.WebServiceDataSource' cannot be resolved. Are you missing an assembly reference?
   at Telerik.Reporting.Processing.Data.DataProviderFactory.ResolveDataProviderType(Object component, Type baseType, IDataProviderContext dataProviderContext)
   at Telerik.Reporting.Processing.Data.DataProviderFactory.GetDataProviderTypeCached(IDataSource component, IDataProviderContext dataProviderContext)
   at Telerik.Reporting.Processing.Data.DataProviderFactory.Telerik.Reporting.Processing.Data.IDataProviderFactory.Create(IDataSource definition, Object expressionContext, IDataProviderContext dataProviderContext)
   at Telerik.Reporting.Processing.Data.MultidimentionalDataProvider.Execute(MultidimensionalQuery query)
   at Telerik.Reporting.Processing.DataItemResolveDataAlgorithm.GetDataCore(IDataSource dataSource, MultidimensionalQuery query, IServiceProvider serviceProvider, EvalObject expressionContext, IProcessingContext processingContext)
   at Telerik.Reporting.Processing.DataItem.GetDataCore(IDataSource dataSource, MultidimensionalQuery query)
   at Telerik.Reporting.Processing.DataItem.<>c__DisplayClass1.<ResolveData>b__0()
   at Telerik.Reporting.Processing.DataItemResolveDataAlgorithm.ResolveData(String processingId, InMemoryState inMemoryState, MultidimensionalQuery query, Func`1 getDataCore, EvalObject expressionContext)
   at Telerik.Reporting.Processing.DataItem.ResolveData()
   at Telerik.Reporting.Processing.DataItem.ProcessItem()
   at Telerik.Reporting.Processing.Table.ProcessItem()
   at Telerik.Reporting.Processing.ReportItemBase.ProcessElement()
   at Telerik.Reporting.Processing.DataItem.ProcessElement()
   at Telerik.Reporting.Processing.ProcessingElement.Process(IDataMember dataContext)

 

Upon looking into this further i was unable to find the namespace Telerik.Reporting.Processing.WebServiceDataSource.WebServiceDataProvider

Some help would be appreciated

 

ReportsController Code

public class ReportsController : ReportsControllerBase
    {
        protected override Telerik.Reporting.Services.Engine.IReportResolver CreateReportResolver()
        {
            return new ProductReportResolver();
        }

        protected override Telerik.Reporting.Cache.Interfaces.ICache CreateCache()
        {
            return Telerik.Reporting.Services.Engine.CacheFactory.CreateFileCache();
        }

        [HttpPost]
        [ActionName("Parameters")]
        public override HttpResponseMessage GetParameters(string clientID, ClientReportSource reportSource)
        {
            try
            {
                return base.GetParameters(clientID, reportSource);
            }
            catch (Exception ex)
            {
                return null;
            }
        }

        [ActionName("DocumentResources")]
        [HttpGet]
        public override HttpResponseMessage GetResource(string clientID, string instanceID, string documentID, string resourceID)
        {
            try
            {
                return base.GetResource(clientID, instanceID, documentID, resourceID);
            }
            catch (Exception ex)
            {
                return null;
            }
        }

        protected override HttpStatusCode SendMailMessage(MailMessage mailMessage)
        {
            return HttpStatusCode.OK;
        }
    }

 

 

 

 

Silviya
Telerik team
 answered on 05 Aug 2019
1 answer
362 views

Hi, 

I use html reporting and I need to have a filter like this in photo attached, where I can filter through a text. How can I do this from designer?

 

Best regards

 

 

Silviya
Telerik team
 answered on 05 Aug 2019
10 answers
408 views
I have a report viewer in reportviewer.aspx. After I generated the report, I chose Excel format and click Export. I found that in backend, when I press the export button, it goes to load the data again and it make export take 20 minutes or more. I am doubting whether the export is just dumping the already generated report content or will load the functions and do the calculation once again. How can I avoid the export to do the calculation again but just dumping the already generated report?
Neli
Telerik team
 answered on 02 Aug 2019
1 answer
293 views

What do mean with CALs in Telerik Report Server licence?

 

Is it number of application that will use this server?

or number of actual users they have permission to access reports through this server?

 

for example, If I have an angular application and an asp.net application.

These two applications will use Telerik Report Server

In this case, do I have two CALs?

or

If I have 10 users access reports through these tow applications. so I have 10 CALs?

 

Which is right?

Number of applications?

or

Number of actual users regardless of number of applications?

Neli
Telerik team
 answered on 02 Aug 2019
1 answer
299 views
In my report I have two datasource.  In this case the first is the data (detail) and the second is another query that brings a single line that I need to show in the header.  Is there any way to make a textbox display this information?
Ivan Hristov
Telerik team
 answered on 02 Aug 2019
1 answer
631 views

I have an application that has an angular 6 client with telerik reporting viewer,and C# api server.
I have created a report with the report designer. the report has 2 dateTime parameters defined like in the snapshot: 
Now, I use it in the web service data source like on the other  snapshot

So far so good.
I update the parameters value from my clients this way:
let rs =

{

report: this.reportName,

authenticationToken: token,

parametersAreaVisible: true,

parameters: {

     networkItemsKeys: JSON.stringify(parameters.tags),

     token: token, userName:this.userName,

     toDate: parameters.toDate,

     fromDate: parameters.fromDate } }

      as unknown as JSON;

      this.reportSource = rs; this.reportViewer.setReportSource(rs);

    parameters.toDate is DateTime property. 
I can see that the date parameters are updated fine when looking at a textbox defined this way:
Report Period: {Parameters.fromDate.Value.toShortDateString()}-{Parameters.toDate.Value.toShortDateString()}
The problem is that when I check the value that is received in my web api has month and days switched so if the day is greater than 12 the parameter value is 1/1/0001. I have tried all sorts of datepipe format changes, with no success.
The problem is solved when I use the toDate and fromDate as string parameters, but is seems like a stupid solution, and that way I can't use the date type abilities like .toShortDateString() in the text box. Any ideas?
TX Tal

Nasko
Telerik team
 answered on 02 Aug 2019
1 answer
235 views

I am currently trying to add the HTML5 ReportViewer to a .ascx page, which will then be toggled on a .aspx page as to whether be displayed or not.

I'm using an asp:Placeholder on the .aspx page and adding the User Control to it on a button click. The user control renders the text I have on the page, but looking at the Chrome console, I just see the attached blank ReportViewer.

I've added the Assembly Registers to both the .aspx and .ascx page along with the required Kendo scripts/ stylesheets.

I'm not sure what I'm missing, is this even possible to do?

 

Neli
Telerik team
 answered on 31 Jul 2019
4 answers
876 views
I am running a Build on my company's Team Foundation Service for a Class Project that contains Telerik reports. The Class project is added to our websites and the reports are used for various things. When I build in Visual Studio, it works fine and syncs fine with TFS


After I sync into TFS and try to run a build on the Class project, I keep getting the following error for each Telerik Report:

C:\a\src\iLEVELClass\iLEVELClass\Reports\ReportEmployee.resx (123): Invalid Resx file. Type Telerik.Reporting.Drawing.Unit, Telerik.Reporting, Version=8.0.14.507, Culture=neutral, PublicKeyToken=a9d7983dfcc261be in the data at line 121, position 4 cannot be located. Line 123, position 5.

Any ideas on how to get a successful build?
Todor
Telerik team
 answered on 31 Jul 2019
1 answer
262 views

I am trying to get the MVC Report Viewer working with my project.

I am seeing the following errors in the browser:

http://localhost:3032/api/reports/resources/js/telerikReportViewer net::ERR_ABORTED 404 (Not Found)

Uncaught TypeError: jQuery(...).telerik_ReportViewer is not a function
    at HTMLDocument.<anonymous> (SalesReportViewer:37)
    at l (jquery-3.3.1.min.js:2)
    at c (jquery-3.3.1.min.js:2)

I can confirm that this URL works:  http://localhost:3032/api/reports

[{"name":"PDF","localizedName":"Acrobat (PDF) file"},{"name":"CSV","localizedName":"CSV (comma delimited)"},{"name":"XLS","localizedName":"Excel 97-2003"},{"name":"RTF","localizedName":"Rich Text Format"},{"name":"IMAGE","localizedName":"TIFF file"},{"name":"MHTML","localizedName":"Web Archive"},{"name":"XPS","localizedName":"XPS Document"}]

But this does not: http://localhost:3032/api/reports/formats

The ReportViewer folder in my project is empty should it be populated?

The Example Telerik Reporting project works and the MVC ReportViewer shows as expected.    However, I can't figure out what might be missing from my project.   I reviewed a number of your instruction pages but have not found the proper solution.

Any guidance you can provide would be great.   Thanks

Peter

Peter
Top achievements
Rank 1
Iron
 answered on 30 Jul 2019
11 answers
615 views

Hi sir,

 

 

                  I am using telerik report viewer in  that we need to export the report to excel with new version. how can i change this as show in below screenshot.

http://prntscr.com/o1oehl

 

i use this version for the Telerik.ReportViewer.WebForms.dll as show below screenshot.

 

http://prntscr.com/o1odsx

 

 

 

 

 

Todor
Telerik team
 answered on 30 Jul 2019
Top users last month
Ambisoft
Top achievements
Rank 2
Iron
Pascal
Top achievements
Rank 2
Iron
Matthew
Top achievements
Rank 1
Sergii
Top achievements
Rank 1
Andrey
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?