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. Image for the cookie policy date
Starting in 2019, the Reporting control is no longer included in Essential Studio. If you're experiencing issues with the Syncfusion Reporting Platform, Report Viewer, Report Designer, or Report Writer, we recommend migrating to Bold Reports, our dedicated reporting platform.

Bold Reports offers a comprehensive suite of tools and features for all your reporting needs, and we will help you make a smooth transition from the discontinued control. Our support team at https://support.boldreports.com/ is here to assist you with any questions or difficulties you may encounter during the migration process.

We thank you for choosing Syncfusion and appreciate your understanding.

ReportViewer does not provide Page Scoped ReportItems

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

1 Reply

YD Yuvaraj Devarajan Syncfusion Team November 21, 2016 12:36 PM UTC

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 


Loader.
Live Chat Icon For mobile
Up arrow icon