Community Poll

Posted on July 8, 2019 by MarissaRogers

What Motivates You to Participate Here in the PSC?

Passion to help others
27% (27 votes)
Learn Pega
33% (33 votes)
Participate in Ask the Expert sessions
2% (2 votes)
Get answers to my questions
24% (24 votes)
Get recognized as Participant of the week
5% (5 votes)
Network with Pega professionals
6% (6 votes)
Check out what's new at Pega
4% (4 votes)
Total votes: 101
Groups audience: 
Pega Support

Report Definition- Display values across columns

Question posted by JohnPaulRaja,C on December 13, 2018

Hi, Report definition column is configured with Display values across columns, repeating tree grid is sourced from this report definition but configured column is not showing as header. When I run the report definition directly using action, it shows corr ...

ReportingUser interface
Reply posted on December 10, 2019 by JohnPaulRaja,C

No, let us know what you are trying in your scenario

Class Abc-Data-Xyz is mapped to external DB table which has column 'image' of unsupported type LONGBLOB

Question posted by SAKETRANJAN-1 on December 10, 2019

Hi All, We want to get image from an external table present in MySql DB. The pega platform version is 8.1 on cloud and DB is PostgreSQL. When we are trying test the connection and map the column 'image' of type LONGBLOB in data class Abc-Data-Xy ...

Designer StudioData and integrationDatabase management

Charts are not loading after update from 8.2.2 to 8.2.4

Question posted by HerveA09 on October 4, 2019

Hi, i did an Pega patch update from 8.2.2 to 8.2.4. Now all the charts in the application are no more displaying. In few of them, i just see "Loading Chart. Please wait". Any suggestion? Attached you can see a screenshot. Regards, Herve ***Edite ...

Reporting
Reply posted on December 10, 2019 by AnandP

  Hi, We are also facing the same issue. did your issue resolved after raising the SR?  

Chart Type not supported

Question posted by AnandP on December 6, 2019

Hi, We are using Pega 8.2.1 version where we are getting error "Chart Type not supported " while using chart type v6 in report definition as shown in the attached screenshot. However when we use char type v5, it works. Similar behavior was also ...

Reporting
Reply posted on December 10, 2019 by AnandP

Update- We are not able to display chart in a section regardless of what chart type we use. The problem has started after upgrading pega from 7.2.2 to 8.3.1. Please refer to the attachment for more details

Report Definition column values to a single row.

Question posted by AnilB631 on May 30, 2018

Hi, I need to get the values of a single column in many rows to a single row by comma separator. How can i achieve this in report definition? Ex:- Column1 Column2 W-1 a W-1 b W-1 c it should be displayed as below. Column1 Column2 W-1 a,b,c Please let me k ...

Reporting
Reply posted on December 10, 2019 by ChinmayeeParija

This is possible in summary type reports.  

How to get count of every month between two dates?

Question posted by sanjeevj0760 on December 4, 2019

need help to generate a report to show records count of every month between two dates. Example as below.. Thanks ...

Reporting
Reply posted on December 10, 2019 by mahab_GCSPega

Instead, if  you want to do this in a Report Definition, then in the calculation builder, you can reference the function alias Embed-UserFunction.pxDifferenceInMonths. (See screenshot attached) Choose the appropriate one for your database since there...

How to refer Business Calander in "The difference in days between" function in Report Definition Field?(Pega 7.4)

Question posted by JanardhanK0965 on December 1, 2019

Hi, I have a column in Report Definition that will calculate the days between Current date and DeadlineTime date. I use the "The difference in days between" function in the calculation builder in the Report Definition, but I need to refer busine ...

Application developmentReporting
Reply posted on December 10, 2019 by mahab_GCSPega

As Praneeth stated already, this is what you should be using for your DB (see screenshot).     

generate pdf file of a scheduled report containing data and a graph

Question posted by Miguel Calderon on December 8, 2019

I have a report containing data and a chart, and using an agent (scheduled auto-execution) I want to email this report (data and graph) in pdf format. Pega has any OOTB rule to generate the report pdf with the data and chart? attached a screenshot of the ...

Reporting
Reply posted on December 10, 2019 by mahab_GCSPega

Hi Miguel Please see this post that answers your question https://community1.pega.com/community/product-support/question/can-we-directly-attach-pdf-and-send-it-email  

nonaccurate OCR results from Abbyy finereader

Question posted by RawanJ40 on December 2, 2019

Pega 8.1.1 OCR applied to pdf documents through Abby Fine reader is not giving back accurate text, especially pdfs that contain rotated pdfs. I have attached an example of some of the results we get back when uploading a pdf. Another example is "I&qu ...

Data and integrationData management
Reply posted on December 10, 2019 by grabmPega

Dear Rawan, Please double check if you're using the latest version of the Pega OCR component.  Where there are by default turned on parameters responsible for correcting orientation and skew.  Nevertheless please keep in mind that the engine which...