Telerik Forums
Reporting Forum
2 answers
131 views

I'm in the process of trying out Telerik and I'm experiencing the following error in the Standalone Report Designer.

System.NullReferenceException: Object reference not set to an instance of an object.  See attached picture for full error message.

Here are my steps to reproduce:

1. Create a blank project.

2. Insert a List to the Details section.

3. Insert an HTML Text Box to the List's Panel

I can add Text Box, Barcode, PictureBox with no problems.

 

Thanks!

Salvatore
Top achievements
Rank 1
 answered on 20 Jan 2019
1 answer
391 views

Hello,

We are using Telerik.Reporting in one of our products. I've checked that Telerik.Reporting.dll uses SQLite internally.

May I ask what version of SQLite is being used on Telerik version 10.0.16.113?

Looking forward to your prompt response.

Thanks,

Mark

Patrick | Technical Support Engineer, Senior
Telerik team
 answered on 18 Jan 2019
6 answers
464 views

I am looking for a safe way to determine if a Telerik report file was modified by us or replaced by a custom version our client made.
I was hoping to simply apply a code-signing certificate to the report file, but that does not appear to work.

The idea is that if someone were to modify the file, it would strip out our protection which we could then detect.

We do not want to prevent end users from modifying the report file to create their own report, but they would need to set it up as a custom report in our system.
This means that a simple password on the file would not work as the end user would need to know it to modify the report file and therefore could pretend that their modified version is ours.

I wish to eliminate the possibility of tech support calls due to issues with their customized file that we mistakenly believe is ours.

I look forward to hearing from you.

Mark
Top achievements
Rank 1
 answered on 18 Jan 2019
2 answers
511 views
Hi Team,

greetings from our end. the tool is performing absolutely awesome. but we got stuck up with critical requirement. before this let me tell you, we are strictly following the following url in our implementation.
http://www.telerik.com/help/reporting/graphhowtocreateprogrammaticallygraph.html


the requirement says:
we need to set standard colors (black, white, green, red, orange, gray, .. ) for each bar we have under one and only 1 series and the color for each bar is to be defined based on dynamically mapped ProductCategoryGroup field ProductCategory from the above url.

for eg:-
product category is Bikes we need to have orange. 
product category is automobiles we need to have grey.

Now, the data source is not always loaded with same product categories list. we make load bikes, automobiles, etc:- or bikes alone or automobiles or different combination list.




Theo
Top achievements
Rank 2
 answered on 18 Jan 2019
3 answers
320 views
I've just moved back over to using the report viewer for HTML5 in order to use the interactive feature and have a Document map for my reports.  I have received push back from my QA people that we are going to lose our infinite scrolling feature.  When doing research I came across this article:​ http://www.telerik.com/forums/infinite-scroll

which suggests that by now the HTML5 ReportViewer should have infinite/continuous scrolling.  I have not been able to find this setting, and would like some help in locating it please.

For reference if needed, I am using the jQuery.fn.telerik method to spin up a report viewer on div creation like so.

