I am attempting to follow the steps provided in the KB article How to: Create Multi-Column Report - Across the Page and Then Down. However, a few things are unclear to me.
1.) Do I need to created group sections on the actual report for this to work, or can I bind my SQL data source to the table itself and only have a single detail section consisting of this table alone?
2.) Once the data source is squared away, and I divide and mod the index of the data, do I divide/mod by the total columns of the data (for instance, my data is 3 columns, so I will technically have 6 columns across the page) or is the column number specifying how many times I want the data to be placed across the page (for instance, 2 columns consisting of 3 data columns)
3.) Once that is taken care of, where specifically do I place my grouping headers and detail values?
Hi,
I update Telerik.Reporting from 2016.10.1.16.504 to 12.1.18.620 by Upgrade Wizard. When render a report I have an exception System.EntryPointNotFoundException. The solution has been cleaned and rebuilt after the update Telerik.Reporting. I also checked all .dll files – all of them are new version. Do you have any information how to fix the issue?
I create a panel, set width/height as 100px / 50px and padding as 10px. When render to html, width/height of the div tag just only 80px x 30px, padding still be 10px. If I remove padding, width/height rendered will be 100px / 50px.
How can I have width/height is 100px / 50px even if I have padding?
Hi,
I looked around but could not find a solution
This is what we have but when we have multiple header items in dsHeader.
I wish it prints out different header data at once. the code below shows and prints only the first header and its body
What I would like to do is print out multiple data consecutively when dsHeader's length is more than one using the same code
odsHeader is object header source provided by Telerik Reporting R1 2017
namespace DMG.MRP.Report.Design
{
using System;
using System.ComponentModel;
using System.Drawing;
using System.Windows.Forms;
using Telerik.Reporting;
using Telerik.Reporting.Drawing;
using System.Data;
using DMG.RPT.Biz;
/// <summary>
/// Summary description for RPT_PO.
/// </summary>
public partial class RPT_PO : Telerik.Reporting.Report
{
public RPT_PO()
{
InitializeComponent();
}
public void LoadDataReport(string po_no)
{
if (po_no == null)
{
return;
}
DataSet dsHeader = null, dsDetail = null;
using (RPT_Biz biz = new RPT_Biz())
{
dsHeader = biz.GetHeader_PO(po_no);
odsHeader.DataSource = dsHeader;
odsHeader.DataMember = "Table";
dsDetail = biz.GetDetail_PO(po_no);
odsHeader.DataSource = dsDetail;
odsHeader.DataMember = "Table";
}
this.DataSource = dsHeader.Tables["Table"];
table1.DataSource = dsDetail.Tables["Table"];
}
}
}
Hi,
I have gone through the tuts available in the Telerik docs ( link below ) but was not able to View the report.
https://docs.telerik.com/reporting/html5-report-viewer-asp-net-core-2
Would also like to know whether the approach I have done is correct.
What I have done
1 Have an existing application which is targeting Asp.net MVC Core ( not net461 but Core) where I have added a folder with the design ( a sample .rdlc designed in Standalone Report Designer)
2 Created a REST Service from the Telerik template and configured as per the docs and the end point ( http://localhost:[portnumber]/api/reports/formats) running successfully.
3 In the Core project ( point 1 I have consumed the REST Service and is trying to run it but shows error ( I 'm using Javascript ReportViewer Widgets since I can't Change the Target version to net461
Is the approach Please let me know your valuable thoughts.
Error: Error loading the report viewer's templates. (Template = /api/reports/resources/templates/telerikReportViewerTemplate-html).
TIA
I am trying to run a report in a web application .net core 2
I have followed the HTML5 Report Viewer in ASP.NET Core 2 Article with no success
I have added the below controller.
namespace schoolAppCore.Controllers
{
[Route("api/reports")]
public class ReportsController : Controller
{
string reportsPath = string.Empty;
public ReportServiceConfiguration ReportServiceConfiguration { get; }
public ReportsController(IHostingEnvironment environment)
{
this.reportsPath = Path.Combine(environment.WebRootPath, "Report1.trdp");
this.ReportServiceConfiguration = new ReportServiceConfiguration
{
HostAppId = "schoolAppCore",
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));
}
}
}
and also I have added a controller named to run the View as following:
public class TelerikController : Controller
{
public IActionResult viewreport()
{
return View("reportViewer");
}
}
finally the Report view itself as following:
<
html
>
<
head
>
<
meta
name
=
"viewport"
content
=
"width=device-width, initial-scale=1, maximum-scale=1"
/>
<
title
></
title
>
<
script
src
=
"~/lib/jquery/dist/jquery.min.js"
></
script
>
<
link
href
=
"~/styles/kendo.common.min.css"
rel
=
"stylesheet"
/>
<
link
href
=
"~/styles/kendo.blueopal.min.css"
rel
=
"stylesheet"
/>
<
script
src
=
"~/lib/Kendo/telerikReportViewer.kendo-12.1.18.620.min.js"
></
script
>
<
script
src
=
"~/lib/Kendo/telerikReportViewer-12.1.18.620.min.js"
></
script
>
<
style
>
#reportViewer1 {
position: absolute;
left: 5px;
right: 5px;
top: 50px;
bottom: 5px;
overflow: hidden;
font-family: Verdana, Arial;
}
</
style
>
</
head
>
<
body
>
<
div
id
=
"reportViewer1"
>
loading...
</
div
>
<
script
>
$(document).ready(function () {
$("#reportViewer1")
.telerik_ReportViewer({
serviceUrl: "api/reports/",
//"resources/templates/telerikReportViewerTemplate.html"
reportSource: {
// report: "Telerik.Reporting.Examples.CSharp.ReportCatalog, CSharp.ReportLibrary",
report: "Report1.trdp",
parameters: {}
},
viewMode: telerikReportViewer.ViewModes.INTERACTIVE,
scaleMode: telerikReportViewer.ScaleModes.SPECIFIC,
scale: 1.0,
});
});
</
script
>
</
body
>
</
html
>
I am getting the below error
jquery.min.js:4 GET https://localhost:44332/telerik/api/reports/resources/templates/telerikReportViewerTemplate-html 404 ()
and also (viewreport:1 Uncaught (in promise) undefined)
can some one help in getting this run in core 2 Application
I am not sure if I am doing something wrong to be honest.
I have a simple Master - Detail type report. The report is displaying the correct data. However, when I run SQL Profiler to review the queries that are being executed, I see the master query run as expected. The detail query however has no filter on it.
I expected to see the parameter value from the master report being passed to the subreport so that it filters the query.
The result of this is a slow rendering of the report. It appears that for each record in the master report, it executes the sub reports query in an unfiltered state. My sub query could have 100,000+++ records. So it grabs that entire dataset, passes it back to the master report which then picks the correct record(s) that it wants. It then moves on to the next parent record.
Is that correct? I must be doing something wrong.
Think of it this way.I have customers table and invoices table. Each customer could have numerous invoices. I want a customer listing report that shows all the invoices for those customers. The sub-report query would be something like "Select Customer, Invoice from Invoice". I would have thought it would be something like "Select Customer, Invoice from Invoice where Customer= @Customer".
Please let me know what I have done wrong.
Brian
Hi,
I have created several reports using Telerik reporting. But when the user exports a report, at least to Excel, I have to be able to set the Width to 1 page by default. I have tried several options but I don't seem to be able to set this property using the configuration sections. I am currently using reports in an MVC project. In the device information settings for Excel 2007, I cannot find any configuration to control this property. Is there some how to achieve this?
This requirements is a must from the client, since they don't want to go to the Page Setup -> Scale to Fit menu on Excel to do this change. Currently they have a completely custom solution to generate reports in Excel and this option is already set on this solution, so they consider this missing functionality as a downgrade to their current solution which is unacceptable for them.
I would appreciate a lot to have the same functionality also on PDF, since their reports are quite large and they want to fit them inside one page when exporting to PDF (I know I can play with the font sizes and textbox/table columns sizes but since I have already done the reports, doing these changes will require a lot of time which I unfortunately don't have at this moment).
Thanks
Hi
I am trying to print my reports in html format. Unfortunately the page border does not seem to fit a printed page. In portrait I get the top of next page printing border at the bottom of the first ( see attachment). In landscape I lose the bottom of the border. Is there a way to completely remove the border or fix the page sizes to the printed page size.
My browser (chrome) is printing to A4 and the report files are set to A4 size.
Any ideas would be of great help.
Thanks
Craig