We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

ReportViewer does not provide Page Scoped ReportItems

Thread ID:

Created:

Updated:

Platform:

Replies:

127493 Nov 18,2016 12:30 PM Nov 21,2016 07:36 AM ASP.NET MVC 1
loading
Tags: ReportViewer
Fernando Nunes
Asked On November 18, 2016 12:30 PM

Hello,

We're currently using the ReportViewer from the Product Syncfusion EssentialStudio 14.1.0.41 , and we're running into some dificulties trying to have Per Page Sums on the Page Footer, for the currently displayed Tablix Details.


When we try to set a column with the Expression:
=RunningValue(Fields!Price.Value,SUM,"Registrations")
The total is from all pages.

When we try to set in the Footer a TextBox with the Expression: 
="Page Total: " + Sum(ReportItems!Price.Value)
The sum is always zero.

When we try to set in the Footer a TextBox with the Expression: 
="Running Total: " + CStr(Last(ReportItems!RunningTotal.Value))
An exception is thrown rendering the report:
{"errmsg":"An error occurred while processing the report item 'Textbox80' and Sequence contains no elements\n StackTrace: \n   at Syncfusion.RDL.Data.ReportModelContentCollection.Evaluate()\r\n   at Syncfusion.RDL.Data.ReportModel.Evaluate()\n","pgmodel":{"PageData":null,"PaperHeight":0.0,"PaperWidth":0.0,"MarginLeft":0.0,"MarginTop":0.0,"MarginRight":0.0,"MarginBottom":0.0,"TotalPages":0},"pgsetting":{"PaperHeight":1122.519713888207,"PaperWidth":793.700787411,"MarginLeft":0.0,"MarginTop":0.0,"MarginRight":0.0,"MarginBottom":0.0},"isDocumentMap":false}

The exception is coherent with the first failure, because no elements seem to be retrieved, so the SUM is always 0.

Are these unsupported features of the ReportViewer ?

Best Regards,
Fernando Nunes

Attachment: CourseRegistrations_ae5de976.zip

Yuvaraj Devarajan [Syncfusion]
Replied On November 21, 2016 07:36 AM

Hi Fernando, 

Thanks for contacting Syncfusion support. 

We have an issue while using aggregate function for reportitems expression in ReportViewer and we have logged a defect report on this. So a support incident to track the status of this issue has been created under your account. Please log on to our support website to check for further updates.
https://www.syncfusion.com/account/login?ReturnUrl=%2fsupport%2fdirecttrac%2fincidents

Regards, 
Yuvaraj D 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;