I have a report that contains several tables and multiple sections. For example I have the following:
TABLE 1
TABLE 2
BEGIN SECTION A
TABLE 3
END SECTION A
BEGIN SECTION B
TABLE 4
BEGIN SECTION C
TABLE 5
END SECTION C
END SECTION B
Now I want to create a new section just in between Table 2. However, when I insert an object to create the section, the end of the section is set after SECTION B.
How can I just create a section for Table 2 in WEBI?
By default if you place any section in the middle of a table the end section will come at the end of the table.
Better u delete the existing sections and the place section u want first and place the tables below the end section of table b and apply the remaining sections.
You cannot add anything in between section headers or detail blocks.
You can only do a sort on the section header if I am not wrong.
What is your exact requirement, maybe a workaround can be suggested.
A bit off topic but related. How can I create multiple sections one after another? I can only create nested sections. Wherever I drop the master cell for the second section, it always create a parent section of the existing section.
BTW, I’m using BO 6.5. Is it a limitation of 6.X (applogize for posting 6.5 questions in this forum. I didn’t find any articles relevent to my issue. I just hope some gurus here (haider?) know how 6.X works)
Multiple sections are nested by design.
One thing you can still do in full client report (not applicable to WebI report) is that the second section can be shown after the detail block of first section(parent) for each value.
For this apply section on Year (from eFashion), go to slice and dice panel, add quarter to the section and right click on it to ‘deactivate’.
In the report you will see quarter section values below detail block of Year(parent) section. Then copy the detail block and paste it under quarter section. Go to slice and dice again, click on new table tab, right click quarter and choose ‘activate this section and all sections above’.
Try to do this on one value of Year so that the format looks clear.
Your trick works to some extent. However, what I need is to put the second section outside of the section 1 so that I can add constant blocks (e.g. a title) in between. With your trick, although I can put the second section after section 1, I can’t add anything in between, or it will appear in every block of the section 1 (for each master cell value).
(BOB member since 2007-09-02)
(BOB member since 2005-07-18)