Telerik Forums
Reporting Forum
1 answer
145 views

 

Hello,

on the top of this page:   https://docs.telerik.com/reporting/html5-report-viewer

I have seen a littel nice widget - a dropdown menu above the report.

I attach a screenshot of that report with a red arrow to show you which thing I mean.

It could be useful for me.

I  want to load a report with other parameters and the mentioned dropdown menu above the report could be the right thing.

Depending on the choice it would be shown a report with other parameters.

Please can you show me how to implement this dropdown menu?

 

Simon
Top achievements
Rank 1
 answered on 05 Feb 2019
1 answer
759 views

When I run a report via the webapi against a particular webserver, it just gets to where it's loading /api/Reports/clients/123/instances/documents/123/info indefinitely. It returns a status code of 202 Accepted, content has documentReady: false. No error or anything, it just does this indefinitely forever.

 

I'm using the reporting services webapi to run reports with the mvc framework. To do that I have a class which implements IReportResolver, which instantiates a InstanceReportSource and returns that in the Resolve method. I create these InstanceReportSource instances programmatically else where in the same code base, and they work fine in those instances (without the webapi).

I have a nearly identical code base with the exact same reporting implementation on another web server (Windows Server 2012, IIS 7), and there it works fine. It also works fine when I run it in Visual Studio. The environment where it does not work fine is Windows Server 2008 R2, IIS version 6.1. I am curious if upgrading the OS/IIS would fix it, but I can't do that at customer sites where this will be deployed to necessarily.

 

I did find originally when I ran it, it'd crash the application pool. Seemed to be a permission thing because i'm using the TEMP environment variable for file storage, but switching which account the application pool was under fixed it so it wouldn't crash, but this action happens instead.

 

Both webservers are setup nearly identical as far as I can tell, considering they are different versions. Unsure of where to look, if there's some underlying error or something else to be looking at. Any help is appreciated.

Todor
Telerik team
 answered on 04 Feb 2019
1 answer
469 views

I've a problem with a simple report which consists of upto 5 tables. Data comes from a single dataset containing 5 datatables.

1) Unless one particular table contains data, then the detail section of that report is blank.

My original design was a wrapper report with 5 sub reports. But when that showed the problem, I dropped the sub reports and generated the report as a flat file with 5 tables. This made no difference.

I've tried rebuilding both the report and dataset several times. With the report I've used the wizard to add objectdatasource and the tablewizard to add the tables.

2) One of the tests I've coded in there also shows that sometimes the "Order" column header isn't drawn. It consistently happens with that
selection when it happens. I hope you can also look at this please.

I've recreated a C# application that shows the problem, please see link. I hope you would run it in debug mode to see what's wrong. Just decompress the solution and run. Use the menu to select a test report. Print preview shows report header and footer and nothing else for those reports that fail.

http://www.mediafire.com/file/rpf1fj0icggk4e1/telerikbuild1.rar/file

Todor
Telerik team
 answered on 04 Feb 2019
1 answer
915 views

Hi All,

I'm wondering if anyone can help identify what I'm doing wrong - or indicate if things have changed or bugs have been identified with how the reporting product handles fonts when rendering to PDFs since we last licensed our Telerik toolset...

We have a problem where a report has been designed using a set of corporate-branded ttf fonts. The report was built using the standalone designer (version 8.0.14.507) to create trdx definition files and uses an external style sheet (style.xml). The report previews correctly but when we deploy it to the server and it's built within our C# application and streamed to the user, the displayed fonts revert to a default Windows one.

I can see that the other related style settings for the fonts are being applied (such as font size etc.) so it looks like the external style sheet is being read correctly and the font is simply being reverted back to the environments default one.

