Hello, after I have updated WPF Controls and Telerik.Reporting libraries from Q2 2014 to Q1 2016 (WPF NoXAML 2016 Q1), I can't see any data in my reports (except table headers). But there are some errors in output window:

*** ProcessReport #0 STARTED ***
Exception thrown: 'System.OperationCanceledException' in mscorlib.dll
Exception thrown: 'System.OperationCanceledException' in Telerik.Reporting.dll
Exception thrown: 'System.OperationCanceledException' in Telerik.Reporting.dll
*** ProcessReport #0 DONE in 00:00:00.1307766 ***

In my code I do something like this:

var reportSource = new InstanceReportSource {ReportDocument = rep};
reportview.ReportSource = reportSource;
reportview.RefreshReport();

 

Please help me to solve this problem! Thanks

Hi All,
I am trying to make this expression in textbox1 in the report header "= IsNull(Sum(IsNull(Fields.part1,0) - IsNull(Fields.part1,0) + IsNull(Fields.part3,0)),0)" where part1 ,part2 and part3 come from datasource1 

And I have in  a table the detailed section, its datasource is datasource1 
this make result in table duplicated more times 

any suggestion for setting textbox1 with different way  ??

I apologise first for not trying this, but I'm currently out of the office, but have a user request to deal with concerning reporting.

Imagine I have a report with 4 columns -  Col1, Col2, Col3 and Col4

Optionally, the user can request that they do not want Col2 on the report.  Is there an easy way to hide Col2 (that i can do Visible=false), but ensure that Col3 and Col4  (and their headers) then move left to take up that space?

Regards
Paul.

I created a report and I'm encountering this error. My main report is doing fine, but my sub-reports are not. The error is 

"An error has occurred while processing SubReport 'SubReport1': Invalid report type ------------- InnerException ------------- No parameterless constructor defined for this object."

I have 2 sub-reports both of them have this error. The way I connected my main report to its data source which is an XML file located on my hard disk is the same with connecting 2 sub-reports. Can someone tell me what causes this error?

Environment: vb.net, xml data source, .net 4.0, visual studio 2012

Hi, can please someone tell me how can I put a sorting criterion in a totals column in a Crosstab.
I'm using the Visual Studio Report Designer.

Thank you.

Luis Cruz
NCR Angola

Hello,

I'm using wpf reporting and I faced to problem: when the height of the top table increases, it begins to cover the bottom table. What I need to do is to keep the distance between them, and I don't know how to do it. I tried doing that using itemdatabinding event

private void OnItemDataBinding(object sender, EventArgs args)
{
    table1.Location = new PointU(Unit.Cm(0.0D), Unit.Cm(1.2D + table2.Height.Value));
} 

but it doesn't work, because table2's actual height is unknown until report wasn't generated.

So are there any ways to do it?  

Thanks,

Ivan

Hi All,

I am trying to make parameter at report its initial value passed from the code as a parameter 

when I set the value field in the "report parameter editor" = Parameters.param2.Value , the initial value became empty after running the report

The type of 2 parameters is string , one has datasource and the other witch passed from code didn't have 

any suggestion for solution??

 

Hi,

Hello, i'm new in telerik. I want to ask, why when i download the Telerik Reporting (R2 2016) to Excel the header and footer in print preview is just in page 1?

I'm using "Page Header" and "Page Footer" to set header and footer in telerik, when i download in PDF its fine, the header show in every page in print preview. Why just in Excel i cant see the header and footer in the every page?

Best Regards,

Julian Agam Riantiadi

All of my reports shown in the report viewer in my MVC site.

However there is a need to add my own event to the viewer. (i.e. I will add a new button to the view).

My question is how can I get the report name and report parameters via javascript?  I will need this information to pass back to my controller to do my own "custom" action.

After spending several days trying to get the Report Viewer working in an existing MVC5 application, I thought I would layout here the "real" steps you need to do to get this working in a project, including any caveats NOT detailed in Telerik's online resources.  These suggestions are based on all the errors you will get once you've added the "Telerik MVC Report Viewer View R2 2016" item template as suggested in the online forums and documentation.

1.) Startup / Global.asax order of operations IS IMPORTANT!

This comes into play especially for large existing projects which may have a lot of altered startup code in the Global.asax.  You may be tempted to place the Telerik Reporting configuration (Telerik.Reporting.Services.WebApi.ReportsControllerConfiguration.RegisterRoutes(System.Web.Http.GlobalConfiguration.Configuration)) at the end of your "Application_Startup" code.  However, it needs to be placed JUST right. 

In most existing apps there may already be setup code for the WebApi routes (specifically "GlobalConfiguration.Configure(YourRegisterWebApiCode)").  If the call to your "GlobalConfiguration.Configure(...)" method comes BEFORE the Telerik reporting registration, you will NEVER be able to browse your reports and will have all kinds of issues, nor will you be able to even browse to "/api/reports/formats".  Although not mentioned anywhere in the documentation, this is because the default routes setup for the WebApi already have a "Default" route which will get hit before even trying to resolve the Telerik ones (essentially overriding the Telerik ones).  Once you register the Telerik reporting BEFORE your calls to register your custom routes "GlobalConfiguration.Configure(...)", everything is just fine!

2.) You get exceptions about "Telerik.Reporting.OpenXmlRendering.dll".
The report may still render, however, you run across this exception:
An exception of type 'System.TypeInitializationException' occurred in Telerik.Reporting.OpenXmlRendering.dll and wasn't handled before a managed/native boundary.

Upon further inspection of the Inner Exceptions, you may see:
Could not load file or assembly 'DocumentFormat.OpenXml' or one of its dependencies.
The system cannot find the file specified.":"DocumentFormat.OpenXml, Version=2.0.5022.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"

Adding a nuget reference to Microsoft's "DocumentFormat.OpenXml" will most likely fix this part, but there are more exceptions to fix yet...

3.) "InvalidCastException" occured:

After fixing the issue from #2, you may run across this exception:
An exception of type 'System.InvalidCastException' occurred in Telerik.Reporting.dll and wasn't handled before a managed/native boundary
Additional information: Specified cast is not valid.

Additional information: The type initializer for 'Telerik.Reporting.OpenXmlRendering.Wordprocessing.WordprocessingReport' threw an exception.
Additional information: The type initializer for 'Telerik.Reporting.OpenXmlRendering.Presentation.PresentationReport' threw an exception.
Additional information: The type initializer for 'Telerik.Reporting.OpenXmlRendering.Spreadsheet.SpreadsheetReport' threw an exception.

Oh so helpful! But what you may need to do (especially since the Telerik dlls are not on the current "DocumentFormat.OpenXml" version) is simply add this xml section into your web.config under the "runtime/assemblyBinding" section (of course, once you've followed #2 above):

<runtime>
        <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">

<dependentAssembly>
    <assemblyIdentity name="DocumentFormat.OpenXml" publicKeyToken="31bf3856ad364e35" />
    <bindingRedirect oldVersion="1.0.0.0-2.5.65535.65535" newVersion="2.5.5631.0" />
</dependentAssembly>

 

And viola!  Now your reports should run without errors!