Questions on Reporting Forum

1 answer

257 views

Hi,

I have a table with a date type column.

Hello, I have a table with a date type column. I am trying to sort it ascendingly, the types of numeric data and Strings work correctly but the date types do not recognize them.

How can I do it?

Thank you.

General Discussions

answered on 04 Oct 2019

7 answers

1.8K+ views

Struggling to create grouping and summaries in a table

Hi,

I'm new to Telerik reporting and using the Standalone Designer.

My report is driven by data that contains name, address and a collection of fund data.

I have a table with this data: Fund Name, Date, Amount

I need to display the data grouped by Fund Name, and show summary row for each Fund Name, and a Grand Total for all funds.

Parking Lot Fund

1/1/2019 $50.00

1/2/2019 $50.00

Total $100.00

Building Fund
1/1/2019 $50.00
1/2/2019 $50.00
Total $100.00

Grand Total $200.00

I have a table control in my detail section, have spent a few hours trying to do the above.

How can I add the grouping and summary for my table.

Thank you!!!

Karl

General Discussions

answered on 04 Oct 2019

8 answers

1.7K+ views

Printing from Report Viewer - opens pdf

There seems to be a recent change in how printing from the report viewer works. The used to open the print dialog and you could print from there. Now when you click print on the report viewer the browser prompts you to save as pdf.

I've noticed this is happening on Telerik's demo page.

Is it a browser setting? Is anyone else having this issue?

Thanks.

General Discussions

answered on 03 Oct 2019

6 answers

449 views

Print Issue in Angular 8

Hello Team,

I got recently issue in printing the template using telerik-angular-report-viewer in Angular 8. It used to work untill day before yesterday suddenly it stopped working. Did any modules got changed to print the template?

I'm using below code for print button:

"<tr-viewer #viewer1
[containerStyle]="viewerContainerStyle"
[serviceUrl]="ReportUrl"
[templateUrl]="'node_modules/@progress/telerik-angular-report-viewer/dist/dependencies/telerikReportViewerTemplate-sass.html'"
[reportSource]="Viewdata"
[scaleMode]="'SPECIFIC'"
[scale] = "1.0"
[renderingEnd]="boundReportRendered"
[error]="ReportError"
[viewMode]="'PRINT_PREVIEW'">
</tr-viewer>
<button id='btnprint' style="display:none;" name='btnprint' (click)="viewer1.commands.print.exec()">Print</button>"

Can you please get back on the issue im facing!?

Thanks in Advance.

Thanks,

Srija P.

General Discussions

answered on 02 Oct 2019

1 answer

168 views

Programmaticaly passing params to ReportBook childs Reports

I am working .net core rest api backend and angular front end.

I am trying to make a ReportBook adding reports to programmatically.

Front End TypeScript

reportReady() {

const reportSource = this.viewer.getReportSource();

reportSource.report = 1 + '_' + this.id;

const params = reportSource.parameters;

params.summaryId = this.id;

params.baseurl = Config.getServerUrl();

params.OriginalOrDuplicateParam = '';

reportSource.parameters = params;

this.viewer.setReportSource(reportSource);

}

Backend i have reports controller with Custom Report Resolver

private InstanceReportSource InvoiceSummaryReportBook(string reportId)

