This is a migrated thread and some comments may be shown as answers.

PageHeader contains a Text field using PageExec, not exporting to Excel

5 Answers 166 Views
Report Designer (standalone)
This is a migrated thread and some comments may be shown as answers.
Will
Top achievements
Rank 1
Will asked on 09 May 2016, 09:14 PM

Stand Alone Q2 2016

We need to include a value from the first data set record in the page header of reports.  In other report writers (Crystal) you siply put the field into the header and the value in the first record shows up file.

In Telerik it looks like we need to use pageExec and reference a scope.  I am using the following expression in a text field in the header and it is showing up in the report fine.  The scope "ReportHeaderName" is the label of another text field located in the table that is in our detail section. 

[=pageExec("ReportHeaderName",first(Fields.ReportHeaderName))]

The problem I am having is that the field does not get exported to Excel. 

How do I resolve the problem?

5 Answers, 1 is accepted

Sort by
0
Will
Top achievements
Rank 1
answered on 09 May 2016, 09:29 PM

More information...

Exporting to PDF includes the field just fine.

0
Will
Top achievements
Rank 1
answered on 09 May 2016, 09:30 PM
More information...   Exporting to PDF works just fine for this header field.
0
Katia
Telerik team
answered on 12 May 2016, 03:01 PM
Hello Will,

I believe it is the same question that you asked in the ticket #1033333, you can check the reply to the mentioned ticket.

For anyone who's interested, the described behavior is logged in our systems a bug in the exporting mechanism of the HTML5 Report Viewer. When a report is exported to Excel formats from the viewer the result of PageExec function is not displayed.
This issue was logged in our system for further investigation and improvement.

In the meantime, please consider exporting to other formats (page-oriented) if your scenario is similar.

Regards,
Katia
Telerik
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
0
Stephen
Top achievements
Rank 1
answered on 03 Nov 2020, 04:40 PM
was this ever fixed? i'm having the same problem when rendering the report in my action from within my controller.
0
Neli
Telerik team
answered on 06 Nov 2020, 11:31 AM

Hello Stephen,

The priority of the bug is increased. You can check for the updates in our Feedback portal- PageExec is not calculated correctly in Excel renderings.

Regards,
Neli
Progress Telerik

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

Tags
Report Designer (standalone)
Asked by
Will
Top achievements
Rank 1
Answers by
Will
Top achievements
Rank 1
Katia
Telerik team
Stephen
Top achievements
Rank 1
Neli
Telerik team
Share this question
or