We utilize Subject Headers adding text and Singletons. Works fine.
Hope there is a Simple solution for ...
For such Reports. as above, if we add a new Data Item to the List Report, it adds
Summary Rows, and removes the previously designed Headers and Footers.
Is there a Simple List setting that allows a Designer to add new Data Item(s)
to a List without removing existing Overall and Group Headers and Footers?
TIA, Bob
you have screen shots? there is a simple list but it seems the report headers and singletons things up and made your report really complicated.
Thank you. I am scheduled to be out of the office until next Tuesday, and won't be accessing the App.
The Headers are "more than simple", designed for text labels and singletons.
The Overall and Group Headers unmerge all cells, then carefully merge some of those cells for proper display when we run as Excel.
The "displayed merged cells" begin w/ a Block. Within that Block are (sample data) ...
FY17%: 40% Yes: 2 Total: 5
FY18%: 70% Yes: 7 Total: 10
The List Columns contain Yes and No definitions (calculated for the singletons) so the User can see what is occurring at each Business Unit.
Our FY19 begins on 1 Oct 2018. We want to see all data in the Headers for FY17, FY18, and FY19. That requires adding more Columns (Data Items) for Yes and No FY19 results. These Columns are not rendered but stay in the List.
Right now, dragging in new Columns for FY19 inserts Summary Rows and removes existing Overall and Group Headers/ Footers. Sure, each new FY (if we continue to show all FYs beginning w/ FY17) can author new Headers w/ new text labels and singletons. Does not take that long, but would like to keep previously designed Headers (and Footers).
Please let me know if you have any questions. Thank you, Bob
Perhaps try turning off automatic group and summary behaviour for lists. Open the report for authoring, but then click on the ... in the top bar near the right (you see the preview (eye), properties, and then the ...)
Click on it and select Options from the dropdown list, then click on the Report tab. Then uncheck 'Automatic group and summary behaviour for lists'.
I have seen reference to setting this globally but I haven't done this yet.
Hopefully this helps you.
Thank you Penny.
I will test this, AND report results here, when I return to the App next Tuesday.
Will be excellent if that works.
TIA, Bob
S O L U T I O NQuotePerhaps try turning off automatic group and summary behaviour for lists. Open the report for authoring, but then click on the ... in the top bar near the right (you see the preview (eye), properties, and then the ...)
Click on it and select Options from the dropdown list, then click on the Report tab. Then uncheck 'Automatic group and summary behaviour for lists'.
That WORKS !!! Makes List design MUCH easier.
I need to start adding more "+" in appreciation.
THANK you Penny. Will be adding a "+" for you after posting this.