Googling around I've checked a number of things.

  • The fonts are embedded in the PDF document. (I've tried embedding a both subset and the full set with no joy). 
    • Confirmation of embedding was taken by the increase in the pdf file size on each change
    • Acrobat Reader shows the fonts as Embedded (or partially)
    • Type TrueType (CID)
    • Encoding: Identity-H
  • The TTF fonts grant the permission for embedding (https://www.eggfortress.com/fixing-font-permissions-allowing-embed-on-ttf-fonts/)
  • The font's are installed on both server and client machines.

We're long out of support from Telerik :( otherwise I'd consider opening a ticket.  Does anyone in the community have any ideas or pointers to what to look at next?

Thanks,

Paul.

Paul
Top achievements
Rank 1
 answered on 04 Feb 2019
1 answer
162 views

    Hi I have a list that comes into the report viewer demo that has 48 items i am passing it two a report view. But when I look at the report viwer it is comming up blank.

public partial class BoxReportBatches : Telerik.Reporting.Report
   {
       private List<BoxReportObject> _list;
       public BoxReportBatches()
       {
           //
           // Required for telerik Reporting designer support
           //
           InitializeComponent();
           //
           // TODO: Add any constructor code after InitializeComponent call
           //
       }
       public BoxReportBatches(List<BoxReportObject> _dataSource)
       {
           _list = _dataSource;
           this.DataSource = _list;
 
 
       }
   }

 

And here is my reportviewer window

private List<BoxReportObject> _list;
      public ReportViewer(List<BoxReportObject> list)
      {
          InitializeComponent();
          _list = list;
      }
 
      private void ReportViewer_Load(object sender, EventArgs e)
      {
 
 
          // var exeFolder = @"\\server02\sage\CustReports";
           //var exeFolder = @"C:\Program Files (x86)\Sage\Sage200\Reporting\";
          //string reportPath = Path.Combine(exeFolder, @"BoxReport.rdlc");
         // Clipboard.SetText(exeFolder);
          BoxReportBatches report1 = new BoxReportBatches(_list);
           // perform additional operations on the report object if needed          
          Telerik.Reporting.InstanceReportSource instanceReportSource = new Telerik.Reporting.InstanceReportSource();
          instanceReportSource.ReportDocument = report1;
          this.reportViewer1.ReportSource = instanceReportSource;
            
      }

 

My Box Report Class is 

public class BoxReportObject
 {
     public DateTime ProductionPlanWeekStarting { get; set; }
     public DateTime ProductionPlanWeekEnding { get; set; }
     public string BatchNumber { get; set; }
     public string BoxRef { get; set; }
     public string BoxName { get; set; }
     public decimal Qty { get; set; }
 }

 

 

You can also see here the properties of my report viewer.

 

 

 

 

 

 

 

 

 

 

 

Todor
Telerik team
 answered on 04 Feb 2019
1 answer
1.6K+ views
Problem description: the "Roboto" TTF font in the exported PDF (in the Telerik Reporting REST Service on the Azure web app) is replaced by another font.

General Information:
- Environment: Windows 10 (development), Azure web app (publish)
- Telerik Reporting version 12.1.18.516
- Report designer: Visual Studio 2015
- Project types: Class library (report dll) and Telerik Reporting REST Service
- Font families: Roboto and RobotoSlab (trye type fonts)

Unsuccessfully solution:
I tried to solve this problem using solution specified in the "privateFonts Element" article.
http://docs.telerik.com/reporting/configuring-telerik-reproting-privatefonts
I placed the following XML into the <configuration> tag of the Web.config file but receive the: "HTTP Error 500.19 - Internal Server Error"

<configuration>
   ...
  <Telerik.Reporting>
    <privateFonts>
      <add fontFamily="Roboto" path="D:\home\site\wwwroot\webrep\fonts\Roboto-Regular.ttf" />
      <add fontFamily="RobotoSlab" path="D:\home\site\wwwroot\webrep\fonts\RobotoSlab-Regular.ttf" />
    </privateFonts>
  </Telerik.Reporting>
   ...
</configuration>
Silviya
Telerik team
 answered on 01 Feb 2019
2 answers
1.0K+ views

I install the latest release of reporting (2019 r1). I try put report in my .net core application. I follow the instruction of the reporting document. Add a controller and a viewer page in my application. But I call the webapi, I got a error as follow:

{"Message":"An error has occurred.","ExceptionMessage":"Object reference not set to an instance of an object.","ExceptionType":"System.NullReferenceException","StackTrace":" at Telerik.Reporting.Services.Engine.ResourcesEngine.GetResource(String folder, String name) in c:\\temp\\reporting\\RBuild-13280\\Reporting_Build\\Source\\Code\\Telerik.Reporting\\Services.Engine\\ResourcesEngine.cs:line 30\r\n at Telerik.Reporting.Services.AspNetCore.ReportsControllerBase.GetResource(String folder, String resourceName) in c:\\temp\\reporting\\RBuild-13280\\Reporting_Build\\Source\\Code\\Telerik.Reporting.Services.AspNetCore.Core\\ReportsControllerBase.Resources.cs:line 92\r\n at lambda_method(Closure , Object , Object[] )\r\n at Microsoft.Extensions.Internal.ObjectMethodExecutor.Execute(Object target, Object[] parameters)\r\n at Microsoft.AspNetCore.Mvc.Internal.ActionMethodExecutor.SyncActionResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)\r\n at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeActionMethodAsync()\r\n at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeNextActionFilterAsync()\r\n at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Rethrow(ActionExecutedContext context)\r\n at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)\r\n at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeInnerFilterAsync()\r\n at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeNextExceptionFilterAsync()"}

 

and I access the viewer page. the error as follow:

Cannot access the Reporting REST service. (serviceUrl = '../api/reports/'). Make sure the service address is correct and enable CORS if needed. (https://enable-cors.org)

 

what can I do.

 

 

 

Silviya
Telerik team
 answered on 31 Jan 2019
13 answers
1.3K+ views

Hello,

in my webproject I have integrated a reporting feature.

Please see the attached file!

Now I want to replace the listview with a dropdownmenu.

How can I do this?

I have not found a possibility to configure it.

In this example I have only two items, but in other cases there are more then two.

By the way: How can I rename the Preview-Button?

 

 

 

 

 

 

Simon
Top achievements
Rank 1
 answered on 31 Jan 2019
5 answers
856 views

Hi

We've just updated our project for using Telerik Reporting 2019R1.

The update looks amazing! 

Our project is configured for dotnetcore-2.2 target framework and works prefect on Windows.

But unfortunately it crashes when I'm trying to open a page with Report Viewer.

I see the message: Cannot access the Reporting REST service. (serviceUrl = '/api/reports/'). Make sure the service address is correct and enable CORS if needed. (https://enable-cors.org)

Here is the log output:

info: Microsoft.AspNetCore.Hosting.Internal.WebHost[1]
      Request starting HTTP/1.1 GET http://localhost:5000/api/reports/formats  
warn: Microsoft.AspNetCore.Localization.RequestLocalizationMiddleware[2]
      AcceptLanguageHeaderRequestCultureProvider returned the following unsupported UI Cultures 'en-us'.
info: Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker[1]
      Route matched with {action = "GetDocumentFormats", controller = "Reports"}. Executing action ERP.Web.Controllers.ReportsController.GetDocumentFormats (ERP.Web)
info: Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker[1]
      Executing action method ERP.Web.Controllers.ReportsController.GetDocumentFormats (ERP.Web) - Validation state: Valid
info: Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker[2]
      Executed action method ERP.Web.Controllers.ReportsController.GetDocumentFormats (ERP.Web), returned result Microsoft.AspNetCore.Mvc.JsonResult in 123.9889ms.
info: Microsoft.AspNetCore.Mvc.Formatters.Json.Internal.JsonResultExecutor[1]
      Executing JsonResult, writing value of type 'System.Collections.Generic.List`1[[Telerik.Reporting.Services.Engine.ExtensionInfo, Telerik.Reporting, Version=13.0.19.116, Culture=neutral, PublicKeyToken=a9d7983dfcc261be]]'.

Unhandled Exception:
 
Unhandled Exception: Unhandled Exception: 
Unhandled Exception: 
Unhandled Exception: 
Unhandled Exception: 
Unhandled Exception: System.TypeInitializationException: The type initializer for 'Telerik.Reporting.Cache.Lock' threw an exception. ---> System.PlatformNotSupportedException: Windows Principal functionality is not supported on this platform.
   at System.Security.Principal.SecurityIdentifier..ctor(WellKnownSidType sidType, SecurityIdentifier domainSid)
   at Telerik.Reporting.Cache.Lock..cctor()
   --- End of inner exception stack trace ---
   at Telerik.Reporting.Cache.Lock..ctor(String key)
   at System.Threading.Thread.ThreadMain_ThreadStart()
   at Telerik.Reporting.Cache.LockProviderWindows.GetLock(String key)
   at Telerik.Reporting.Services.Engine.SyncedQueue.TryDequeue(String& itemId)
   at Telerik.Reporting.Services.Engine.TaskQueue.WorkerThread.ProcessItems()
   at Telerik.Reporting.Services.Engine.TaskQueue.WorkerThread.ThreadProc()
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.Thread.ThreadMain_ThreadStaSystem.TypeInitializationException: The type initializer for 'Telerik.Reporting.Cache.Lock' threw an exception. ---> System.PlatformNotSupportedException: Windows Principal functionality is not supported on this platform.
   at System.Security.Principal.SecurityIdentifier..ctor(WellKnownSidType sidType, SecurityIdentifier domainSid)
   at Telerik.Reporting.Cache.Lock..cctor()
   --- End of inner exception stack trace ---
   at Telerik.Reporting.Cache.Lock..ctor(String key)
   at System.Threading.Thread.ThreadMain_ThreadStart()
   at Telerik.Reporting.Cache.LockProviderWindows.GetLock(String key)
   at Telerik.Reporting.Services.Engine.SyncedQueue.TryDequeue(String& itemId)
   at Telerik.Reporting.Services.Engine.TaskQueue.WorkerThread.ProcessItems()
   at Telerik.Reporting.Services.Engine.TaskQueue.WorkerThread.ThreadProc()
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.Thread.ThreadMain_ThreadStart()
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()rt()
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()System.TypeInitializationException: The type initializer for 'Telerik.Reporting.Cache.Lock' threw an exception. ---> System.PlatformNotSupportedException: Windows Principal functionality is not supported on this platform.
   at System.Security.Principal.SecurityIdentifier..ctor(WellKnownSidType sidType, SecurityIdentifier domainSid)
   at Telerik.Reporting.Cache.Lock..cctor()
   --- End of inner exception stack trace ---
   at Telerik.Reporting.Cache.Lock..ctor(String key)
   at System.Threading.Thread.ThreadMain_ThreadStart()
   at Telerik.Reporting.Cache.LockProviderWindows.GetLock(String key)
   at Telerik.Reporting.Services.Engine.SyncedQueue.TryDequeue(String& itemId)
   at Telerik.Reporting.Services.Engine.TaskQueue.WorkerThread.ProcessItems()
   at Telerik.Reporting.Services.Engine.TaskQueue.WorkerThread.ThreadProc()
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.Thread.ThreadMain_ThreadStart()
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()System.TypeInitializationException: The type initializer for 'Telerik.Reporting.Cache.Lock' threw an exception. ---> System.PlatformNotSupportedException: Windows Principal functionality is not supported on this platform.
   at System.Security.Principal.SecurityIdentifier..ctor(WellKnownSidType sidType, SecurityIdentifier domainSid)
   at Telerik.Reporting.Cache.Lock..cctor()
   --- End of inner exception stack trace ---
   at Telerik.Reporting.Cache.Lock..ctor(String key)
   at System.Threading.Thread.ThreadMain_ThreadStart()
   at Telerik.Reporting.Cache.LockProviderWindows.GetLock(String key)
   at Telerik.Reporting.Services.Engine.SyncedQueue.TryDequeue(String& itemId)
   at Telerik.Reporting.Services.Engine.TaskQueue.WorkerThread.ProcessItems()
   at Telerik.Reporting.Services.Engine.TaskQueue.WorkerThread.ThreadProc()
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.Thread.ThreadMain_ThreadStart()
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()

System.TypeInitializationException: The type initializer for 'Telerik.Reporting.Cache.Lock' threw an exception. ---> System.PlatformNotSupportedException: Windows Principal functionality is not supported on this platform.
   at System.Security.Principal.SecurityIdentifier..ctor(WellKnownSidType sidType, SecurityIdentifier domainSid)
   at Telerik.Reporting.Cache.Lock..cctor()
   --- End of inner exception stack trace ---
   at Telerik.Reporting.Cache.Lock..ctor(String key)
   at System.Threading.Thread.ThreadMain_ThreadStart()
   at Telerik.Reporting.Cache.LockProviderWindows.GetLock(String key)
   at Telerik.Reporting.Services.Engine.SyncedQueue.TryDequeue(String& itemId)
   at Telerik.Reporting.Services.Engine.TaskQueue.WorkerThread.ProcessItems()
   at Telerik.Reporting.Services.Engine.TaskQueue.WorkerThread.ThreadProc()
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext execution
System.TypeInitializationException: The type initializer for 'Telerik.Reporting.Cache.Lock' threw an exception. ---> System.PlatformNotSupportedException: Windows Principal functionality is not supported on this platform.
   at System.Security.Principal.SecurityIdentifier..ctor(WellKnownSidType sidType, SecurityIdentifier domainSid)
   at Telerik.Reporting.Cache.Lock..cctor()
   --- End of inner exception stack trace ---
   at Telerik.Reporting.Cache.Lock..ctor(String key)
   at System.Threading.Thread.ThreadMain_ThreadStart()
   at Telerik.Reporting.Cache.LockProviderWindows.GetLock(String key)
   at Telerik.Reporting.Services.Engine.SyncedQueue.TryDequeue(String& itemId)
   at Telerik.Reporting.Services.Engine.TaskQueue.WorkerThread.ProcessItems()
   at Telerik.Reporting.Services.Engine.TaskQueue.WorkerThread.ThreadProc()
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.Thread.ThreadMain_ThreadStart()
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()System.TypeInitializationException: The type initializer for 'Telerik.Reporting.Cache.Lock' threw an exception. ---> System.PlatformNotSupportedException: Windows Principal functionality is not supported on this platform.
   at System.Security.Principal.SecurityIdentifier..ctor(WellKnownSidType sidType, SecurityIdentifier domainSid)
   at Telerik.Reporting.Cache.Lock..cctor()
   --- End of inner exception stack trace ---
   at Telerik.Reporting.Cache.Lock..ctor(String key)
   at System.Threading.Thread.ThreadMain_ThreadStart()
   at Telerik.Reporting.Cache.LockProviderWindows.GetLock(String key)
   at Telerik.Reporting.Services.Engine.SyncedQueue.TryDequeue(String& itemId)
   at Telerik.Reporting.Services.Engine.TaskQueue.Wo
Process finished with exit code 6.

Nasko
Telerik team
 answered on 31 Jan 2019
0 answers
80 views

Hello,

I'm Making  grouped report with crosstab according to the following layout:

 

ParentUnit

  SonUnit

ParentOption

  SonOption

SUM(data

ParentUnit2
  SonUnit
ParentOption
  SonOption
SUM(data)

 

The datasource i am using is flat ({parentunit, sonunit, parentoption, sonoption, sum(data)})

Report generation takes too much time 

can you give advice how report can be optimized.

thanks

tamuna
Top achievements
Rank 1
 asked on 31 Jan 2019
Top users last month
Tien
Top achievements
Rank 1
Iron
Krasimir
Top achievements
Rank 3
Bronze
Iron
Iron
Cedar
Top achievements
Rank 1
Iron
Emil
Top achievements
Rank 1
Iron
Kyle Watson
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?