Questions on Reporting Forum

3 answers

116 views

Passing a value from the report viewer to the report

Hello

I would like to pass a value from the report viewer to the report (ex: my application user's name)

I can do this by adding a parameter but in this case I must add the parameter in the data retrieval method while I do not need it in this contex; and since I have a number of such values to be passed it is not a very practical solution.

Is there another mechanisms ?

From what I have read it seems possible to use the useridentity, but have not found how to use it ...

or there may be another (simple) mechanism ...

General Discussions

answered on 10 Feb 2021

1 answer

188 views

Rich Text Control on Reports

I attended a recent release webinar and they discussed the rich text control. I asked if this control can be put on a report and was told yes. The moderator sent a link (https://docs.telerik.com/devtools/xamarin/controls/richtexteditor/richtexteditor-overview) but I don't see any information on how to add the control to a report.

Looking at the toolbar for the designer, I also don't see how to add the control.

Did the moderator mis-speak?

Thanks,

Ken

Report Designer (standalone)

answered on 10 Feb 2021

5 answers

1.3K+ views

Show a field in detail section once per page

I have a report with one grouping. In the detail section of this grouping there can be so many rows that it can take multiple pages to show. In the detail section, I have one field being displayed on the far left that is returned from the database and i put in logic to only show this field once per group. Otherwise, it would show the exact same text for each row in the grouping. The problem comes in when the data carries over to a new page and there is nothing shown in this one column. I'd like to see the value that's shown on the first page, but with a (cont.) label next to it.

So the first page would have something like Breakfast and then the second page would have Breakfast (cont) on it. Any ideas on how to achieve this?

General Discussions

answered on 09 Feb 2021

2 answers

1.2K+ views

ReportViewer is not showing up on Visual Studio 2019

Hi,

I am using Telerik on trial as of now. And I am trying to implement Telerik Report Viewer using HTML 5 and JavaScript so that we could view the created reports on Telerik Reporting Server.

But, despite various blogs on Telerik tells that it can be added by clicking on 'Telerik HTML5 Report Viewer Page' in visual studio,

I am not getting the template option only. This I am not able to understand why. I have download and installed Telerik through TelerikReportingSetup.exe.

Please help me in this. I don't see indendent ReportViewer component in telerik available components when I use TelerikReportingSetup.exe to download Telerik on to my system.

General Discussions

answered on 09 Feb 2021

1 answer

220 views

ReportViewer is not showing up on Visual Studio 2019

Hi

I am using trail version of Telerik as of now. But as mentioned in several blogs of Telerik, I am not able to view ReportViewer as independent option in Visual studio after installing all the needed components. I didn't see any independent option of ReportViewer while installing components using TelerikReportingEngine.exe

I am trying to create Report Viewer using html and JavaScript on an dotnet core project,so that using that ReportViewer we could visualise the report created on Telerik Reporting Server.

Please help me in this, and let me know what mistake I am making.

Thanks

General Discussions

answered on 09 Feb 2021

1 answer

395 views

Tooltips in the exported PDF

Hi,

The Telerik HTML5 report viewer has tooltips in the Chart. This works fine in the viewer. After I export the report to PDF the tooltips are not displaying in the PDF document when I hoover my mouse. Is it possible to do? I am aware about the "ViewerRenderToolTips" but I have not found any example how to use it. Could you please help?

Thanks.

General Discussions

answered on 09 Feb 2021

1 answer

166 views

Report to be Saved in 2 formats

I have a .net app which uses Telerik Reporting to render a report produced in the Standalone Report Designer, it has a number of data sources and the running of those data sources takes 2-3 minutes. The data source is SQL server.

When running the report in the Report Designer all works well.

In the .net app I need to save the report as an image, so I can place it in an email as a summary but then I also want to save as an XLSX spreadsheet and attach that spreadsheet, after adding a lot more data, pivot tables etc the e-mail.

So currently I'm rendering the report twice, the first which is rendered to XLSX format and then again as JPEG file.

So the data is being extracted from SQL twice, once with each render so it doubles the time taken and also the load on SQL.

Is there a way to generate the report and then export that report as XLSX file and then again as a JPEG?

Report Designer (standalone)

answered on 08 Feb 2021

2 answers

172 views

WMF files

Hi, I have a reporting with a picturebox. In the properties box set the value to C:\fotos\imge1.wmf and can see the wmf in the picturebox. But when print the report picturebox is empty. I have tried to change values of sizing property to (Stretch,ScaleProportional,AutoSize,Center,Normal) and resize the picturebox in multiples sizes without results. I use Telerik Reporting R3 2020 which is compatible with wmf files.

Thanks¡¡¡

General Discussions

answered on 08 Feb 2021

7 answers

1.9K+ views

Special Characters within a Textbox Value Clause

I have a report that gives the nutrient breakdown of a feed ingredient. Sometimes the users in the lab will name the ingredient such that it references other work they are performing which typically results in the use of special characters. When they use "{}" the report viewer throws an exception.

I know that there is a workaround in C# to resolve these conflicts but how do I get around this in the Telerik Reporting system (short of scrubbing the data to remove the offending character?) The Value assignment in the example code causes this issue.

Example code:

General Discussions

answered on 08 Feb 2021

1 answer

1.1K+ views

Access to XMLHttpRequest at 'http://localhost:59374/api/reports/clients/.../parameters' from origin 'http://localhost:57654' has been blocked by CORS

Hello,

I have an ASP.NET MVC web application with several modules.

I would like to add a new statistics module contains multiple reports and only use the view part in this application (Telerik MVC HTML5 Report Viewer)

Another solution includes the REST service for report generation and also the definition of reports using the Standalone designer.

In the first application, this is my link to myModule in _Layout.cshtml

@Html.ActionLink("Account List", "AccountList", "Home", null, new { @class = "sidebar-link", id = "AccountListSide" })

this is the call of my action method in HomeController.cs:

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.Mvc;

namespace FirstApp.Controllers

{

public class HomeController : Controller

{

public ActionResult Index()

{

return View();

}

public ActionResult AccountList()

{

return View();

}

this is my report Viewer: Home/AccountList.cshtml

@using Telerik.Reporting

@using Telerik.ReportViewer.Mvc

@{

Layout = null;

}

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<title>Telerik MVC HTML5 Report Viewer</title>

<meta http-equiv="X-UA-Compatible" content="IE=edge">

<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1" />

<script src="~/Scripts/jquery-3.5.1.min.js"></script>

<link href="~/Content/kendo/2020.3.915/kendo.common.min.css" rel="stylesheet" />

<link href="~/Content/kendo/2020.3.915/kendo.blueopal.min.css" rel="stylesheet" />

<style>

#reportViewer1 {

position: relative;

width: 1300px;

height: 900px;

font-family: Verdana, Arial;

}

</style>

<script src="@Url.Content("http://localhost:59374/api/reports/resources/js/telerikReportViewer-15.0.21.120.min.js/")"></script>

</head>

<body>

@(Html.TelerikReporting().ReportViewer()

.Id("reportViewer1")

.ServiceUrl(Url.Content("http://localhost:59374/api/reports"))

.ReportSource(new UriReportSource() { Uri = "ListAccountReport.trdp" })

.ViewMode(ViewMode.Interactive)

.ScaleMode(ScaleMode.Specific)

.Scale(1.0)

.PersistSession(false)

.PrintMode(PrintMode.AutoSelect)

.EnableAccessibility(false)

)

</body>

</html>

In my second asp.net mvc application, i created the REST Service ReportController.cs

namespace SecondApp.Controllers

{

using System.IO;

using System.Web;

using Telerik.Reporting.Cache.File;

using Telerik.Reporting.Services;

using Telerik.Reporting.Services.WebApi;

//The class name determines the service URL.

//ReportsController class name defines /api/reports/ service URL.

public class ReportsController : ReportsControllerBase

{

static ReportServiceConfiguration configurationInstance;

static ReportsController()

{

//This is the folder that contains the report definitions

//In this case this is the Reports folder

var appPath = HttpContext.Current.Server.MapPath("~/");

var reportsPath = Path.Combine(appPath, "Reports");

//Add resolver for trdx/trdp report definitions,

//then add resolver for class report definitions as fallback resolver;

//finally create the resolver and use it in the ReportServiceConfiguration instance.

var resolver = new UriReportSourceResolver(reportsPath)

.AddFallbackResolver(new TypeReportSourceResolver());

//Setup the ReportServiceConfiguration

configurationInstance = new ReportServiceConfiguration

{

HostAppId = "Html5App",

Storage = new FileStorage(),

ReportSourceResolver = resolver,

// ReportSharingTimeout = 0,

// ClientSessionTimeout = 15,

};

}

public ReportsController()

{

//Initialize the service configuration

this.ReportServiceConfiguration = configurationInstance;

}

and under the second solution the Reports directory contains the definition of my report "ListAccountReport.trdp"

Another detail is activate CORS to access the service REST, I add in the 2nd app this snippet of code in web config:

<httpProtocol>

<customHeaders>

<add name="Access-Control-Allow-Origin" value="*" />

<add name="Access-Control-Allow-Headers" value="Content-Type" />

<add name="Access-Control-Allow-Methods" value="GET, POST, PUT, DELETE, OPTIONS" />

<add name="Access-Control-Allow-Credentials" value="true" />

</customHeaders>

</httpProtocol>

using only one solution, all works fine but separating the two parts in different solutions it throws me this error:

Unable to get report parameters.

Access to XMLHttpRequest at 'http://localhost:59374/api/reports/clients/6d5ac5243ca/parameters' from origin 'http://localhost:57654' has been blocked by CORS policy: Response to preflight request doesn't pass access control check: It does not have HTTP ok status.
jquery-3.5.1.min.js:2 POST http://localhost:59374/api/reports/clients/6d5ac5243ca/parameters net::ERR_FAILED

Thanks for replying

General Discussions

answered on 08 Feb 2021