Question
Inovar
SA
Last activity: 17 Feb 2021 10:20 EST
Display report Defination Data in Tabular Format
Hi Team,
I have an requirement i.e I have to write an report definationw hich fetches the count of work items for each coverage level and display the results in below tabular format . Coverage Level property will have any of the four possible values i.e Standard, Gold, Silver, Bronze
Status Gold Silver Bronze Standard
Open 23 34 45 34
Pending-Fulfilment 5 34 34 45
Like this i should diaply number of work items for each status based on category level.
***Edited by Moderator: Lochan to update platform capability tags***
Accepted Solution
Pegasystems Inc.
IN
Hi,
Kindly follow the below steps.
In the report definition add the following columns
Add Status, pyStatusWork (in 2 columns and for one column select summarize by count).
Then in the column for status click the gear icon and select the option- 'Display values across columns'
Then run the report you will see the result as follows -
Hi,
Kindly follow the below steps.
In the report definition add the following columns
Add Status, pyStatusWork (in 2 columns and for one column select summarize by count).
Then in the column for status click the gear icon and select the option- 'Display values across columns'
Then run the report you will see the result as follows -
Hope this solves the requirement.
Regards,
Pegasystems Inc.
IN
Hi Gowtham,
Create a trend report as in the below link and select the checkbox "Display values across columns" for columns whose values has to be displayed as columns
https://community.pega.com/knowledgebase/articles/how-create-trend-reports-report-definition-rules
Thanks.
Accepted Solution
Pegasystems Inc.
IN
Hi,
Kindly follow the below steps.
In the report definition add the following columns
Add Status, pyStatusWork (in 2 columns and for one column select summarize by count).
Then in the column for status click the gear icon and select the option- 'Display values across columns'
Then run the report you will see the result as follows -
Hi,
Kindly follow the below steps.
In the report definition add the following columns
Add Status, pyStatusWork (in 2 columns and for one column select summarize by count).
Then in the column for status click the gear icon and select the option- 'Display values across columns'
Then run the report you will see the result as follows -
Hope this solves the requirement.
Regards,
Inovar
SA
Hi Handr1,
Is it possible not to have expand icon for case Status , so that it looks in an perfect atbular view with rows and columns.
Regards
Gowtham