Telerik Forums
Reporting Forum
2 answers
573 views

Hello,
we've integrated HTML 5 Report Viewer in our solution in a ASP.NET 3.5 Web Site and the Reporting Service is hosted in a separated REST endpoint (.NET 4.6.2) using libraries downloaded from Telerik Private NuGet server.
The REST enpoint implement Basic Authentication with a Bearer token retrieved from an our external REST endpoint.

The report viewer works well with authentication but after Print operation require authentication from the browser.
I see the same behaviour in Google Chrome, Opera.
How can I remove the authentication box for printing report?
Monitoring the HTTP traffic with Fiddler I see that the HTTP request for printing don't pass authentication token as previous calls (Request headers -> Security -> Authorization).

I've tried various configuration for print mode:

  • FORCE_PDF_PLUGIN (as below): Download directly the file and after open it starts the print process.
  • FORCE_PDF_FILE: Show an authentication box in the browser
  • AUTO_SELECT: Show an authentication box in the browser 

The authentication token is retrieved and setted in the Page_Load event in the ASP.NET page that host the HTML 5 Viewer.

01.<script type="text/javascript">
02. 
03.        function onPageReady(e) {
04.            console.log("page ready" + JSON.stringify(e));
05.        }
06. 
07.        function onExportBegin(e) {
08.            console.log("export begin" + JSON.stringify(e));
09.        }
10. 
11.        function onPrintBegin(e) {
12.            console.log("print begin" + JSON.stringify(e));
13.        }
14. 
15.        $(document).ready(function () {
16. 
17.            var reportParams = <%= GetJsonParameters() %>
18. 
19.            $("#reportViewerMain")
20.                .telerik_ReportViewer({
21.                    serviceUrl: "<%= GetUrlReportingApi() %>",
22.                    templateUrl: "<%= GetTemplateUrl() %>",
23.                    authenticationToken: "<%= GetUserToken() %>",
24.                    reportSource: {
25.                        report: "<%= GetIdReport() %>",
26.                        parameters: reportParams
27.                    },
28.                    viewMode: telerikReportViewer.ViewModes.INTERACTIVE,
29.                    scaleMode: telerikReportViewer.ScaleModes.SPECIFIC,
30.                    printMode: telerikReportViewer.PrintModes.FORCE_PDF_PLUGIN,
31.                    scale: 1.0,
32.                    pageReady: onPageReady,
33.                    exportBegin: onExportBegin,
34.                    printBegin: onPrintBegin,
35.                    error: function (e, args) {
36.                        console.error("Report viewer error: " + args);
37.                    }
38.                });
39.            $("#reportViewerMain").height(window.innerHeight);
40.        });
41.    </script>

 

Telerik version: 12.1.18.620 (Runtime: v4.0.30319)

IDE version: Visual Studio 2017 Enterprise version 15.8.2

 

Can you help me?

Thanks.

 Best regards.

 Fabio

 

Davide Coletto
Top achievements
Rank 1
 answered on 10 Sep 2018
1 answer
438 views

Hi All

 

I have a report book that contains only a single report type but multiple instances of it.

Currently when printed out it show one report instance per page, but each report instance can grow/shrink so may not take up an entire page..

Is there a way of (other than using a subreport in a panel) to allow all the reports to squish up together, taking up less pages??

 

Cheers

Ade

Todor
Telerik team
 answered on 10 Sep 2018
2 answers
735 views

I have a Main Report with a cell's interaction being, "Navigate to Report: SubReport." Navigation back and forth works fine in the Stand-alone Report Designer; I'm having a strange issue with the HTML5 Report Viewer that seems to be related to IStorage. Here are my steps:

  1. Open Main Report.
  2. Click to navigate to Sub Report - report displays ok.
  3. Click the "Navigate Backward" arrow of the HTML5 Viewer. Receive error: Error creating report document (Report = Main Report.trdx; Format = HTML5Interactive). Document with ID '170300-8e97' not found.
  4. Click the HTML5 Viewer's "Refresh" button; report displays ok.
  5. Oddly enough, if I now click "Navigate Forward," the Sub Report displays ok.

 Maybe-relevant configuration:

  • This error occurs on both local web server and my single-server Azure deployment.
  • I don't receive any other errors that seem to be IStorage related.
  • I've tried the default FileStorage as well as FileStorage(MapPath("~/App_Data")). If I use Windows Explorer to look in App_Data, I see can see recently-written cachey stuff.
  • I'm using a custom IReportResolver to stream the trdx files from Google Drive, in case that matters.
  • I'm using Telerik Reporting v9.2 trial version (9.2.15.1126, I believe).

 

Arne
Top achievements
Rank 1
 answered on 07 Sep 2018
24 answers
805 views

