Telerik Forums
Reporting Forum
1 answer
367 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
720 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
97 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.4K+ 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
900 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.1K+ 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
769 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
53 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
1 answer
91 views

Hi

I have very large report which has over 60k controls, so it becomes almost impossible for me to handle. The main problem occurs when designing page loaded. It shows OutOfMemory Error. Please help me divide report into multiple parts so that i can manage them easily.

 

Thanks in advance.

Nasko
Telerik team
 answered on 30 Jan 2019
3 answers
129 views

Hello,

I am missing the datatype double in dropdownlist of the property "Type".

I become errors in my sourcecode when I try to convert from float to double.

So, I need that datatype.

It is possible to expand the dropdownlist with the datatype double?

Why is double be ommitted? I think it is important.

 

 

Silviya
Telerik team
 answered on 29 Jan 2019
Top users last month
Will
Top achievements
Rank 2
Iron
Motti
Top achievements
Rank 1
Iron
Hester
Top achievements
Rank 1
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Thomas
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?