$('mydiv''))
.telerik_ReportViewer({
serviceUrl: "/../api/reports/",
templateUrl: '/.../ReportViewerTemplate.html',
reportSource: { report: parameters },
viewMode: telerikReportViewer.ViewModes.INTERACTIVE,
scaleMode: telerikReportViewer.ScaleModes.SPECIFIC,
scale: 1.0
});

,
Veronika
Telerik team
 answered on 17 Jan 2019
3 answers
389 views

We have a few reports implemented to work with old ASP.NET Web Forms. Recently we moved to Angular 5 + Asp.Net Web API.
The distinctive feature of those report is the dynamic design based on the data evaluated as a DataSource for that report. 

The OLD (web forms) implementation follows steps below:
We have several business entities. As a first step we get the data related to those entities:

var reportData = ReportsUtility.GetReportData(reportParameters);

After that we create an Instance Report Source:

var reportSource = ReportsUtility.GetInstanceReportSource(reportData);


GetInstanceReportSource(..)
method implementation detail.
Create a report book:

var reportBook =  new ReportBook();

For each of entities based on data obtained we create specific report instance and transfer the data into it and than attach the report to a report work book:

foreach (var entityData in reportData)
{
    var specificReport = new SpecificReport(entityData);
    reportBook.Reports.Add(specificReport);
}

Return newly created Instance Report Source:

return new InstanceReportSource {ReportDocument = reportBook};

 

Finally we assign the report source to a report viewer control

New back-end (Restful Service) implementation via CustomResolver is the following:

public class CustomReportResolver : IReportResolver
    {
        public ReportSource Resolve(string reportJSON)
        {
            var response = new InstanceReportSource();
            var reportParameters = JsonConvert.DeserializeObject<ReportRequestDto>(reportJSON);
            if (null == reportJSON) return response;

            var reportData = ReportsUtility.GetReportData(reportParameters);
            response = ReportsUtility.GetInstanceReportSource(reportData);

            return response;
        }
    }


Everything works smoothly but as per Angular Telerik Report Viewer client lifecycle there are several calls to a back-end service:
GetParameters, CreateInstance, GetDocument ... and each of them internally invokes CustomResolver.Resolve(...) which causes data for the report evaluated several times.

So my question is there is a standard sensibility point or a simple workaround on how to set up DataSource for the report viewer once or at lease during some specific stage?

Viacheslav
Top achievements
Rank 1
 answered on 15 Jan 2019
2 answers
350 views

I noticed that the Export functionality is not working in Angular Report Viewer at all for all reports. I got the below exception in the browser If I click on any export button.

ERROR Error: Uncaught (in promise): TypeError: Illegal invocation
TypeError: Illegal invocation
    at zone.js:2984
    at proto.(anonymous function) (http://service-url:12334/polyfills.4dc437127b0fb9a93699.js:9074:24)
    at telerikReportViewer.js:1680
    at ZoneDelegate.push../node_modules/zone.js/dist/zone.js.ZoneDelegate.invoke (zone.js:388)
    at Object.onInvoke (core.js:16156)
    at ZoneDelegate.push../node_modules/zone.js/dist/zone.js.ZoneDelegate.invoke (zone.js:387)
    at Zone.push../node_modules/zone.js/dist/zone.js.Zone.run (zone.js:138)
    at zone.js:872
    at ZoneDelegate.push../node_modules/zone.js/dist/zone.js.ZoneDelegate.invokeTask (zone.js:421)
    at Object.onInvokeTask (core.js:16147)
    at resolvePromise (zone.js:814)
    at zone.js:877
    at ZoneDelegate.push../node_modules/zone.js/dist/zone.js.ZoneDelegate.invokeTask (zone.js:421)
    at Object.onInvokeTask (core.js:16147)
    at ZoneDelegate.push../node_modules/zone.js/dist/zone.js.ZoneDelegate.invokeTask (zone.js:420)
    at Zone.push../node_modules/zone.js/dist/zone.js.Zone.runTask (zone.js:188)
    at drainMicroTaskQueue (zone.js:595)
    at ZoneTask.push../node_modules/zone.js/dist/zone.js.ZoneTask.invokeTask [as invoke] (zone.js:500)
    at invokeTask (zone.js:1540)
    at XMLHttpRequest.globalZoneAwareCallback (zone.js:1566)

These are my packages related to the topic

"@agm/core": "1.0.0-beta.5",
"@angular/animations": "7.1.3",
"@angular/cdk": "7.1.1",
"@angular/common": "7.1.3",
"@angular/compiler": "7.1.3",
"@angular/core": "7.1.3",
"@angular/http": "7.1.3",
"@angular/platform-browser": "7.1.3",
"@angular/platform-browser-dynamic": "7.1.3",
"@angular/router": "7.1.3",
"@progress/kendo-angular-charts": "3.5.0",
"@progress/kendo-angular-intl": "1.6.0",
"@progress/kendo-angular-l10n": "1.3.0",
"@progress/kendo-angular-upload": "^4.2.2",
"@progress/kendo-drawing": "1.5.7",
"@progress/kendo-theme-material": "1.5.0",
"@progress/telerik-angular-report-viewer": "5.18.1129",
"@swimlane/ngx-datatable": "14.0.0",
"jquery": "3.2.1",
"kendo-ui-core": "2018.3.1107",
"npm": "6.5.0",
"rxjs": "6.2.1",
"rxjs-compat": "^6.0.0",
"zone.js": "0.8.26"

 

 

"@angular/cli": "7.1.3",

"typescript": "3.1.6",

"@angular-devkit/build-angular": "~0.11.0",
"@angular-devkit/core": "0.7.4",
"@angular-devkit/schematics": "0.7.4",
"@angular/cli": "7.1.3",
"@angular/compiler-cli": "7.1.3",
"@angular/language-service": "7.1.3",

Thanks,

Kanoo
Top achievements
Rank 1
 answered on 15 Jan 2019
7 answers
742 views

I have a working Silverlight web app using telerik reports. I moved it to a new server and now I get the error below.  The production web site runs on the same box as the sql server that is providing the data. At first I thought it was the connection string because there was an error in it, but I corrected that and can run the report from the dev machine using that connection string. I have ensured that the deployed application is in sync with the dev box – all files are identical.

I put logging code in the data class  for the objectdatasource that the report engine uses to retrieve data from the database and that code is never run, so it looks like the error is happening on the server somewhere after the ReportService.svc and before the telerik reports use the objectdatasource to retrieve records.

An identical deploy (with a different connection string) to a different server last week works just fine. I would think there is a file missing or an old version somewhere causing the problem but the only critical files outside of telerik are the Silverlight xap file which sets the .Report property of the ReportViewer and the DLL with the report designers and data class, and both of these files are correct and up to date, and both work from the dev box using the same connection string that points to a remote sql server.  I can preview the report from the dev box and run the application and view the reports.

So can you tell me what this error means? What is NotFound? The db server? The designer class?

To me it looks like a connection string error message – it could not find the db server, but that is very unlikely.  Is there a way to trace this out on the server?

Error: System.Reflection.TargetInvocationException : An exception occurred during the operation, making the result invalid.  Check InnerException for exception details.
   at System.ComponentModel.AsyncCompletedEventArgs.RaiseExceptionIfNecessary()
   at Telerik.Reporting.Service.SilverlightClient.RenderAndCacheEventArgs.get_RenderingResult()
   at Telerik.ReportViewer.Silverlight.ReportViewerModel.OnRenderAndCacheCompleted(Object sender, RenderAndCacheEventArgs e)

------------- InnerException: -------------

System.ServiceModel.CommunicationException : The remote server returned an error: NotFound.
   at System.ServiceModel.Channels.Remoting.RealProxy.Invoke(Object[] args)
   at proxy_2.EndRenderAndCache(IAsyncResult )
   at Telerik.Reporting.Service.SilverlightClient.ReportServiceClient.OnEndRenderAndCache(IAsyncResult result)
   at System.ServiceModel.ClientBase`1.OnAsyncCallCompleted(IAsyncResult result)

------------- InnerException: -------------

System.Net.WebException : The remote server returned an error: NotFound.
   at System.Net.Browser.AsyncHelper.BeginOnUI(SendOrPostCallback beginMethod, Object state)
   at System.Net.Browser.BrowserHttpWebRequest.EndGetResponse(IAsyncResult asyncResult)
   at System.ServiceModel.Channels.HttpChannelFactory.HttpRequestChannel.HttpChannelAsyncRequest.CompleteGetResponse(IAsyncResult result)

------------- InnerException: -------------

System.Net.WebException : The remote server returned an error: NotFound.
   at System.Net.Browser.BrowserHttpWebRequest.InternalEndGetResponse(IAsyncResult asyncResult)
   at System.Net.Browser.BrowserHttpWebRequest.<>c__DisplayClassa.<EndGetResponse>b__9(Object sendState)
   at System.Net.Browser.AsyncHelper.<>c__DisplayClass4.<BeginOnUI>b__0(Object sendState)

Silviya
Telerik team
 answered on 15 Jan 2019
3 answers
314 views

Hi all,

I'm new to Telerik Reporting so forgive me for my ignorance. I read this article about using SQL parameters in a report: 

https://docs.telerik.com/reporting/sql-data-source-using-parameters

But I can't get it to work and I'm wondering what I'm doing wrong. I have a simple query that looks something like this:

<p>"SELECT order_date, order_cost, order_customer</p><p>FROM orders</p><p>WHERE order_date = @OrderDate"</p>

And I set the Parameter in the database connection Name: @OrderDate; Db Type: Date; Value: = Parameters.Order_Date.Value

In the report, I created one ReportParameter, and I called it "Order_Date". It is set to AutoRefresh: True; Type: DateTime; Value: 1/6/2019; Visible: True.

When I try to execute the query from within the SQL box where I enter the parameter information, it works. But when I try to Preview the report, the wheel just turns forever and nothing ever displays and I get no error. Can someone help me figure out what I'm doing wrong? 

Silviya
Telerik team
 answered on 15 Jan 2019
0 answers
188 views

In my report, I use cross table to show my data. I set keep together to false in order to show the data to the bottom of the page. but there is no bottom line of text box (see attachment 2.png). I want to show the data like 1.png. now I add a text box in page footer, but this report is a sub report in a big report. I can not use this method to show the bottom line. how can I get it.

 

 

Vincent
Top achievements
Rank 1
Iron
 asked on 13 Jan 2019
Top users last month
Edmond
Top achievements
Rank 1
Iron
fabrizio
Top achievements
Rank 2
Iron
Veteran
RobMarz
Top achievements
Rank 2
Iron
Fakhrul
Top achievements
Rank 1
Iron
Tejas
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?