Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Md Kousik (MdKousik)
Nordea
Pega CoE
Nordea
SE
MdKousik Member since 2015 26 posts
Nordea
Posted: May 26, 2016
Last activity: Jul 11, 2017
Posted: 26 May 2016 3:27 EDT
Last activity: 11 Jul 2017 9:17 EDT
Closed
Solved

Export to excel all data in Report Definition 6.1

Hi all,

I need to export all data from Report Definition in 6.1,not the current page. I am looking if the there is any suitale pyfunction in the below step:

Else I have to follow this solution: https://community.pega.com/support/support-articles/report-definition-export-excel-display-all-rows

Please share your views.

Regards,

Kousik

To see attachments, please log in.
Data Integration
Reporting

Accepted Solution

Posted: 8 years ago
Posted: 6 Jun 2016 12:32 EDT
Md Kousik (MdKousik)
Nordea
Pega CoE
Nordea
SE

Hi Lochan,

In 6.1 SP2  we could able to export all data to excel by invoking dynamic SQL query in runtime with help of  pyFilter & pyFields from pyReportContentPage,considering different relationships(Is equal,contains,starts with,Null etc.) in the report definition. We invoked the query from an icon which was incorporated in RRHeaderSection of RD.Desired results from the query are then export to excel using HTML stream.

Hope this helps!

Regards,

Kousik

To see attachments, please log in.
Posted: 8 years ago
Updated: 8 years ago
Posted: 26 May 2016 4:22 EDT
Updated: 26 May 2016 5:33 EDT
Mounika Thatikonda (MounikaThatikonda) Senior Technical Solutions Engineer
Pegasystems Inc.
IN

Hi Kousik,

As per the below pdn link,

https://docs-previous.pega.com/comparison-report-definition-list-view-and-summary-view-rules

export to excel for RD in 6.1 is for current page only.

Screen shot below:

You can follow the solution provided in the Support Article (https://community.pega.com/support/support-articles/report-definition-export-excel-display-all-rows).

Best Regards,

Mounika

To see attachments, please log in.
Posted: 8 years ago
Posted: 26 May 2016 6:41 EDT
Md Kousik (MdKousik)
Nordea
Pega CoE
Nordea
SE

Now I have a list view. Can you give me idea what could be the parameters of Rule-Obj-HTML.ViewExportToExcel?

ViewType,HeadersPageName & DataPageName?

To see attachments, please log in.
Posted: 8 years ago
Posted: 26 May 2016 21:28 EDT
DurgadaVijayakumar (LochanaDurgadavijayakumar)

Hi Kousik,

Thank you for updating us that you have found the solution!

Could you please tell us your solution? It would help other community members if they ever face this issue.

Regards,

Lochan  |  Online Community Moderator  |  Pegasystems Inc.

To see attachments, please log in.

Accepted Solution

Posted: 8 years ago
Posted: 6 Jun 2016 12:32 EDT
Md Kousik (MdKousik)
Nordea
Pega CoE
Nordea
SE

Hi Lochan,

In 6.1 SP2  we could able to export all data to excel by invoking dynamic SQL query in runtime with help of  pyFilter & pyFields from pyReportContentPage,considering different relationships(Is equal,contains,starts with,Null etc.) in the report definition. We invoked the query from an icon which was incorporated in RRHeaderSection of RD.Desired results from the query are then export to excel using HTML stream.

Hope this helps!

Regards,

Kousik

To see attachments, please log in.
Posted: 7 years ago
Posted: 11 Jul 2017 9:17 EDT
giridhar ramisetti (giridharramisetti)
nttdata

nttdata
IN

Export to Excel in Report Definition can not Export All Pages and it Export current page. If I disable paging I can able to export all the data, but we need paging as well.

Can someone share solution to export all the pages in Report Definition.

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice