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
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.
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.
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.
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.
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?
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.
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
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.
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.