There is no report designer in my Asp.Net Core 2.0 projekt

 use Visual Studio 2017 ver. 15.3.0 preview 6

When I open a MVC 5 projekt in the same VS there is a designer

Todor
Telerik team
 answered on 05 Sep 2018
1 answer
184 views

Hi,

I'm using a Telerik Report Library class with Visual Studio Report Designer ( Table ) having ObjectDatasource.

While testing it with Dummy Collection its showing Empty rows but the values are not seen in the Report. 

Please let me know what might be the reason.

Attached Screenshot. 

TIA

Todor
Telerik team
 answered on 05 Sep 2018
1 answer
1.2K+ views

I know this question has been posed several times and I have read the solutions and watched the instructional video provided but it is still not working for me.  I must be missing something and am hoping someone can point it out.  Works fine in development when everything is on my machine but when I move the Reporting Service to the server and launch my Angular project with a service url pointing to the Reporting Service on the server, it gives the following error:

Error loading the report viewer's templates. (Template = http://myhost/ReportingSample/api/reports/resources/templates/telerikReportViewerTemplate-html).

and this error in the console: Origin http://localhost:4200 not found in Access-Control-Allow-Origin header. (along with other CORS related errors).

 

 

I have the following in my Global.asax.vb:

Sub Application_Start(ByVal sender As Object, ByVal e As EventArgs)<br>        System.Web.Http.GlobalConfiguration.Configuration.EnableCors<br>        Telerik.Reporting.Services.WebApi.ReportsControllerConfiguration.RegisterRoutes(System.Web.Http.GlobalConfiguration.Configuration)<br>        ' Fires when the application is started<br>    End Sub

 

Controller:

Namespace Controllers<br>    <br>    <EnableCors("*", "*", "*", "*")><br>    Public Class ReportsController<br>        Inherits ReportsControllerBase<br>        Shared configurationInstance As Telerik.Reporting.Services.ReportServiceConfiguration...

 

Web.config:

<runtime>
   <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
     <dependentAssembly>
       <assemblyIdentity name="Newtonsoft.Json" publicKeyToken="30ad4fe6b2a6aeed" culture="neutral" />
       <bindingRedirect oldVersion="0.0.0.0-11.0.0.0" newVersion="11.0.0.0" />
     </dependentAssembly>
     <dependentAssembly>
       <assemblyIdentity name="System.Web.Http" publicKeyToken="31bf3856ad364e35" culture="neutral" />
       <bindingRedirect oldVersion="0.0.0.0-5.2.6.0" newVersion="5.2.6.0" />
     </dependentAssembly>
     <dependentAssembly>
       <assemblyIdentity name="System.Net.Http.Formatting" publicKeyToken="31bf3856ad364e35" culture="neutral" />
       <bindingRedirect oldVersion="0.0.0.0-5.2.6.0" newVersion="5.2.6.0" />
     </dependentAssembly>
     <dependentAssembly>
       <assemblyIdentity name="DocumentFormat.OpenXml" publicKeyToken="8fb06cb64d019a17" culture="neutral" />
       <bindingRedirect oldVersion="0.0.0.0-2.8.1.0" newVersion="2.8.1.0" />
     </dependentAssembly>
     <dependentAssembly>
       <assemblyIdentity name="System.Net.Http" publicKeyToken="b03f5f7f11d50a3a" culture="neutral" />
       <bindingRedirect oldVersion="0.0.0.0-4.1.1.0" newVersion="4.1.1.0" />
     </dependentAssembly>
     <dependentAssembly>
       <assemblyIdentity name="System.Diagnostics.DiagnosticSource" publicKeyToken="cc7b13ffcd2ddd51" culture="neutral" />
       <bindingRedirect oldVersion="0.0.0.0-4.0.1.0" newVersion="4.0.1.0" />
     </dependentAssembly>
     <dependentAssembly>
       <assemblyIdentity name="System.Net.Http" culture="neutral" publicKeyToken="31BF3856AD364E35" />
       <bindingRedirect oldVersion="0.0.0.0-65535.65535.65535.65535" newVersion="4.1.1.0" />
     </dependentAssembly>
     <dependentAssembly>
       <assemblyIdentity name="System.Net.Http.WebRequest" culture="neutral" publicKeyToken="31BF3856AD364E35" />
       <bindingRedirect oldVersion="0.0.0.0-65535.65535.65535.65535" newVersion="4.0.0.0" />
     </dependentAssembly>
     <dependentAssembly>
       <assemblyIdentity name="System.Net.Http.Formatting" culture="neutral" publicKeyToken="31BF3856AD364E35" />
       <bindingRedirect oldVersion="0.0.0.0-65535.65535.65535.65535" newVersion="5.2.6.0" />
     </dependentAssembly>
     <dependentAssembly>
       <assemblyIdentity name="System.Web.Http" culture="neutral" publicKeyToken="31BF3856AD364E35" />
       <bindingRedirect oldVersion="0.0.0.0-65535.65535.65535.65535" newVersion="5.2.6.0" />
     </dependentAssembly>
     <dependentAssembly>
       <assemblyIdentity name="System.Web.Http.WebHost" culture="neutral" publicKeyToken="31BF3856AD364E35" />
       <bindingRedirect oldVersion="0.0.0.0-65535.65535.65535.65535" newVersion="5.2.6.0" />
     </dependentAssembly>
   </assemblyBinding>
 </runtime>
 <system.webServer>
   <handlers>
     <remove name="ExtensionlessUrlHandler-ISAPI-4.0_32bit" />
     <remove name="ExtensionlessUrlHandler-ISAPI-4.0_64bit" />
     <remove name="ExtensionlessUrlHandler-Integrated-4.0" />
     <add name="ExtensionlessUrlHandler-ISAPI-4.0_32bit" path="*." verb="GET,HEAD,POST,DEBUG,PUT,DELETE,PATCH,OPTIONS" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework\v4.0.30319\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv4.0,bitness32" responseBufferLimit="0" />
     <add name="ExtensionlessUrlHandler-ISAPI-4.0_64bit" path="*." verb="GET,HEAD,POST,DEBUG,PUT,DELETE,PATCH,OPTIONS" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework64\v4.0.30319\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv4.0,bitness64" responseBufferLimit="0" />
     <add name="ExtensionlessUrlHandler-Integrated-4.0" path="*." verb="GET,HEAD,POST,DEBUG,PUT,DELETE,PATCH,OPTIONS" type="System.Web.Handlers.TransferRequestHandler" preCondition="integratedMode,runtimeVersionv4.0" />
   </handlers>
 </system.webServer>

 

 