{

try

{

InstanceReportSource result = new InstanceReportSource();

using (var db = new FilteredHahnDbContext())

{

var summaryId = reportId.Split("_").LastOrDefault();

var summaryIdGuid = Guid.Parse(summaryId);

var summaryDetails = db.InvoiceSummaryDetails.Include(x => x.Invoice)

.Where(x => x.InvoiceSummaryMasterId == summaryIdGuid).ToList();

// Creating a new report book

var reportBook = new ReportBook();

var typeReportSource = new Telerik.Reporting.TypeReportSource();

typeReportSource.TypeName = typeof(ReportBook).AssemblyQualifiedName;

//Add first report

var glossaryReportSource = new UriReportSource();

glossaryReportSource.Uri = this.MapPath("InvoiceSummaryReport.trdp");

reportBook.ReportSources.Add(glossaryReportSource);

var params1 = new ParameterCollection();

var index = 0;

foreach (var summaryDetail in summaryDetails)

{

if (summaryDetail.Invoice.InvoiceTypeId == EInvoiceType.Individual)

{

var glossaryReportSource2 = new UriReportSource();

glossaryReportSource2.Parameters.Add("invoiceId", summaryDetail.InvoiceId.ToString());

result.Parameters.Add($"reports({index}).invoiceId", summaryDetail.InvoiceId.ToString());

typeReportSource.Parameters.Add($"reports({index}).invoiceId", summaryDetail.InvoiceId.ToString());

glossaryReportSource2.Uri = this.MapPath("IndividualInvoice.trdp");

reportBook.ReportSources.Add(glossaryReportSource2);

}

else

{

var glossaryReportSource2 = new UriReportSource();

glossaryReportSource2.Parameters.Add("invoiceId", summaryDetail.InvoiceId.ToString());

result.Parameters.Add($"reports({index}).invoiceId", summaryDetail.InvoiceId.ToString());

typeReportSource.Parameters.Add($"reports({index}).invoiceId", summaryDetail.InvoiceId.ToString());

glossaryReportSource2.Uri = this.MapPath("OrderInvoice.trdp");

reportBook.ReportSources.Add(glossaryReportSource2);

}

index++;

}

reportBook.TocReportSource = typeReportSource;

//Return the new instance

result.ReportDocument = reportBook;

return result;

}

catch (Exception ex)

{

throw;

}

Above Method used in

public ReportSource Resolve(string reportId)

{

InstanceReportSource result = null;

var rprtId = reportId.Split("_").FirstOrDefault();

switch (rprtId)

{

// 1 Invoice Summary ReportBook

case "1":

result = InvoiceSummaryReportBook(reportId);

break;

}

return result;

}

For each report "invoiceId" is different. As you can see in code i am trying three different methods to pass parameters but none are taking effect.

General Discussions

answered on 01 Oct 2019

1 answer

405 views

Telerik Reporting Designer Dark Theme

Is there any option to change Reporting Designer theme to dark?

I can't work on default white theme...

General Discussions

answered on 01 Oct 2019

4 answers

106 views

Standalone Report Designer UI Needs Updating

Telerik,

The Standalone Report Designer has a very dated UI. WPF provides so many more capabilities and when you use the Telerik WPF controls, so many possibilities exist.

Issues.

1. Please put the tool windows in a Docking system, like Teleriks. Forcing the property window to be pinned to the right side is a UI/UX issue. Studies have shown that placing it on the left, makes it easy to use since the object your assign property value is very close and the distance the mouse must be moved it greatly shortened.

2. Make the tool window fonts re-sizable. In the modern age of 4K computer monitors, the very date UI and small fonts make the designer difficult to use.

3. Enable the designer to create assemblies instead of just loose report files. The assembly files can be loose and then compiled as a separate tasks, i.e. shell out and run the appropriate "dotnet" build command to build the assembly. This would enable .NET Core developers form loosing out on many features of the reporting product by being forced to use the standalone designer. For example, Report events.

Thank you,

Karl

Report Designer (standalone)

answered on 30 Sep 2019

1 answer

721 views

Export to docx and xlsx error

Hi,

I am trying to export programmatically to docx and xlsx using Report Processor but get the error rendering format is not available error message.

https://www.telerik.com/support/kb/reporting/export-reports/details/missing-docx-xlsx-pptx-xps-export-options

Referred the article above but still got the error

I am using Telerik.Reporting 12.1.18.620 ,Telerik.Reporting.OpenXmlRendering 12.1.18.620 and Document.OpenXML 2.0.5022.0

Please provide me a sample project with the reference dlls rendering in word and xlsx.

Thanks

General Discussions

answered on 30 Sep 2019

1 answer

497 views

Labels - can we flow left to right, then down?

Hi,

I'm using the label wizard and it works great.

Some uses are asking if the labels can be printed left to right and then down, as opposed to the current flow of top to bottom the to the next column to the right.

Thank you for your time,

Karl

General Discussions

answered on 30 Sep 2019

5 answers

889 views

PictureBox is not showing binary image data on Html Report Viewer

Hi,

Here is the scenario for my report: I'm printing list of products. Every product can have image and I want to show product with images.

I need to show pictures on my report from odata data source.I have binary data(type of base64) of those pictures. PictureBox doesn't show image from binary data. So, that's why I extend and configured Report Designer by making user function to convert binary data to Image object. For this purpose this thread did help me: https://www.telerik.com/forums/html-binary-image-in-html-textbox

Now, the report is showing picture when I run it from Telerik Report Designer tool. But, when I use&run it from my project, it's not showing the image. It shows just blank. My project contains Telerik Reporting Rest service endpoint to generate report in server side, and HTML5ReportViewer control to show report in client side.

Ho do I configure my project to be able show image?

See attached files for what I have done.

General Discussions

answered on 30 Sep 2019