I used to Telerik reporing for data show. It is work order. but after update 2020 R1. I can not replace the connection string. please help.
my controller:
[Route("api/reports")]
public class ReportsController : ReportsControllerBase
{
string reportsPath = string.Empty;
public ReportsController(IHostingEnvironment environment)
{
this.reportsPath = Path.Combine(environment.WebRootPath, "UserUpload\\Reports");
this.ReportServiceConfiguration = new ReportServiceConfiguration
{
HostAppId = "Html5DemoApp",
Storage = new FileStorage(),
ReportResolver = new ReportTypeResolver()
.AddFallbackResolver(new ReportFileResolver(this.reportsPath)),
};
}
[HttpGet("reportlist")]
public IEnumerable<string> GetReports()
{
return Directory
.GetFiles(this.reportsPath)
.Select(path =>
Path.GetFileName(path));
}
}
viewer code:
<script>
function ReportRendering(e,args) {
var info = args.deviceInfo;
//info.set("FontEmbedding", "Full");
}
function OnLoad()
{
var win = window.parent.GetWindow("WdIframe");
var report = win.reportName;
var parameters = win.reportParam;
var printMode = /(chrome)/.test(navigator.userAgent.toLowerCase())
? telerikReportViewer.PrintModes.FORCE_PDF_PLUGIN
: telerikReportViewer.PrintModes.FORCE_PDF_FILE;
$("#reportViewer")
.telerik_ReportViewer({
serviceUrl: "../api/reports/",
reportSource: {
report: report,
parameters: parameters,
},
viewMode: telerikReportViewer.ViewModes.PRINT_PREVIEW,
scaleMode: telerikReportViewer.ScaleModes.SPECIFIC,
scale: 1.0,
enableAccessibility: false,
sendEmail: { enabled: false }
});
//$("#reportViewer").telerik_ReportViewer({
// serviceUrl: "../Api/reports/",
// reportSource: {
// //report: "Telerik.Reporting.Examples.CSharp.ReportCatalog, CSharp.ReportLibrary",
// report: report,
// parameters: parameters,
// },
// renderingBegin:ReportRendering,
// viewMode: telerikReportViewer.ViewModes.PRINT_PREVIEW,
// scaleMode: telerikReportViewer.ScaleModes.SPECIFIC,
// scale: 1.0
//});
if (win.mode == "Print") {
var reportViewer = $("#reportViewer").data("telerik_ReportViewer");
reportViewer.bind(telerikReportViewer.Events.PAGE_READY, function (e) {
reportViewer.commands.print.exec();
});
}
}
$(document).ready(OnLoad());
</script>
I was creating a report in Oracle and running an SP when suddenly my computer started to slowdown, upon checking I discovered that the Telerik ReportDesigner R1 2020 is consuming 4,920.4 of memory with 1.9MB/s in Disk. Because of this outcome and due to my computer slowdown, I hard re-boot my computer. After opening my PC and logging in, I opened the ReportDesigner but it no longer opens up. It always gives up an error message "Fatal error in workbench. Now closing... An error has occured while loading the ReportDesigner's Workbench".
Here is an attached file for the crashed Telerik ReportDsigner,
I need to get the app started badly to finish my report and to give assessment on Telerik Reproting to my bosses.
Thanks in advance!
Hi,
I want to make a report by using report viewer on Winforms(C#).
Report was designed on Visual studio 2019.
When I add and set a sqlDataSource on Report Designer. it is shown correctly.
I create a report on report viewer on Winforms(C#) by dynamic data with SQL query.
How can I set sqlDataSource ?
Here is my code.
private void reportViewer1_Load(object sender, EventArgs e)
{
TypeReportSource typeReportSouce = new TypeReportSource();
typeReportSouce.TypeName = "SalesManager.Products.BarcodePrintReport, SalesManager, Version=0.9.24.1, Culture=neutral, PublicKeyToken=null";
typeReportSouce.Parameters.Add(new Telerik.Reporting.Parameter("Barcode", "O43659"));
SqlDataSource sqlDataSource = new SqlDataSource();
sqlDataSource.ProviderName = "MySql.Data.MySqlClient";
sqlDataSource.ConnectionString = "Server=********;Port=****;Database=****;Uid=****;Pwd=*****;CharSet=utf8;Convert Zero Datetime=True";
sqlDataSource.SelectCommand = "SELECT barcode,name FROM product_list WHERE code = 'TT003' OR code = 'TT002'";
sqlDataSource.CommandTimeout = 0;
this.reportViewer.ReportSource = typeReportSouce;
this.reportViewer.RefreshReport();
}
Im trying to make a doble colum report, and i gotit but a the and of report i want to end in a complente center table, but i can not get it cuz the report is in double column.
What can I Do for resolve that problem.
Hi,
I have downloaded Telerik_Reporting_Q1_2016_SP1_manual.chm, however I can only see the content tables, I cannot see content on the right hand side of help windows. I am using windows 10.
Downloaded and installed Telerik Report Designer to do some assessment. I am trying to connect to Oracle database for the report I've been working with. But when I click "Test Connection", I encountered this issue.
I wan't to know what does this mean, and how to resolve this issue.
PS: Currently using the following:
Processor: Intel Core i7-6500U
OS: Win 10 Pro ver.1909 OS Build: 18363.657
64bit, x64-based processor
Any help would be highly appreciated. Thanks in advance.
Now im having 2 column charts:
1. Sales amount by department
and
2. Number of transactions by department
i wan to combine both of them in this way:
Sales amount : left vertical axis
Number of transactions: right vertical axis
department: horizontal axis
may i know can I achieve it?
thanks in advance
Hello,
I am using Telerik Report Designer HTML5. I have made a graph where the x-axis ('x') and y-axis ('y') data is retrieved from the database. On my tool-tip, I am retrieving a different data from the database, let's say 'z'.
When I export my graph in .csv format, the 'x' and 'y' data is listed down, but I want the csv to also export my 'z' data from the tool-tip.
Hence, is it possible to export the tool-tip data from a graph in a csv?