Todor
Telerik team
 answered on 05 Sep 2018
16 answers
1.6K+ views
The attached screenshots show a Telerik report (Q3 2011) containing a table with several columns.  When I run the report and export it to Excel, the Category column ends up in merged columns L and M in Excel.  As you can see in the screenshots, the report contains no objects above or below the table in the area where the merged cells are showing up.  The report is set to Landscape orientation, and the merged cells are showing up between the 8-9 inch mark on the page.  I have also confirmed that there are no objects hiding behind the table that could be causing the issue.  I have replicated this same issue on other reports containing tables as well, but also have similar reports with table where the issue doesn't occur at all.  So I have been unable to pinpoint a pattern in any way.  I have also tried resizing the columns in various ways, but always end up with merged cells in that same area, sometime occurring for the MakeModel field instead of Category.

Any idea what might be causing these merged cells to show up when exporting this report to Excel?
Todor
Telerik team
 answered on 05 Sep 2018
3 answers
262 views

I have two lists in a panel next to each other, they are the only items on the report. I am trying to give the appearance of the List items flowing up instead of down. 

 

Example layout

4                                    3

3                                    2

2                                    1

1                                       

ORDER                         ORDER

 

I am trying to get the list on the right to have its list items stick to the bottom of the list. Note: I can get the desired functionality if I take the two lists and put them on different 'lines' on the report. Like this:

 

4                                   
3                                   
2                                   
1                                       
ORDER                   

3

2

1

ORDER 

It looks like the list height is tied together somehow if they are aligned next to each other. Is there anyway to have these work independently? Can anyone explain why this occurs? If you need screenshots I will oblige. 

 

 

Russell
Top achievements
Rank 1
 answered on 04 Sep 2018
3 answers
119 views

Hi,

Environment : 

Separate Telerik Report Service App ( targets - 461  Contains Reports ( TRDP) designed in Data Access / Web API consumed 

Web Client App ( currently targetting core 2.1 ) : Contains Views to display reports Reportviewer ( HTML5) ( Report related template/ JS/ etc) 

Now, the question is how to data in the Report Restful Services app using business objects ( say a collection of strongly  typed objects  ) 

where I'm going to set the etc..since its designed in a Standalone designer tool and how to achieve the dynamic binding of data when the criteria/parameters are set from the Web client app which is separately hosted.

Appreciate few insights on these

 

TIA 

Joe

Todor
Telerik team
 answered on 03 Sep 2018
2 answers
133 views

Hello

I'm having a problem when displaying report in angular report viewer. Preview in Report designer and export to PDF option from the viewer are displaying grid correctly. See attached images. I set border width to 1px instead of 1ptas mentioned in similar thread here on the reporting forums but to no avail.

 

Thanks in advance.

Ivan
Top achievements
Rank 1
 answered on 03 Sep 2018
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
Iron
Iron
Andrey
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?