Continuous page layout hide and sort report section

Posted by: naiyin on 9 January 2025, 8:01 pm EST

    • Post Options:
    • Link

    Posted 9 January 2025, 8:01 pm EST - Updated 9 January 2025, 8:08 pm EST

    I’m using a Continuous page layout

    In my case, I will have to hide or rearrange a certain report section based on the condition.

    I have different shipping method. Shipvia Air or Ground.

    Each order has an order details page and an attached disclaimers page based on the conditions.

    i.e. Air Shipping Disclaimers should only be visible if its order details page shopvia = air

    Also, Air Shipping Disclaimers should always show after its order details page.

    In this screenshot you can see, that the Air Shipping Disclaimers is not shown after its order ID

    sort_hide_report_section.zip

  • Posted 13 January 2025, 2:43 am EST

    Hi James,

    It seems like you want to show the extra page for air shipping just after the ship information of the order that was shipped via air. AFAIK, you cannot add a report section in between the contents of an existing report section. However, you can show it via a container inside the row of a table and make the row visible based on your condition.

    Also, for the footer, the banded list solution may not help. You may add a report footer and add textboxes to show the footer. For showing the orderIDs based on the running group, you can access the orderID value from any existing textbox from the table that shows orderID on that page. You can also keep that textbox hidden if you don’t want to show it.

    Please see the attached sample and let us know if it fulfills your requirements.

    Attachment:sort_hide_report_section_updated.zip

  • Posted 13 January 2025, 8:59 pm EST - Updated 13 January 2025, 9:14 pm EST

    The thing is each of the page footer needs to have its own info on it. (i.e. the air shipping disclaimers should be shown inside the footer too, also each page should have its own version number since the content could be updated over time)

    There are 3 different page types(order details, Ground/Air Shipping Disclaimers), which means there should be 3 different types of footers.

    Also, each type of page needs to be able to handle overflow properly, the order details page could contain an order activities list which could have 100 items.

  • Posted 14 January 2025, 12:45 am EST

    Hi James,

    This requirement doesn’t seem to get fulfilled by a table simply. You would need a banded list and add a grouping on it based on OrderID. In it’s group header, add the table as it is, and in its group footer, add 3 containers with different footers that you require and set their visibility based on the ShipVia field. Please see the attached sample.

    Attachment:

    BandedListSample.zip

  • Posted 14 January 2025, 11:54 pm EST

    All three types of pages could have long, dynamically generated items(rows could be shown/hidden based on conditions).

    I see you put the second and third pages into the containers, but their height could be dynamic, i.e. Disclaimers content is generated by a list, so putting them in a container might not work. Also, the first page could be hidden in some cases too.

  • Posted 16 January 2025, 12:32 am EST

    Hi James,

    >> I see you put the second and third pages into the containers, but their height could be dynamic, i.e. Disclaimers content is generated by a list, so putting them in a container might not work

    You can try putting the tables of second and third pages also in a banded list instead of a container and put those banded lists in the table rows and set their visibility accordingly. The report seems to be rendering as per requirement, even with large content in the disclaimer section. Please see the attached sample.

    >> Also, the first page could be hidden in some cases too.

    Can you edit the attached sample and show what you mean by hiding the first page and what issue are you facing currently?

    Attachment: BandedListSample.zip

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels