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.
Type of Issue
Location State / Province
Service Provider Name
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.
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.
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.
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.
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?