Telerik Forums
Reporting Forum
1 answer
511 views

I'm just new here in Telerik Forum, I don't know if I'm in the right thread to ask this question.

I just want to know how to set the unit of measurement programmatically(code) using Telerik report viewer WinForm, Because I'm having a problem in viewing the print preview of my report using (US) System Unit Measurement ( Type: Metric / US ). In the Telerik Report Designer there is an option where you can change the Unit of Measurement, by changing the right unit of measurement in Telerik Report Designer the print preview is ok. but when I execute the program and print preview using Telerik Report Viewer WinForm  the print preview is not aligned correctly because it is set by default. and I guess the default unit of measurement of Telerik Report Viewer WinForm is (cm / Metric). Sorry for my grammar XD thank in advance.

Todor
Telerik team
 answered on 23 Oct 2020
1 answer
173 views

I built a Blazor app (server) on.NET Core 3.1 and I am using Telerik Reporting with the HTML5 viewer to present reports.  Everything is working, except the export formats only allow RTF, CSV, TIFF, and PDF.  My users need to be able to export to XLSX format as well. 

I have installed the NuGet package for DocumentFormat.OpenXml version 2.7.2 per the documentation, but I don't see the option showing up still, and I don't know how to troubleshoot the issue.  Any advice on what I am missing to get the additional format option to appear?

Nathan
Top achievements
Rank 1
 answered on 22 Oct 2020
1 answer
184 views
 I have created Rest Service Project for my reporting and I was able to create report in .resx format , Now can some one  please let me know how I can call reporting library which is separate project  in my angular and .net core 2.2 project ???

see screens shot of both projects

Thanks for your help
Todor
Telerik team
 answered on 21 Oct 2020
1 answer
189 views

I'm trying to add a pie chart to a report that I've been working on and im at a loss. The chart itself is great, my problem is the Legend. Its showing the wrong column and I cant figure whats wrong with it. I have a query that returns 3 rows and two columns. The query results look something like this:

Category     | Amount
--------------------------
Chats          | 51
Phone calls | 379
Emails         | 2602

When I create the pie chart in the report designer, all the slices are the right size and labeled with the correct percentages. However in the legend, it just has "Amount" shown as the key for each item in the legend. I want it to display the actual category, but cannot seem to get this to work. I followed the documentation listed at https://docs.telerik.com/reporting/graphhowtocreatepiechart, but it still shows "Amount" in  the legend instead of the actual categories. I have attached a screenshot of the report designer to show what the pie chart looks like as of now.

 

Neli
Telerik team
 answered on 21 Oct 2020
1 answer
113 views
     Is there a way to use the grid.saveAsPDF() functionality and direct the action to a Telerik report Template  created with the Report Designer?. Rather than PDF file that gets generated normally? 
Eric R | Senior Technical Support Engineer
Telerik team
 answered on 20 Oct 2020
3 answers
156 views

I have a report being displayed properly in a 3.1 app and after switching it to net5.0 with RC-2 installed I get the attached error. Can someone perhaps point me in the right direction?

 

Thank you,

Scott

Silviya
Telerik team
 answered on 20 Oct 2020
1 answer
427 views

We are busy with a POC and we have 4 sub reports on our main reports. In each subreport there is an aggregated total in the footer that we want to return and display as a summary value in the main report header section.

 

Is it possible to write an expression to access the value on a text box in the sub report from the main report?

 

Or is there a different way to do this?

Nasko
Telerik team
 answered on 19 Oct 2020
9 answers
2.2K+ views

Hi folks 

I'm having problem with Telerik Reporting using Angular 8. it throwing this error ERROR Error: Uncaught (in promise): Invalid clientID. 

the below is how i setup viewer.

<tr-viewer #viewer1
    [containerStyle]="viewerContainerStyle"
    [serviceUrl]= "'http://example/api/reports'"
    [templateUrl]="'/assets/template.html'"
    [reportSource]="{
        report: 'BillingDetails.trdx',
        parameters: {}
    }"
    [viewMode]="'INTERACTIVE'"
    [scaleMode]="'SPECIFIC'"
    [scale]="1.0">
</tr-viewer>

 

