1. Home
  2. Forum
  3. ASP.NET MVC
  4. ReportViewer does not provide Page Scoped ReportItems
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.
Up arrow icon