Report Body With Custom Section
Hi Guys,
Good evening. Hope you all good.
I have a weird issue related to Report Body with custom section, to display a list of records from Report Definition. The section used to display Body of report, is duplicated as many times as the no of records from Report definition.
My expectation is to bring a list of case related information on Report, which are Resolved. Following are the list of information i would like to display as a grid or table.
- Case ID
- Type of Issue
- Membership Type
- Location State / Province
- Service Provider Name
- Invoice Cost
Out of these 6 properties, properties such as Type of Issue, Membership Type and Service Provider Name are of type integer which stores reference id in it. Since I would like to present label for respective reference ids’, I created a section with Drop Down Controls to achieve it.
When I executed the section separately, it perfectly fetched the records in the way I wanted. However, when I ran the report definition from Designer Studio, I had duplicated grids which repeated as many times as the no of records returned by my report definition.
Kindly refer the attached document for the detailed steps I carried out to emulate the scenario.
Regards,
Prabu Duraipandi
Pegasystems Inc.
IN
Hi Prabu,
Thanks for posting on PSC.
When you are trying to run report definition if it's showing single set of data and if you are facing in seeing repeated sets of data on UI,once can you try enabling "Create Grid Dynamically" on Grid's general tab.
Kindly find the screen shot (captureone) below and see if this fix the issue.
Thank you.
DXC Technology
AU
Hi Komah,
Thanks for your reply.
I tried the approach suggested by you. Unfortunately it did not solve the problem. It still generates duplicate records.
Kindly refer the attached snapshot for your reference.
DXC Technology
AU
Hi Gayatri,
Yes. It is already enabled under my report definition and i have double checked it.
Based on my observation, if i use a section with Basic controls such as Text, Dropdown, Currency etc, it renders the result perfectly. But the appearance of the report does not align with my expectation (Table / Excel Format) hence it defeats the purpose.
Kindly refer the attachments for more info.
Pegasystems Inc.
IN
Hi Prabu,
The behaviour of showing duplicate grids as many records is expected as per your configuration.
Since 'Display rows using custom section' option will replace each row with the section you configured. Since the section is a grid, each row is replaced with the grid.
As per your latest section configuration, including only required basic controls as row(instead of using grid) should be helpful for your requirement. However to achieve table/excel format you can style the elements in dynamic inline layouts in the section accordingly to include outline, border etc so that it resembles a table.
eg:border-style:solid
Hope it helps.
Thanks.
DXC Technology
AU
Hi SreePriya,
Thanks for your response.
I played with different layouts those were potential matches according to my expectation (Inline labels left/ Inline middle / Simple list with labels left etc) under the custom section i created to replace report body. I managed to bring the results as multiple rows by removing the label of each control. However the challenge remained as i was not able to have a Header.
As a next step to resolve this issue, i chose the option "Column Headings Only" under Header Display Section of my Report Definition. To my surprise, it squeezed each record from the report definition, under the first column of my Report.
Kindly refer the snapshots to have a look at it.
If possible, can you provide snapshot of a working sample with key configurations?