WEB API 

 [EnableCors(origins: "http://localhost:4200", headers: "*", methods: "*")]
 [RoutePrefix("api/reports")]

        protected override Telerik.Reporting.Cache.Interfaces.ICache CreateCache()
        {
            return CacheFactory.CreateFileCache();
        }

        protected override Telerik.Reporting.Services.Engine.IReportResolver CreateReportResolver()
        {
            string reportsPath = HttpContext.Current.Server.MapPath("~/ReportFiles");

            var r = new ReportFileResolver(reportsPath).AddFallbackResolver(new ReportTypeResolver());

            return r;
        }
    

Client side is separated from webAPI, i'm making Http calls to request resources from web API. JQuery and/or Angular 8 solutions will be appreciated. 

Thanks

 

Todor
Telerik team
 answered on 15 Oct 2020
2 answers
428 views

I'm working in a ASP.net core 3.1 web application. I want to display a Report without using the report viewer as well as not embedding the datasource into the report. The data for the report will be determined at runtime. So this is what I have done so far.

Defined a report with the report designer that has just one field                    = Fields.Title

The report does render with the correct number of lines that I expected. However there is no data.  The data object that gets assigned to the report datasource does have values.  Five values from the database.  It's just that the those values don't  bind to the ["Fields.Title] property of the report. All I see is 

Title
Title
Title
Title
Title

Here's the code

Controller Method that gets called from the GUI
 
 public FileContentResult GetTasksReports()
        {
            return File(_reportService.GetTaskReport(), "application/pdf");
        }
 
 
Service methods
 
 
public byte[] GetTaskReport()
{
          //get data from db. This returns data
           var tasks = _taskRepository.GetAllList();
 
            //Populate a List of Classes that will serve as the Reports datasource
            List<MyTasks> taskList = new List<MyTasks>();
            foreach (Task t in tasks)
            {
                MyTasks ts = new MyTasks()
                {
                    Title = t.Title
                };
                taskList.Add(ts);
            };          
 
            return getReport(taskList, "TasksNoEmbeddedDS.trdp");
        }
         
 private byte[] getReport(dynamic ds, string telerikReportName)
        {
            string reportName = "Reports\\Tasks\\" + telerikReportName;
 
            ReportPackager reportPackager = new ReportPackager();
            Telerik.Reporting.Report report = null;
            using (var sourceStream = System.IO.File.OpenRead(reportName))
            {
                 
                report = (Telerik.Reporting.Report)reportPackager.UnpackageDocument(sourceStream);
 
                //assign the data to the Report Datasource
                report.DataSource = ds;
            }
 
            return RenderMyReport(report);
 }
 
        private byte[] RenderMyReport(Telerik.Reporting.Report report)
        {  
            System.Collections.Hashtable deviceInfo = new System.Collections.Hashtable();
 
            InstanceReportSource instanceReportSource = new InstanceReportSource()
            {
                ReportDocument = report
            };
 
            var configuration = ConfigurationHelper.ResolveConfiguration(webHostEnvironment);
            ReportProcessor reportProcessor = new ReportProcessor(configuration);
            RenderingResult result = reportProcessor.RenderReport("PDF", instanceReportSource, deviceInfo);
 
            return result.DocumentBytes;
        }
 
 
 public class MyTasks
  {  
  public string Title;
 }      

 

 

 

Jeff
Top achievements
Rank 1
Veteran
 answered on 12 Oct 2020
1 answer
617 views

Hello!
I use HTML5Viewer with Telerik.Reporting.Trial and  I can't see XLS export options in viewer.

As far as I now XLS format not need third-party libraries (like OpenXML), but I installed this libraries too and add assembly redirect. It is not working.
Then I try add option programmatically in GetDocumentFormats() override method in my controller and I can see XLS option, but report return error "XLS rendering format is not available".
I readed article "Missing DOCX, XLSX, PPTX, XPS export options in viewers or "X rendering format is not available" error message", but this recommendations not help me.
Can you help me?
My JSON configuration for extention:

"extensions": [
  {
    "name": "XLS",
    "description": "XLS",
    "visible": "true"
  }
]
Neli
Telerik team
 answered on 12 Oct 2020
Top users last month
Hiba
Top achievements
Rank 1
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
Max
Top achievements
Rank 1
Veteran
Iron
Alina
Top achievements
Rank 1
Rakhee
Top achievements
Rank 1
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?