Questions on Reporting Forum

2 answers

787 views

HTML5 viewer, when returning from sub-report, has error creating report, document with ID not found

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:

Open Main Report.
Click to navigate to Sub Report - report displays ok.
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.
Click the HTML5 Viewer's "Refresh" button; report displays ok.
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).

General Discussions

answered on 07 Sep 2018

24 answers

883 views

Asp.Net Core 2.0

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

General Discussions

answered on 05 Sep 2018

1 answer

199 views

Telerik Report showing data but has empty rows when using ObjectDatasource Wizard

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

General Discussions

answered on 05 Sep 2018

1 answer

1.2K+ views

Enable CORS not working

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) 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 End Sub

Controller:

Namespace Controllers <EnableCors("*", "*", "*", "*")> Public Class ReportsController Inherits ReportsControllerBase 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>

General Discussions

answered on 05 Sep 2018

16 answers

1.7K+ views

Merged Columns on Export to Excel

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?

General Discussions

answered on 05 Sep 2018

3 answers

279 views

[Solved] Vertical Alignment - side by side Lists

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.

General Discussions

answered on 04 Sep 2018

3 answers

135 views

Telerik Reports Data Population in Asp.net Core and Telerik Rest Services

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

General Discussions

answered on 03 Sep 2018

2 answers

153 views

[Solved] Grid borders problem with angular report viewer

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.

General Discussions

answered on 03 Sep 2018

2 answers

190 views

[Solved] Dynamic Localization issue

I have an MVC application that needs to allow dynamically changing connection strings and localization. The issue is that after I open up the first report instance, I am still getting the same report even after changing connection strings or the localization. Here is my code:

private ReportServiceConfiguration GetReportServiceConfiguration()

{

var userId = _httpContext.User.FindFirst(ClaimTypes.NameIdentifier);

var connectionString = _configuration.GetConnectionString("db");

var locale = "en";

if (userId != null)

{

var user = _userManager.FindByIdAsync(userId.Value).Result;

var tenantClaim = (_userManager.GetClaimsAsync(user).Result).SingleOrDefault(c => c.Type == "UserTenant");

var localeClaim = (_userManager.GetClaimsAsync(user).Result).SingleOrDefault(c => c.Type == "UserLocale");

if (tenantClaim != null)

{

connectionString = connectionString.Replace("=db", "=" + tenantClaim.Value);

}

if(localeClaim != null)

{

locale = localeClaim.Value;

}

var resolver = new NexcorTypeResolver(connectionString, locale);

return new ReportServiceConfiguration

{

HostAppId = "Test",

Storage = new FileStorage(this.reportsPath),

ReportResolver = resolver,

ReportSharingTimeout = 0,

ClientSessionTimeout = 1

};

}

public class NexcorTypeResolver : IReportResolver { public string _connectionString; public string _locale; public NexcorTypeResolver(string connectionString, string locale) { _connectionString = connectionString; _locale = locale; } public ReportSource Resolve(string report) { var cultureInfo = new System.Globalization.CultureInfo(_locale); System.Threading.Thread.CurrentThread.CurrentUICulture = cultureInfo; System.Threading.Thread.CurrentThread.CurrentCulture = cultureInfo; var connectionStringHandler = new ReportConnectionStringManager(_connectionString); var sourceReportSource = new InstanceReportSource { ReportDocument = new Worksheet() }; var reportSource = connectionStringHandler.UpdateReportSource(sourceReportSource); return reportSource; } }

General Discussions

answered on 31 Aug 2018

1 answer

182 views

Telerik Preview Solution Build Failed

How can i do to build a report from a different version ?

General Discussions

answered on 31 Aug 2018