Telerik Forums
Reporting Forum
1 answer
485 views

Dear all,

            When I generate only Export PDF is available. Even I set the config of and to true. Here is my config in web config.

<configSections>
    <section name="Telerik.Reporting" type="Telerik.Reporting.Configuration.ReportingConfigurationSection, Telerik.Reporting, Version=8.2.14.1027, Culture=neutral, PublicKeyToken=A9D7983DFCC261BE" allowLocation="true" allowDefinition="Everywhere" />
  </configSections>

 

<Telerik.Reporting>
<AssemblyReferences>
<add name="BusinessObject.Client" version="1.0.0.0" />
                        <add name="BusinessObject.Client" version="1.0.0.0" />
</AssemblyReferences>
    <Extensions>
      <Render>
        <Extension name="PDF" visible="true"></Extension>
        <Extension name="XLS" visible="false"></Extension>
        <Extension name="CSV" visible="false"></Extension>
        <Extension name="RTF" visible="false"></Extension>
        <Extension name="XPS" visible="false"></Extension>
        <Extension name="DOCX" visible="true"></Extension>
        <Extension name="XLSX" visible="true"></Extension>
        <Extension name="PPTX" visible="false"></Extension>
        <Extension name="MHTML" visible="false"></Extension>
        <Extension name="IMAGE" visible="false"></Extension>
        <Extension name="HTML5" visible="false"></Extension>
        <Extension name="HTML5Interactive" visible="false"></Extension>
      </Render>
    </Extensions>
  </Telerik.Reporting>

 

Silviya
Telerik team
 answered on 11 Sep 2018
1 answer
104 views

We are creating a report using visual studio 2017 for an MVC5 application and want to display the report toolbar for the end user. It works for demo reports but when we create one from scratch, it does not appear. So far we have been able to display the report, but toolbar does not appear. Is there any configuration needed in order to get the required result?

 

 

Claudio
Top achievements
Rank 1
 answered on 10 Sep 2018
5 answers
245 views

I have a table in my report header (since my datasource is bound to the report). The cells in the row of the table all have conditional formatting to give the table a striping effect. The number of columns in the table will differ based on a parameter of the report. However, in the case when I have two of the columns (that are right next to each other) hide at the same time, there is a slight vertical line (maybe 1px?) that appears. Is this a known bug or am I maybe doing something wrong?

I've attached three screenshots:

1. The design mode
2. A correct rendering where the line didn't appear (and no hiding was taking place)
3. An incorrect rendering where the line is appearing (and the hiding is occurring)

I am using conditional formatting to control the visibility of these fields. They are all set to Visible = True and then the conditional formatting sets the visibility through the Layout section.

 

 

Ivan Hristov
Telerik team
 answered on 10 Sep 2018
2 answers
564 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
427 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
712 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
797 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
179 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.1K+ 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
Top users last month
Rob
Top achievements
Rank 3
Iron
Iron
Iron
Atul
Top achievements
Rank 1
Iron
Iron
Iron
Alexander
Top achievements
Rank 1
Veteran
Iron
Serkan
Top achievements
Rank 1
Iron
Shawn
Top achievements
Rank 1
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?