Questions on Reporting Forum

1 answer

191 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

271 views

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

123 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

142 views

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

176 views

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

172 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

1 answer

118 views

HTML5 Report Viewer Webpack Example - No Angular

Are there any samples to accomplish this without Angular? My project is already setup to use kendo.ui and webpack.

General Discussions

answered on 29 Aug 2018

1 answer

460 views

WPF Report Viewer wont work!

Dear Sir/Madam,

4 hours search, downloading, trying and can't find the solution to make WPF report viewer works with the latest Telerik version of WPF and Reporting

Framework: 4.7.1

Telerik WPF version: 2018.2.620.45

Telerki Report Version: 12.1.18.620

Basically, New Blank telerik WPF Project -> All references are added -> Version 2018.2.620.45 (tried both, xaml and noxaml)

- Now Add Telerik Report R2 2018 (Blank)

- Then Add Telerik Report Viewer Window R2 2018

- Select Embedded, Existing Report definition, Type Report Definition, (wait for build to done) -> Report1

- Finish: In the Log page got this error:

Error: Fail to add project reference System.Runtime.InteropServices.COMException (0x80004005): Adding 'TelerikWpfApp6' as a project-to-project reference would cause this project to reference itself. at VSLangProj.References.AddProject(Project pProject) at Telerik.Reporting.Vs.Common.ProjectManager.TryAddProjectReference(Project projectToReference)

and when I run the project i got:

System.Windows.Markup.XamlParseException: ''Set property 'System.Windows.ResourceDictionary.Source' threw an exception.' Line number '65' and line position '10'.'

FileNotFoundException: Could not load file or assembly 'Telerik.ReportViewer.Wpf.Themes, Culture=neutral' or one of its dependencies. The system cannot find the file specified.

While Telerik.ReportViewer.Wpf.Themes is in the reference.

Many thanks.

General Discussions

answered on 29 Aug 2018